How to call Oracle procedure have Userdefined "Type" IN parameters using jdbc in java -
this question has answer here:
i have created below user defined type in oracle. using type in procedure in parameter. how call procedure using jdbc callablestatement.
create or replace type "varchar_tab"
table of varchar2(500);
my procedure is:
procedure delete_album_metadata ( p_catalog_tab in varchar_tab );
please me.
you need use setplsqlindextable binder method defined in oracle.jdbc.oraclepreparedstatement.
here pointer javadoc:
Comments
Post a Comment