Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Assign Procedure OUT parameter to a variable?

Assign Procedure OUT parameter to a variable?

From: <april.mcclellan_at_HydroOne.com>
Date: Tue, 3 Apr 2001 15:52:05 +0000 (UTC)
Message-ID: <2F96BE4C7CC6D211A55F0008C7A43976017424EC@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 - 10:52:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US