Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What Solution?

JulioN64Feb 2 2009 — edited Feb 2 2009
FUNCTION CallFunc(p1 OUT VARCHAR2,
p2 IN VARCHAR2)
RETURN VARCHAR2 AS
BEGIN
DBMS_OUTPUT.PUT_LINE('CallFunc called with ' || p2);
p1:='OPERACOES';
RETURN 'Teste de msg';
END CallFunc;


Declare
myResult varchar2(50);
myResult2 varchar2(50);
begin
execute immediate 'CALL PK_JCTESTE.CallFunc(:myResult,''Teste de chamada'') into :myResult2 ' using out myResult, myResult2;
dbms_output.put_line(myResult);
dbms_output.put_line(myResult2);
end;

Error ORA-06536...
This post has been answered by 170207 on Feb 2 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2009
Added on Feb 2 2009
4 comments
352 views