How to call oracle stored procedure which include user-defined type in java?

Viewed 60603

In Oracle DB:

I have the following stored procedure:

procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor )

Type IDS_TABLE is:

create or replace type IDS_TABLE as table of IDS    

create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER )

How can I call getInfo in Java?

4 Answers
Related