Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01009-missing mandatory parameter

 
Reeti Saha
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Reeti Saha
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try to forward the code.I will check in my system.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic