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
At 10:32 AM 5/18/2001 -0700, Marsh, Jeffrey B wrote:
>I'm attempting to use Oracle stored procedures for the first time. Oracle
>SQL*Plus really stinks as an IDE. There has to be a better tool out there.
>I've used Microsoft SQL Server in the past.
>
>I'm having trouble writing a simple Oracle stored procedure to select data
>from a table and return a record set. I read the KB articles. Is there still
>no way to return an Oracle recordset? I was wondering if some kind soul
>would post a short Oracle stored procedure to select data from a table and
>post the CF code as well. I'm using a simple table to exercise several data
>types. The table description is below. Thanks.
>
>Name Null? Type
> ------------------------------- -------- ----
> RECNO NOT NULL NUMBER
> LASTNAME VARCHAR2(15)
> FIRSTNAME VARCHAR2(15)
> MIDDLEINITIAL CHAR(1)
> TEMPERATURE NUMBER(4,1)
> BIRTHDATE DATE
> UPDATEDBY VARCHAR2(10)
> MODIFIED DATE
>
>---
>Jeffrey B. Marsh
>Professionals built the Titanic.
>Amateurs built the Ark.
>
>****************************************************************************
>This message is intended for the sole use of the individual and entity to
>which it is addressed, and may contain information that is privileged,
>confidential and exempt from disclosure under applicable law. If you are
>not the intended addressee, nor authorized to receive for the intended
>addressee, you are hereby notified that you may not use, copy, disclose or
>distribute to anyone the message or any information contained in the
>message. If you have received this message in error, please immediately
>advise the sender by reply email and delete the message. Thank you very
>much.
>****************************************************************************
>****************************************************************************
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
