David:
Did you use that in Oracle before? The reason I asked is that in ColdFusion
knowledge
base, for article # 8353, it said that
----------------------------------------------------------------------------
-------
Oracle stored procedures do not return result sets in the traditional sense.
Consequently, it is not possible to generate a query in ColdFusion using an
Oracle stored procedure.
----------------------------------------------------------------------------
-------
I should do some test, however, I am busying with design spec, just check
with you.
Thanks.
Mei
-----Original Message-----
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 5:42 PM
To: CF-Talk
Subject: RE: stored procedure and resultset
Yes. Look at CFSTOREDPROC and CFPROCRESULT; basically, you include one
CFPROCRESULT tag for each result set in the stored procedure. Then you've
got named CFQUERY objects you can work with.
-----Original Message-----
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 3:43 PM
To: CF-Talk
Subject: stored procedure and resultset
Can we loop all the recordsets in the stored procedures with CF 4.5 and
Oracle 8.1?
I have done this with ASP and SQL Server 7.0:
E.g.
create procedure sp_Money
select * from tbl1 where fname = "mei";
select * from tbl2 where targetSalary = "1,000,000";
then, after execute the stored procedure, we can loop it as:
objRec = NextRecordset; ( not exactly syntax, but the idea is there...)
do while not objRec.eof
--- objRec will be all the records return from the first select...;
objRec = NextRecordset;
--- this time, objRec will be all the records from the second select...
CAN we do that? Any information is greatly appreciated.
Mei
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
