RE: Calling a procedure from a procedure

From: Bala, Prakash <prakash.bala_at_cingular.com>
Date: Wed, 16 Jan 2002 09:48:01 -0800
Message-ID: <F001.003F189B.20020116085523@fatcity.com>

Lance,
just remove the word 'execute'

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Lance Prais   [mailto:lprais_at_ts.checkpoint.com]Sent: Wednesday, January 16, 2002   10:57 AMTo: Multiple recipients of list ORACLE-LSubject:   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; Received on Wed Jan 16 2002 - 11:48:01 CST