Re: Assign Procedure OUT parameter to a variable?

Hallo April!

Just a guess:

procedure proc1(pi_VarIn In Varchar2, po_VarOut Out Number) 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.

<april.mcclellan_at_HydroOne.com> schrieb in im Newsbeitrag: 2F96BE4C7CC6D211A55F0008C7A43976017424EC_at_OHSC-EX4...
> Is it possible to assign the OUT parameter of a procedure to a variable?
> I have tried the following:
>
> v_BidNo := SPINSERTBIDNO;
>
> This generates the error PLS-00306 : Wrong number ot types of arguments in
> call to SPINSERTBIDNO.
>
> How can I get the value returned from a procedure when calling that
> procedure from another procedure?
>
> Thanks very much,
>
> April McClellan
>
>
> --
> Posted from thor.hydroone.com [192.75.116.12]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Apr 03 2001 - 15:33:03 CDT