I can't write the exact PL/SQL block I am trying to execute, but is something like this example:
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 /
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.
Code:
begin null; end; select * from dual;
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;
The code above is only a example, the point is execute a begin block and then a select query.