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