All geek questions in one place

Pass an object from Java to an Oracle procedure

To pass an array in oracle procedure we use ArrayDiscriptorand ARRAY objects. What objects should I use to pass an object to a stored procedure?

+3
source share
1 answer

The ArrayDesciptor and ARRAY classes (as well as StructDescriptor and STRUCT) belong to Oracle TYPES - that is, objects like something are created ...

create type my_obj as object( id varchar2(x), etc );

If you have access to java, you should see where the ArrayDescriptor is constructed and get the name of the database type from it.

You can use these types of oracles as parameters for functions and procedures.

+1
source

Source: https://habr.com/ru/post/1796565/

More articles:


All Articles