I am having problems retrieving the out parameters in cfstoredproc tag. the
input parameters reach the stored procedure
OK, the procedure executes OK, but I never get the out parameter returned
into CF. I am using CF 4.5 with Oracle 8.0.4. (Windows NT).
Please see the associated code: a very simple cfstoredproc tag and a very
simple stored procedure.
Thanks in advance for your assistance.
-Stan S.
================================================
cfml code:
<cfstoredproc
procedure="test"
datasource="#Application.DBsource#"
username="#Application.DBUserName#"
password="#Application.DBPassword#">
<cfprocparam type="in"
value=1
cfsqltype="CF_SQL_INTEGER">
<cfprocparam
type="out"
variable="errnbr"
cfsqltype="CF_SQL_INTEGER">
</cfstoredproc>
===============================================
the pl/sql code:
PROCEDURE test (pi_test IN NUMBER, po_test OUT NUMBER) IS
BEGIN
po_test := pi_test + 10;
exception
when others then
po_test := 200;
END;
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
