Passing input array from sqlplus or shell script
I have a stored procedure which is usually called from a java program. One of it's input parameters uses a user-defined type called EVENTARRAY which is created as such:
CREATE TYPE eventarray as table of varchar2(256);
The stored procedure parameters are defined as:
procedure mmjacdagentinfo(v_tenantid IN VARCHAR2,
v_queuetn IN VARCHAR2,
v_extlist IN eventarray,
v_stimestamp IN VARCHAR2,
v_etimestamp IN VARCHAR2,
cv_timeanswered OUT sap_types.GenericCurType)
as ....
I would like to test this by running the stored procedure from sqlplus or from a shell script instead of from the java program, but I can't figure out how to input the values for the v_extlist array variable. (I can use either Solaris or Linux servers to test this.) Can anyone help me?