RE: Calling a procedure from a procedure

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Wed, 16 Jan 2002 09:11:12 -0800
Message-ID: <F001.003F17C5.20020116082530@fatcity.com>

<font size=2 color=navy

face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt; font-family:"Comic Sans MS"'>Remove the word execute.<span style="mso-spacerun: yes">  Within PL/SQL you do not need EXECUTE.<span style="mso-spacerun: yes">  That is a SQL*Plus command.

<font size=2 color=navy

face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt; font-family:"Comic Sans MS"'> 

<!---size:11.0pt;

mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element: field-begin'> AUTOTEXTLIST
\s "E-mail Signature" <span
class=EmailStyle18><i style='mso-bidi-font-style: normal'><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:"Monotype Corsiva"; color:#3366FF;font-weight:bold;font-style:italic'>Thank You

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'> 

<b style='mso-bidi-font-weight:

normal'><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:Tahoma;mso-bidi-font-family:Arial; color:blue;font-weight:bold'>Stephen P. Karniotis

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Technical Alliance Manager

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Compuware Corporation

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Direct:<span style='mso-tab-count:1'>          (248)
865-4350

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Mobile:<span style='mso-tab-count:1'>          (248)
408-2918

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Email:<span style='mso-tab-count:1'>             <a
href="mailto:Stephen.Karniotis_at_Compuware.com"><span style='font-size:12.0pt;color:red'>Stephen.Karniotis_at_Compuware.com

<font size=2 color=red

face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Web:<span style='mso-tab-count:1'>              <a href="http://www.compuware.com/"><span style='font-size: 12.0pt;color:red'>www.compuware.com

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial;mso-bidi-font-weight:bold'> 

<!---size:11.0pt;

mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element: field-end'><font
size=2 color=navy face="Comic Sans MS"><span style='font-size:11.0pt; mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'> 

<font size=2 color=black

face=Tahoma>-----Original
Message-----
From: Lance Prais
[mailto:lprais_at_ts.checkpoint.com]
Sent: Wednesday, January 16, 2002
10: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='color:black;mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<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='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>I am using Toad as my editor.<span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<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;<span

style='color:black;mso-color-alt:windowtext'> Received on Wed Jan 16 2002 - 11:11:12 CST