Ad Widget

Collapse

How to execute e begin block code and select in zabbix database monitor using odbc?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • solaireofastora
    Junior Member
    • Nov 2023
    • 6

    #1

    How to execute e begin block code and select in zabbix database monitor using odbc?

    I can't write the exact PL/SQL block I am trying to execute, but is something like this example:

    Code:
    begin
    null;
    end;
    select * from dual;
    it does not work, neither in zabbix or sqlplus

    the code bellow works in sqlplus, but does not work in zabbix because it does not undestand the /
    Code:
    begin
    null;
    end;
    /
    select * from dual;
    How can I execute a begin block code (I need to execute it to process the value) and the select to retrive the value.​​

    The code above is only a example, the point is execute a begin block and then a select query.
    Last edited by solaireofastora; 21-11-2023, 17:03.
Working...