RE: Calling a procedure from a procedure

[Bala, Prakash]

Lance, just remove the word 'execute'

-----Original Message-----
From: Lance Prais [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 10:57 AM
To: Multiple recipients of list ORACLE-L
Subject: Calling a procedure from a procedure

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;