retrieve data in PL/SQL proc using JDBC in Websphere
Joined: Mar 13, 2003
I am trying to retrieve a list of address locations from our database based on a user id and account number. I keep getting an ORA-06550 error. Here is my package spec:
Here is a code snippet from my test class (I have already created my connection, that part has tested successfully with other PL/SQL procs):
Any help would be most appreciated! Thanks in advance!
Joined: Sep 28, 2001
I have not looked up the error code, but I guess it is something to do with the ARRAY. see the thomas kyte website on how to do this correctly - or I think i posted an example in the oracle forum a few months ago..