Hi my application is returning th

[ttrinh]

Hi
my application is returning this error when a user goes to update info
ODBC Error Code = 34000 (Invalid cursor name)
[Oracle][ODBC]Invalid cursor name
The sql that is the problem query is an update statement with one of the fields of type varchar2 containing about 2500 characters. The database is oracle and the driver is "Oracle in oracle9i". I have tested the sql and I can execute it without problems in SQLplus. Other queries seem to be working fine in the application.
Can anyone throw some light on this?
I have done some searches both in this forum and on web but it does not appear many other pple get this error msg??

TIA

 

[SidianConsulting]

Please post the code.

-Tek

 

[ttrinh]

Tek,
Here's the query which is generating the prob
<cfquery name=&quot;caller.#attributes.txName#&quot;
datasource=&quot;#application.DS#&quot;
dbType=&quot;#application.DB#&quot;>
UPDATE BIN
SET reference = '#attributes.txReference#',
description = '#attributes.txDescription#',
auditno = '#attributes.txAuditNo#',
qrep = #attributes.txQRep#,
respmgr = #attributes.txRespMgr#,
altRspMgr = '#attributes.txAltRspMgr#',
status = #attributes.txStatus#,
contractor = '#attributes.txContractor#',
mngunit = #attributes.txMngUnit#,
bintype = #attributes.txBinType#
WHERE binID = #attributes.txID#
</cfquery>
</cfcase>

The error msg is :

ODBC Error Code = 34000 (Invalid cursor name)


[Oracle][ODBC]Invalid cursor name.


SQL = &quot;UPDATE BIN SET reference = 'PMP Audit 26/08/2002', description = 'This BIN lists details which MAY need to be addressed in the upcoming review of the plan (HFMP-PLAN-000052). HFMP Management Stages The auditors felt that perhaps Figure 7-1 .... CORE for System requirements ? now DOORS??). Project Facilities Section 11.4.3.1 is too detailed, by prescribing WHERE the PM and PA staff sit.', auditno = 'HFMP-RPT-002799', qrep = 4846, respmgr = 4255, altRspMgr = '', status = 0, contractor = '', mngunit = 0, bintype = 0 WHERE binID = 3546&quot;
I have edited out the description field as its really long

Thanks

 

[SidianConsulting]

I don't know the datatypes of your fields, and I don't work with Oracle, so all I can suggest is to change the values of the fields until you figure out which field is causing the problem, and take it from there.

-Tek

 

[neofactor]

When you have a MS error I suggest looking it up at:

http://msdn.microsoft.com

As far as the solution...
Without the data types.. it is hard to say.
David McIntosh

http://www.neofactor.com

Let me know if this post helped you...
Please click below: &quot;This Post was Helpful&quot;

 

[ttrinh]

I don't think its a ms problem , unless I am totally mistaken.
I have found out which field is the problem - the description field. It s a CLOB data type . For some reason it won't even let me view the data thru the application even after I have entered it in straight to the database. It still returns the same error. The interesting thing is I tried it out in my test application (served on local machine -win2000 and oracle 9i driver) and it accepted all the values without any problems. The other fields are all numbers.
Also any other data entered or updated after this problem entry all works fine.

 

[ttrinh]

sorry the description field is varchar2 type 4000 char limit

 

[flowcontrol]

Do a search at macromedia.com for 'Oracle'. I think there is a document or two that talk about CLOB datatypes. Also, be sure to try the ColdFusion 'Database Access' forum at macromedia.com.