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?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center