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