Hi, All.
I'm trying to call an Oracle stored procedure with three parameters from
ColdFusion but I'm not having any success. The procedure runs fine when
I run it in SQLPlus so I know it works. In CF it doesn't cause an error
... it just hangs there. I'm not returning anything from the procedure.
Can you help me? Here are some code snippets I've tried.
<CFSTOREDPROC PROCEDURE="SPSubmitAdjustment" DATASOURCE="#DSN#"
USERNAME="stage" PASSWORD="stage" DBSERVER="bcgdev" DBNAME="stage">
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR VALUE="#loan_num#"
DBVARNAME=pLoanum>
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_NUMERIC
VALUE="#reporting_period#" DBVARNAME=pReportingPeriod>
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VarCHAR VALUE="#message#"
DBVARNAME=pUserMessageText>
</CFSTOREDPROC>
<cfquery name="testProc" datasource="#DSN#" dbtype="ODBC">
Begin SPSubmitAdjustment ('2132165', 1001, 'Karen Test'); End;
</cfquery>
Thanks,
Eric
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
