Urgent: DBMS_SQL.PARSE - Raising ORA-01009: missing mandatory parameter [message #301064] |
Tue, 19 February 2008 02:04  |
shasikkumar
Messages: 8 Registered: February 2008 Location: India
|
Junior Member |
|
|
Hi all,
In my PLSQL program unit while executing the DBMS_SQL.PARSE - I am getting the following error while running the PLSQL program (No Compilation Errors)
ORA-01009: missing mandatory parameter
The following is the exact statement in my PLSQL program unit,
DBMS_SQL.PARSE(CURSOR_NAME ,G_RULE_SOURCE ,G_RULE_START,G_RULE_END ,FALSE,DBMS_SQL.V7);
I have opened the cursor prior to this statement using CURSOR_NAME := DBMS_SQL.OPEN_CURSOR;
G_RULE_SOURCE has the value of 1
G_RULE_START has the value of 1
G_RULE_END has the value of 1
Please let me know - If this problem is specific in 11g - Experts please advice !!
Thanks,
Shasi
|
|
|
|
|
Re: Urgent: DBMS_SQL.PARSE - Raising ORA-01009: missing mandatory parameter [message #301212 is a reply to message #301206] |
Tue, 19 February 2008 10:27  |
shasikkumar
Messages: 8 Registered: February 2008 Location: India
|
Junior Member |
|
|
Hi,
Sorry in the debug, I had taken a count of VARCHAR array by mistake and posted in the forum.
Actually, we frame the SQL statement processing through a loop. But unfortunately in my case, the loop is iterated only once due to some failure rendering the variable array to hold the sql statement as null.
Hence the error.
I checked the condition based on which iteration is happening and rectified it. Now it works fine.
Thanks,
Shasi
|
|
|