[sqr-users] Calling a stored procedure with an array parameter

["Howard Thompson" <thompsoh@ohsu.edu>]

I have a stored procedure that takes an array as the parameter. I want to build 
an SQR program that does some processing to create the array, then
pass that array to my stored procedure.
 
I've called stored procedures with regular non-array parameters, but can't 
figure out how to define the data type in SQR in order to pass it to my 
procedure.
 
The array parameter looks a little something like this:
 
SQL> desc ISIS_APP_EMAIL_TYP_OAI_V1_Arr
 ISIS_APP_EMAIL_TYP_OAI_V1_Arr VARRAY(1000) OF ISIS_APP_EMAIL_TYP_OAI_V1
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMAIL_SOURCE                                       VARCHAR2(1000)
 EMAIL_SSN                                          VARCHAR2(1000)
 EMAIL_LAST_NAME                                    VARCHAR2(1000)
 EMAIL_FIRST_NAME                                   VARCHAR2(1000)
 EMAIL_MIDDLE_NAME                                  VARCHAR2(1000)
 EMAIL_USERNAME                                     VARCHAR2(1000)
 EMAIL_ADDRESS                                      VARCHAR2(1000)
 EMAIL_NDS_TREE                                     VARCHAR2(1000)
 EMAIL_STUDENT_INDICATOR                            VARCHAR2(1000)
 EMAIL_EMPLOYEE_INDICATOR                           VARCHAR2(1000)
 EMAIL_RECORD_ACTION                                VARCHAR2(1000)
 EMAIL_ACCOUNT_CREATE_DATE                          DATE
 EMAIL_EXTRACT_TIME_STAMP                           DATE

TIA
 
--
Howard Thompson
Senior IS Project Lead
Oregon Health & Science University
thompsoh@ohsu.edu
503-494-5936
 
"I can't complain, but sometimes I still do
Life's been good to me so far".
-- Joe Walsh


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users