RE: [KCFusion] Stored Procedures

[doug boude]

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. 
======================================================