Hi Folks,

Can you guys help me with the solution of how to pass the array or list of String to a stored procedure

I'm using the following API

String[] paramlist ={"Hello","Hi"};
createSQLQuery("Stored procedure call here ").setParameterList(
"paramlist",paramlist,Hibernate.STRING);

Oracle Procedure :

create or replace
PROCEDURE STORED_PROCEDURE_DELETE_LIST (PARAM_LIST IN PARAMLIST)
IS

Type created:
create or replace
TYPE PARAMLIST
IS TABLE OF VARCHAR2(50)
;