Re: Assign Procedure OUT parameter to a variable?

Correct Version!!!

procedure proc1(pi_VarIn In Varchar2, po_VarOut Out Varchar2) as
begin
...
...

• setting of the out-parameter of Proc1 po_VarOut := pi_VarIn;
  ...
  end proc1;

procedure proc2(...)
as
  p_VarOutProc1 Varchar2(1000);
...

begin
...

• call of proc1 (with named notation of parameters) proc1(pi_VarIn => 'VarIn', po_VarOut => p_VarOutProc1); ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  • assignment of the out-parameter of proc1 to variable p_VarOutProc1
    ...
    end proc2;

HTH,
Stefan. Received on Tue Apr 03 2001 - 15:42:59 CDT