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);
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.
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;
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;
