the ref cursor as someone else suggested.
We put our Oracle stored procedures in this format:
<cfstoredproc procedure="bf_report.client_facade_pkg.get_available_reports"
datasource="#request.dsn#"
returncode="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="user_name_in"
value="#iUserId#">
<cfprocresult name="qReports">
</cfstoredproc>
It seems very similar to yours, so not sure if that is any help. Out of
curiosity, what is the bf_report before your package? A schema name? We
always just call the package directly, but pass in the username and password
in the cfstoredproc tag.
-----Original Message-----
From: Kevin Marino [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 1:39 PM
To: CF-Talk
Subject: RE: the oracle, the stored procedure and the cfstoredproc
We are running CF MX 6.1 . This problem happens with both versions of JDBC
MM recommends. Oh Windows 2000 and 2003 servers
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
