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