Re: call stored procedure from a stored procedure

Let say you have my_procedure1 (param1 IN VARCHAR, param2 OUT VARCHAR);

In procedure2 code you could write:

PROCEDURE my_procedure2 AS

   par_1 VARCHAR2(10) := "My Test";
   par_2 VARCHAR2(5);

BEGIN    my_procedure1(par_1, par_2);
   DBMS_OUTPUT.PUT_LINE(par_2);

• etc

END; HTH Witold

"Woody Mckay" <wmckay_at_hydrogenmedia.com> on 05/03/2001 12:25:49

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Witold Iwaniec/ATL_BLUECROSS_CA)

Please help,

Sorry if this sounds like a dumb question but I'm having a hard time finding examples of how to call a stored procedure with IN and OUT parameters from another stored procedure. Any resources or examples.

TIA, Woody

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Woody Mckay
  INET: wmckay_at_hydrogenmedia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Witold.Iwaniec_at_atl.bluecross.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).