-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 4:46 AM
To: CF-Talk
Subject: the oracle, the stored procedure and the cfstoredproc
I know I should be able to work this out, but it's wall butting time.
I have a procedure in Oracle 9i, declared:
TYPE ref_cursor IS REF CURSOR;
...
PROCEDURE get_available_reports(user_name_in IN VARCHAR2,
available_reports_out OUT ref_cursor);
and I'm having no luck getting the result set back.
I though, based on the docs and a recent Macromedia.com article, that
<cfstoredproc dataSource="#request.dsn#"
procedure="bf_report.client_facade_pkg.get_available_reports" >
<cfprocparam dbVarName="user_name_in" value="#iUserId#"
cfsqltype="CF_SQL_VARCHAR">
<cfprocresult name="qReports" >
</cfstoredproc>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
