|
-
The Oracle version of an array would be a PL/SQL table or a
varray. SInce PL/SQL table is not supported by Java, I think you can use varray to pass and get values from Java.
For multi dimensional arrays what you can do is define an object type for ex:
create type employee as object(colum1,colum2);
create type emp_table as varray of employee;
and the Jave procedure should also create the array in the same name and then it would be possible to pass it to Oracle and vice versa.
Hope this helps you.
Kavita
KN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|