> After asking a couple questions about Oracle Stored
> Procedures and CF 4.5 pro version, and getting a few
> responses (thanks!), I'm under the impression that the
> only way to get a recordset back from the SP is by using
> CF Enterprise and the native drivers.
>
> Is this correct? Am I spinning my wheels trying to use SPs
> with Oracle and CF Pro?
Essentially, yes. If you write a stored procedure that returns values into a
temp table, you could set it up in such a way that you end up querying the
temp table, according to Allaire. I'm a little hazy on the details of that,
but could find out more if needed. However, to pass parameters to a stored
procedure and have it return a recordset, which is where the fun stuff is,
you'll need CF 4.5.x Enterprise Edition and its native drivers.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
