RE: Calling a procedure from a procedure

[Karniotis, Stephen]

Remove the word execute.  Within PL/SQL you do not need EXECUTE.  That is a SQL*Plus command.   Thank You   Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct:          (248) 865-4350 Mobile:          (248) 408-2918 Email:             [EMAIL PROTECTED] Web:              www.compuware.com     -----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;