From Stephen_Karniotis@compuware.com Wed, 16 Jan 2002 09:11:12 -0800
From: "Karniotis, Stephen" <Stephen_Karniotis@compuware.com>
Date: Wed, 16 Jan 2002 09:11:12 -0800
Subject: RE: Calling a procedure from a procedure
Message-ID: <F001.003F17C5.20020116082530@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain









<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@Compuware.com"><span
style='font-size:12.0pt;color:red'>Stephen.Karniotis@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@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'>