[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Re: Calling a stored procedure with an array parameter
- Subject: [sqr-users] Re: Calling a stored procedure with an array parameter
- From: "Howard Thompson" <thompsoh@ohsu.edu>
- Date: Mon, 27 Feb 2006 07:31:05 -0800
- Delivery-date: Mon, 27 Feb 2006 10:33:47 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
AH! A global temporary table. Perfect. Thanks for the idea; it will work
perfectly.
> 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.
--
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