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