RE: Calling a procedure from a procedure

2002-01-16 Thread 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;

Calling a procedure from a procedure

2002-01-16 Thread Lance Prais 



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;

Re: Calling a procedure from a procedure

2002-01-16 Thread Rachel Carmichael 

I believe you don't need the execute within pl/sql

--- Lance Prais [EMAIL PROTECTED] wrote:
 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;
 
 


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Calling a procedure from a procedure

2002-01-16 Thread Bala, Prakash 



Lance, 
just remove the word 'execute'

  -Original Message-From: Lance Prais 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 
  10:57 AMTo: Multiple recipients of list ORACLE-LSubject: 
  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;

RE: Calling a procedure from a procedure

2002-01-16 Thread Todd Carlson 









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