You folks were kind enough to reply to this question so I thought I give you an update. I created a stored procedure that I made work using sqlplus. It would not work when I tried it using cfstoredproc. I creates a function that does exactly the same thing and it did work in the cfstoredproc. We are talking to Macromedia about this issue. This was using MX. Thanks for all the suggestions.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug boude Sent: Wednesday, March 17, 2004 5:04 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Stored Procedures Jim, you may have already followed this line of thinking, but have you successfully executed the procedure using SQL Plus, or whatever the equivalent of Microsoft's query analyzer is in Oracle? We need to isolate the problem first of all and make sure that the procedure itself does work. If the procedure can be executed successfully from a plain vanilla tool, then you know it's in the semantics of how CF is calling it. And knowing is half the battle (...GI Joe, 1980 something). Doug :0) >From: "Smith, Jim" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: <[EMAIL PROTECTED]> >Subject: RE: [KCFusion] Stored Procedures Date: Wed, 17 Mar 2004 >16:15:30 -0600 > >Thanks. I appreciate the ideas. > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On Behalf Of [EMAIL PROTECTED] >Sent: Wednesday, March 17, 2004 4:10 PM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Stored Procedures > > >A couple thoughts: > >1) You specify 2 parameters in your package, but only send it 1. The >arg_Cursor may be necessary > >2) Not sure how cursors work in Oracle and CF together and hence no >idea if you can pass a cursor object > >3) Not sure if the where clause is standard ANSI92 and if it will work >or not. From an MS SQL point of view, its missing some clauses > > WHERE > Title LIKE '%' || arg_Title || '%'; > > >should be: where Title Like '%' || arg_Title Like '%'; > >Sorry I can't help you more, that is about the limit of my Oracle >package knowledge.,Ryan > > > > >========================================================= >Kansas City ColdFusion User Group's website & listserv is hosted >through the generous support of Clickdoug.com To send email to the >list, email [EMAIL PROTECTED] To (un)subscribe, email >[EMAIL PROTECTED] with your request. >For hosting solutions http://www.clickdoug.com Featuring Win2003 >Enterprise, RedHat Linux, CFMX 6.1. >====================================================== > >========================================================Kansas City >ColdFusion User Group's website & listserv is hosted through the >generous support of Clickdoug.com To send email to the list, email >[EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with >your request. >For hosting solutions http://www.clickdoug.com Featuring Win2003 >Enterprise, RedHat Linux, CFMX 6.1. >===================================================== _________________________________________________________________ Get rid of annoying pop-up ads with the new MSN Toolbar - FREE! http://clk.atdmt.com/AVE/go/onm00200414ave/direct/01/ ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ====================================================== ========================================================Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. =====================================================
