RE: Calling a procedure from a procedure

[Todd Carlson]

Don’t use the execute. Primus_Dump_TEST_2(Solution);     Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Lance Prais Sent: Wednesday, January 16, 2002 9: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;