Someone else may have more info, but we upgraded our MDAC on one of our
servers and consistently got the PCodeRuntimeContextImp error on passthrough
queries in Access97 databases. If other similar stored procedures are doing
this, you may want to look at the MDAC...
jon
----- Original Message -----
From: "Bob Silverberg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 12:16 PM
Subject: CFSTOREDPROC Error!
> I'm receiving the following error intermittently when using the
CFSTOREDPROC
> tag to run a stored procedure that returns 3 result sets:
>
> Error Diagnostic Information
> unknown exception condition
>
> PCodeRuntimeContextImp::executeSQLTagCFStoredProc::endTag
>
> The error occurred while processing an element with a general identifier
of
> (CFSTOREDPROC), occupying document position (26:1) to (26:96) in the
> template file
>
D:\DEVWEB\INETPUB\WWWROOT\NATIVETRAX\QUERIES\QRY_PRODUCERTRANSACTIONREPORT.C
> FM.
>
> My CFSTOREDPROC tag reads:
>
> <cfstoredproc procedure="ProducerTransactionReport"
> datasource="#request.DSN#" returncode="YES">
> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="RptMonth"
> value="#Val(attributes.RptMonth)#">
> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="RptYear"
> value="#Val(attributes.RptYear)#">
> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="ClientItemId"
> value="#Val(attributes.ClientItemId)#">
> <cfprocresult name="qryProducerTransactionDetails" resultset="1">
> <cfprocresult name="qryProducerTransactionTotals" resultset="2">
> <cfprocresult name="qryProducerTransactionPCT" resultset="3">
> </cfstoredproc>
>
> The procedure ProducerTransactionReport in turn runs two stored
procedures,
> the first of which returns one result set and the second of which returns
> two result sets.
>
> The strange thing is that sometimes it works fine, and returns all three
> result sets, while other times it returns two result sets, and then issues
> the above error message. In each of the stored procedures I SET NOCOUNT
ON
> at the beginning and SET NOCOUNT OFF at the end.
>
> This is ColdFusion Professional 4.5.1 SP2 running on W2K Server, and the
> database is MS SQL Server 2000, being accessed via OLE DB.
>
> If anyone has seen this before and/or has any suggestions I would
appreciate
> hearing from you.
>
> Thanks,
> Bob
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
