Ask a Question related to Coldfusion Database Access, Design and Development.
-
singhpk #1
Error while executing stored procedure
I get the following error message when I am trying to execute a stored
procedure. It runs fine on my dev server but giving error in production.
Optional feature not implemented
The code for stored procedure is as follows
<cfstoredproc procedure="dbo.Penalty_Log" datasource="#application.dsrc2#"
debug = "Yes" returnCode = "Yes">
<cfprocparam type="in" cfsqltype="cf_sql_char" value="#Office#">
<cfprocparam type="in" cfsqltype="cf_sql_date" value="#date#">
<cfprocparam type="in" cfsqltype="cf_sql_char" value="#App#">
<cfprocparam type="in" cfsqltype="cf_sql_smallint" value="#Count#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="2" value="#ltPen#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="2" value="#lPen#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="1" value="#lAvgH#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="2"
value="#lsePPen#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="2" value="#lcIPH#">
<cfprocparam type="in" cfsqltype="cf_sql_decimal" scale="1" value="#lcIPP#">
<cfprocparam type="in" cfsqltype="cf_sql_smallint" value="#lcDisd#">
<cfprocresult name = "qresults">
</cfstoredproc>
Anybody had a similar error or have any solutions ?
singhpk Guest
-
problems executing wscript_command stored procedure
I'm trying to call the wscript_command stored procedure and use the ID of a DTS job as one of the input parameters. I am getting the message "Error... -
Stored procedure error
We are attempting to use a stored procedure to enter data into two tables and we are recieving this error: ADODB.Command error '800a0d5d' ... -
Executing Stored Procedure in loop duplicates row content
Hi, I am executing a stored procedure from a form post, when I execute the stored procedure it inserts a row for every checkbox checked, however... -
DBD::Oracle not executing stored procedure properly...
Hamish Whittal wrote: is this what you have in your code: "$$dbh->prepare($sql)"? david -
C stored procedure SQL error.
I have a very basic C stored procedure written. It was working fine with some bogus/kludge SQL (just to get a DBRM created). I have now added...



Reply With Quote

