--------------958CC883ABA6D83680132C2C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I got it to work!
I tested it using one parameter at at time and found that it broke on
the NUMBER parameter. It gave me an error "Invalid precision value". I
don't know why it wouldn't give me that error last week. Anyway I
substituted the parameter datatype in the cfstoredproc with
CF_SQL_INTEGER instead of CF_SQL_NUMBER and it works great. I don't know
why it does that.
Thanks so much for your help!
Nick Slay wrote:
> 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..
--------------958CC883ABA6D83680132C2C
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
I got it to work!
<p>I tested it using one parameter at at time and found that it broke on
<br>the NUMBER parameter. It gave me an error "Invalid precision value".
I
<br>don't know why it wouldn't give me that error last week. Anyway I
<br>substituted the parameter datatype in the cfstoredproc with
<br>CF_SQL_INTEGER instead of CF_SQL_NUMBER and it works great. I don't
know
<br>why it does that.
<p>Thanks so much for your help!
<p>Nick Slay wrote:
<blockquote TYPE=CITE>This is a multi-part message in MIME format.
<br>--------------93F79355261CF38FE03EE6E7
<br>Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
<br>Content-Transfer-Encoding: 7bit
<p>Eric, I think you need the MAXLENGTH parameter on the PROCPARAMS
that are Varchar.
<p>Hope that helps!
<p>N
<p>Eric Bradburn wrote:
<p>> Hi, All.
<br>>
<br>> I'm trying to call an Oracle stored procedure with three parameters
from
<br>>
<br>> ColdFusion but I'm not having any success. The procedure runs fine
when
<br>> I run it in SQLPlus so I know it works. In CF it doesn't cause an
error
<br>> ... it just hangs there. I'm not returning anything from the procedure.
<br>> Can you help me? Here are some code snippets I've tried.
<br>>
<br>> <CFSTOREDPROC PROCEDURE="SPSubmitAdjustment" DATASOURCE="#DSN#"
<br>> USERNAME="stage" PASSWORD="stage" DBSERVER="bcgdev" DBNAME="stage">
<br>> <CFPROCPARAM TYPE="IN"
CFSQLTYPE=CF_SQL_VARCHAR
VALUE="#loan_num#"
<br>>
<br>> DBVARNAME=pLoanum>
<br>> <CFPROCPARAM TYPE="IN"
CFSQLTYPE=CF_SQL_NUMERIC
<br>> VALUE="#reporting_period#" DBVARNAME=pReportingPeriod>
<br>> <CFPROCPARAM TYPE="IN"
CFSQLTYPE=CF_SQL_VarCHAR
VALUE="#message#"
<br>> DBVARNAME=pUserMessageText>
<br>> </CFSTOREDPROC>
<br>>
<br>> <cfquery name="testProc" datasource="#DSN#" dbtype="ODBC">
<br>> Begin SPSubmitAdjustment
('2132165', 1001, 'Karen Test'); End;
<br>> </cfquery>
<br>>
<br>> Thanks,
<br>> Eric
<br>>
<br>> ------------------------------------------------------------------------------
<br>> Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>> To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
<p>--------------93F79355261CF38FE03EE6E7
<br>Content-Type: text/x-vcard; charset=us-ascii;
<br> name="nickslay.vcf"
<br>Content-Transfer-Encoding: 7bit
<br>Content-Description: Card for Nick Slay
<br>Content-Disposition: attachment;
<br> filename="nickslay.vcf"
<p>begin:vcard
<br>n:Slay;Nick
<br>tel;cell:0414 810284
<br>tel;home:02 4381 0284
<br>tel;work:02 4381 0284
<br>x-mozilla-html:FALSE
<br>url:<a href="http://www.webbods.com.au">http://www.webbods.com.au</a>
<br>org:Webbods Pty Ltd
<br>adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
<br>version:2.1
<br>email;internet:[EMAIL PROTECTED]
<br>title:Technical Director
<br>x-mozilla-cpt:;3
<br>fn:Nick Slay
<br>end:vcard
<p>--------------93F79355261CF38FE03EE6E7--
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body..</blockquote>
</html>
--------------958CC883ABA6D83680132C2C--
------------------------------------------------------------------------------
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.
