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

Home -> Community -> Mailing Lists -> Oracle-L -> Calling a procedure from a procedure

Calling a procedure from a procedure

From: Lance Prais <lprais_at_ts.checkpoint.com>
Date: Wed, 16 Jan 2002 09:27:18 -0800
Message-ID: <F001.003F16E2.20020116075651@fatcity.com>

I need to execute a procedure with in
a loop of another.  I need to pass a variable to the second procedure.  I am using Execute, looks like this:Execute Primus_Dump_TEST_2(Solution);
 

Getting this error:PLS-00103:
Encountered the symbol "PRIMUS_DUMP_TEST_2" when expecting one of the following:   := . ( @ % ;The symbol ":=" was substituted for "PRIMUS_DUMP_TEST_2" to continue.
 

I am using Toad as my
editor.
 

I am doing it as follows: 
Open Primus_solution; 

loop                                   

/* Add next three lines */    fetch primus_solution into solution;    exit when
primus_solution%NOTFOUND; dbms_output.put_line (Solution); Execute Primus_Dump_TEST_2(Solution);  End LOOP;  Close Primus_solution; Received on Wed Jan 16 2002 - 11:27:18 CST

Original text of this message

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