What Solution?
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...