MM recommends. Oh Windows 2000 and 2003 servers
-Kevin Marino
----------------------
Webmaster - HealthObjects
[EMAIL PROTECTED]
410 895 0377
******************************************************************
This e-mail and any attachments may contain information which is
confidential, proprietary, privileged or otherwise protected by law. The
information is solely intended for the named addressee (or a person
responsible for delivering it to the addressee). If you are not the intended
recipient of this message, you are not authorized to read, print, retain,
copy or disseminate this message or any part of it. If you have received
this e-mail in error, please notify the sender immediately by return e-mail
and delete it from your computer.
******************************************************************
-----Original Message-----
From: Plunkett, Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 12:50 PM
To: CF-Talk
Subject: RE: the oracle, the stored procedure and the cfstoredproc
What version of CF are you using?
-----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]
