Re: [sqr-users] Calling a stored procedure with an arrayparameter

["George Jansen" <GJANSEN@aflcio.org>]

I'm afraid that you'd have to write an Oracle Call Interface procedure and link 
it into SQR, because SQR as such doesn't know about Oracle collection types. 
Unless you have the time to do so, you might find it preferable to use a global 
temporary table for your record-marshalling, and rewrite the stored procedure.

>>> thompsoh@ohsu.edu 02/23/06 12:55 PM >>>
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


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