OK, I worked it out again (damn my terrible memory).
This showed up an interesting issue. I don't know if it's a difference
in CF or a difference in the DB drivers, but our Solaris servers and
my Win dev server behave differently.
The windows server works as it should, with this:
<cfstoredproc procedure="myPachage.myProc" datasource="myDSN">
<cfprocresult name="RefCursor_Result" resultset="1">
</cfstoredproc>
returning a resultset when the proc is set up to return a ref cursor
as an out parameter.
However, or the Solaris server, I get this:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETWSDATA'
I had to add
<cfprocparam cfsqltype="cf_sql_varchar" null="yes">
to get it to work.
Does anyone know off-hand if this
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a
database driver is part of CF 7.0.2?
On 10/10/06, James Holmes <[EMAIL PROTECTED]> wrote:
> Can someone point me to correct, working documentation on returning
> CF7 queries from Oracle stored procs? The livedocs are useless on this
> matter and the articles to which I previously referred are buried or
> lost somewhere on Adobe's site.
--
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
