pass object from Java to Oracle procedure

Question

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?

Is the Oracle procedure written in PL/SQL or Java?

Jim Garrison
– Jim Garrison

2011-03-06 01:37:01 +00:00
Commented Mar 6, 2011 at 1:37 — Jim Garrison
– Jim Garrison, Commented Mar 6, 2011 at 1:37
Orcale procedure written in PL/SQL .

palAlaa
– palAlaa

2011-03-06 01:39:28 +00:00
Commented Mar 6, 2011 at 1:39 — palAlaa
– palAlaa, Commented Mar 6, 2011 at 1:39
Dupe - Pass array to Oracle Procedure

Sathyajith Bhat
– Sathyajith Bhat

2011-03-06 13:24:00 +00:00
Commented Mar 6, 2011 at 13:24 — Sathyajith Bhat
– Sathyajith Bhat, Commented Mar 6, 2011 at 13:24

cagcowboy · Accepted Answer · 2011-03-06 11:37:34Z

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.

answered Mar 6, 2011 at 11:37

cagcowboy

31.1k11 gold badges75 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pass object from Java to Oracle procedure

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related