Trying to run Oracle Stored Procedure Results in: ORA-00900: invalid SQL statement

berimbolo 0
Viewed 15

How can I run the following code in DBEAVER? It will not execute the stored procedure and I have been told the code is OK to execute in SQL+ and Toad.

set serveroutput on;
set autoprint on;
var x0 refcursor;
var x1 refcursor;
exec pkg_organisation.p_list_org_by_uuid(123456, :x0, :x1);

I asked a DB dev to run this in toad, I dont have a licence and the procedure works as expected, but I would like to run this in DBEAVER.

With the set statements left in I get the following error:

SQL Error [922] [42000]: ORA-00922: missing or invalid option

  Error : 922, Position : 4, Sql = set serveroutput on, OriginalSql = set serveroutput on, Error Msg = ORA-00922: missing or invalid option

  ORA-00922: missing or invalid option

And if I remove these (as it appears this is what DBEAVER complains about), I get the following error:

SQL Error [900] [42000]: ORA-00900: invalid SQL statement

  Error : 900, Position : 0, Sql = var x0 refcursor, OriginalSql = var x0 refcursor, Error Msg = ORA-00900: invalid SQL statement

  ORA-00900: invalid SQL statement

I am using the Execute Script option to try to run the stored procedure and I would like to be able to get up and running with testing the procedures.

dbeaver
0 Answers
Related