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
