开发者

pass object from Java to Oracle procedure

开发者 https://www.devze.com 2023-02-15 05:27 出处:网络
To pass an array to oracle procedure we use ArrayDiscriptor and ARRAYobjects. What objects do I ha开发者_如何学Gove to use to pass an object to

To pass an array to oracle procedure we use ArrayDiscriptor and ARRAY objects. What objects do I ha开发者_如何学Gove to use to pass an object to a stored procedure?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号