PL/SQL (MOSC)

MOSC Banner

Passing input array from sqlplus or shell script

edited Jun 29, 2010 6:44AM in PL/SQL (MOSC) 1 commentAnswered
All,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center