| Author |
retrieve data in PL/SQL proc using JDBC in Websphere
|
jso113
Greenhorn
Joined: Mar 13, 2003
Posts: 1
|
|
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!
|
 |
SJ Adnams
Ranch Hand
Joined: Sep 28, 2001
Posts: 925
|
|
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..
|
 |
 |
|
|
subject: retrieve data in PL/SQL proc using JDBC in Websphere
|
|
|