There are a number of issues with Oracle stored procedures. You are very
limited to what you can get back.
There are a number of work arounds, one being to have a resultid returned
from the oracle proc, that you then use to select from a table containing
the results. It's probably the easiest to implement. You can then have a
'cleanup' procedure that removes the results from the result table.
The parameters you are passing into the proc must also be in the EXACT order
that they are in the procedure header otherwise it will not work.
Adam Reynolds
ColdFusion Consultant
HJ Heinz
Tel: 01344 397016 Fax: 01344 397010
Mobile: 07973 386620
Email: [EMAIL PROTECTED]
> ----------
> From: Troy Johnson[SMTP:[EMAIL PROTECTED]]
> Sent: 15 May 2000 23:38
> To: '[EMAIL PROTECTED]'
> Subject: RE: Oracle 8.0 help
>
> use the "output" parameter in the <cfstoredproc> tag.
>
> -----Original Message-----
> From: David Pierce [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 3:14 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle 8.0 help
>
>
> Has anyone found out how to return a result set from an Oracle stored
> Proc?
> Any help you could provide would be great..... Thanks..
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> David Pierce
> Sharpsource
> (925) 240-8515 EX:114
> [EMAIL PROTECTED]
> 1240 Central Blvd., Suite A
> Brentwood, CA 94513
> www.sharpsource.com
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> --------------------------------------------------------------------------
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> 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...
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.
>
**********************************************************************
This email and any attachments are confidential and solely
for the use of the intended recipient. They may contain
material protected by legal professional or other privilege.
If you are not the intended recipient or the person responsible
for delivering to the intended recipient, you are not authorised
to and must not disclose, copy, distribute or retain this email
or its attachments. Although this email and its attachments
are believed to be free of any virus or other defect, it is the
responsibility of the recipient to ensure that they are virus free
and no responsibility is accepted by the company for any
loss or damage arising from receipt or use thereof.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
