No more Blub for me, thank you, Vicar.
No more Blub for me, thank you, Vicar.
chris webster wrote:One more thing you might find useful: You can use a "TABLE" function to convert a PL/SQL collection into something that you can treat like a regular table inside a SELECT statement. Check here under "Selecting From A Collection Based On A VARRAY". This might help you find a way to use your input array inside your SQL, for example.
No more Blub for me, thank you, Vicar.
chris webster wrote:The error message tells you what Oracle thinks is wrong:
Are you really running exactly the same Java and PL/SQL code on two databases (can you even be sure, given how unreadable your PL/SQL code is)? If so, then it must be the argument values that are wrong, so check that each parameter is being provided and is being set correctly. Also, try calling the PL/SQL directly using the same values via SQLDeveloper or in your SQL*Plus shell. If it works, then the problem must be on the Java side. Keep breaking the process up into small testable chunks until you find the problem.
But you *really* need to re-write this PL/SQL code, as it is not the kind of thing that any self-respecting Oracle professional should permit in a production system.
rajnish patel wrote:
chris webster wrote:The error message tells you what Oracle thinks is wrong:
Are you really running exactly the same Java and PL/SQL code on two databases (can you even be sure, given how unreadable your PL/SQL code is)? If so, then it must be the argument values that are wrong, so check that each parameter is being provided and is being set correctly. Also, try calling the PL/SQL directly using the same values via SQLDeveloper or in your SQL*Plus shell. If it works, then the problem must be on the Java side. Keep breaking the process up into small testable chunks until you find the problem.
But you *really* need to re-write this PL/SQL code, as it is not the kind of thing that any self-respecting Oracle professional should permit in a production system.
Sir I've found problem of this problem, While executing the query from toad I dont understand what to enter in HIGHLIGHTED area as its an array. The procedure name is same as posted above in the Question. Kindly refer the image attached in below URL.
Toad Query Execution image