Re: Oracle stored procs and CF - documentation
I answered myself again. Thankme for the help. No probs :-) CF 7.0.2 doesn't include the 3.5 drivers. Interesting though that Solaris CF Ent and Win CF Dev show different behaviour with the same 3.3 drivers. On 10/10/06, James Holmes [EMAIL PROTECTED] wrote: 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/ -- 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:256072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Oracle stored procs and CF - documentation
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:256064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Oracle stored procs and CF - documentation
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