An error was encountered with a procedure not returing any value. See below for example.
Given a stored procedure:
Create or Replace procedure p (p_random out varchar2)
is
begin
p_random := 'foo';
end;
/
...
In sqplus command line this can be done: See below for result:
var v varchar2(100)
exec p(:v);
print :v;
returns...
PL/SQL procedure successfully completed.
V
However, executing these same commands in a SQL-style tab in Toad editor returns:
PL/SQL procedure successfully completed.
Bind variable ":v" however not declared.
The only workaround for this is to exetcute with sqlplus via Toad editor (obviously). Please advise.
Is it ER worthy?
WORKAROUND:
Execute query with SQLPLUS via Toad Editor.
Toad | View | Execute SQL via SQLPLUS.
STATUS:
Waiting for fix in a future release Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center