2 replies to this topic

[red]

Hi all,
i have a problem,
I have procedure in oracle with one parameter in input and one parameter in output.

Example:

create or replace procedure prova_proiv(p_in in varchar2, p_out out varchar2) is
begin
if nvl(p_in, [email=""]'@'[/email]) = 'A' then
p_out:='0';
else
p_out:='1';
end if;
end prova_proiv;


In proiv how can receive a parameters?

$PAR1 = 'C'
$PAR2 = ''
SQL
DECLARE PAR VARCHAR2(1) :=:$PAR1;
DECLARE TOR VARCHAR2(1) :=:$PAR2;
BEGIN
CALL PROVA_PROIV(PAR,TOR);
END;
ENDSQL

UMSG('$PAR1:' + $PAR1 + '-' + $PAR2,-1)


REGARDS IN ADVANCE
RED

[Chris Mackenzie]

use a function instead to return the value. or wrap the procedure in
a function. Then you can use it in SELECT statement.

[red]

thanks

therefore with a "select" is a unique solution to use an store procedure parameters output ?

there is a another solution using a sql function or package....