Oracle stored procs don't work the same way as SQLServer/Sybase, in that
they don't return result sets.
-----Original Message-----
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 11:27 AM
To: Fusebox
Subject: RE: Oracle stored procedure
I'm ignorant on Oracle, but isn't a recordset nothing but the returns from a
query? I mean, isn't that what you've got in a query result set that you
then CFLOOP/CFOUTPUT through?
> -----Original Message-----
> From: Stephen Garrett [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 18, 2001 10:06 AM
> To: Fusebox
> Subject: Re: Oracle stored procedure
>
>
> To my knowledge, there is still no direct way to return record sets
> from Oracle. The best you can do is to return columnar arrays.
>
> With a few tricks, there is a workaround, and I don't know if anyone
> else has ever done this: Use XML/WDDX.
>
> Create a WDDX XML string in the SP, and return that as a variable. This
> can mostly be done via your SELECT statement. Kind of different, but
> it can and does work. Upon receipt back to CF use WDDX2CF to restore
> as a query.
>
> HTH,
> Steve
>
>
{redacted}
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
