aspose file tools*
The moose likes JDBC and the fly likes ORA-01009-missing mandatory parameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01009-missing mandatory parameter" Watch "ORA-01009-missing mandatory parameter" New topic
Author

ORA-01009-missing mandatory parameter

Reeti Saha
Ranch Hand

Joined: Jun 26, 2001
Posts: 34
Hi:
I've written a sql and want to get the result from oracle. The sql is running properly from oracle. But while I'm trying to execute it from java it's giving error saying
ORA-01009-missing mandatory parameter
The sql is very big.
How to solve this problem.
Pls. help. It's urgent
Regards
Reeti
DAYANAND BURAMSHETTY
Ranch Hand

Joined: Aug 06, 2001
Posts: 34
Hi,
write dubug statement for display the sql query statement
and check.Sometimes we forget to write , like...etc.Then
it gives the error.Try to forward the code.


Dil se....,<BR>Dayanand<BR>0065-8839071(off)<BR>0065-7547034(Res0
Reeti Saha
Ranch Hand

Joined: Jun 26, 2001
Posts: 34
the sql is ok... but it's so big that it's not able to send such a big sql. That's my problem.. the whole sql is not going in the database.
DAYANAND BURAMSHETTY
Ranch Hand

Joined: Aug 06, 2001
Posts: 34
Try to forward the code.I will check in my system.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

This is what Oracle says:
"ORA-01009: missing mandatory parameter
Cause: A host language program call did not pass all required parameters. The syntax and parameter description for each call is shown in the Programmer's Guide to the Oracle Precompilers.
Action: Check the syntax for the call and enter all required parameters."
The only way to know if the SQL you are sending from your program is the same as the one that works in your SQL*Plus session is to do the following:

after running the code, cut and paste the actual code printed from System.out.println(query); to the SQL*Plus session and run it. This is the only way to know if the statement you have created will actually work.
Jamie
Just a side note, I don't know how large your query statement is but I have successfully executed statements with over 50 fields returned on a triple join with subqueries in it. It took a little time, but it came back with a resultset!

[This message has been edited by Jamie Robertson (edited August 10, 2001).]
 
Don't get me started about those stupid light bulbs.
 
subject: ORA-01009-missing mandatory parameter