To pass an array to oracle procedure we use ArrayDiscriptor and
ARRAY objects. What objects do I have to use to pass an object to
a stored procedure?
Asked
Active
Viewed 1,924 times
3
Jean-François Corbett
- 37,420
- 30
- 139
- 188
palAlaa
- 9,500
- 33
- 107
- 166
-
Is the Oracle procedure written in PL/SQL or Java? – Jim Garrison Mar 06 '11 at 01:37
-
Orcale procedure written in PL/SQL . – palAlaa Mar 06 '11 at 01:39
-
Dupe - [Pass array to Oracle Procedure](http://stackoverflow.com/questions/5198856/pass-array-to-oracle-procedure) – Sathyajith Bhat Mar 06 '11 at 13:24
1 Answers
1
The ArrayDesciptor and ARRAY classes (as well as StructDescriptor and STRUCT) map to Oracle TYPES - i.e. objects created something like...
create type my_obj as object( id varchar2(x), etc );
If you have access to the java, you should be able to see where the ArrayDescriptor is constructed and get the database type name from that.
You can use these oracle types as parameters to functions and procedures.
cagcowboy
- 30,012
- 11
- 69
- 93