RE: Calling a procedure from a procedure

From: Todd Carlson <tcarlson_at_tripos.com>
Date: Wed, 16 Jan 2002 10:05:26 -0800
Message-ID: <F001.003F1861.20020116084030@fatcity.com>

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>Don&#8217;t use the execute.

<span style='font-size:

10.0pt;font-family:Arial;color:blue'>Primus_Dump_TEST_2(Solution);

<span style='font-size:

10.0pt;font-family:Arial;color:blue'> 

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:

12.0pt'>Todd Carlson

<span style='font-size:

12.0pt'>Oracle Database Administrator

<span style='font-size:

12.0pt'>Tripos, Inc.

<span style='font-size:

12.0pt'>(314) 647-8837 Ext.3246

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: root_at_fatcity.com
[mailto:root_at_fatcity.com] 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

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>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);

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>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.

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>I am using Toad as my editor.

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>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 - 12:05:26 CST