This is a multi-part message in MIME format.
--------------93F79355261CF38FE03EE6E7
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
Eric, I think you need the MAXLENGTH parameter on the PROCPARAMS that are Varchar.
Hope that helps!
N
Eric Bradburn wrote:
> 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.
--------------93F79355261CF38FE03EE6E7
Content-Type: text/x-vcard; charset=us-ascii;
name="nickslay.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Nick Slay
Content-Disposition: attachment;
filename="nickslay.vcf"
begin:vcard
n:Slay;Nick
tel;cell:0414 810284
tel;home:02 4381 0284
tel;work:02 4381 0284
x-mozilla-html:FALSE
url:http://www.webbods.com.au
org:Webbods Pty Ltd
adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:Technical Director
x-mozilla-cpt:;3
fn:Nick Slay
end:vcard
--------------93F79355261CF38FE03EE6E7--
------------------------------------------------------------------------------
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.
