| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Problem using CLOB with ADO
Hello List,
We are developing an application using Visual Basic and Microsoft ADO. We
are also using Oracle Provider for OLE DB and the database is Oracle 8.1.7.
We were using client side cursors in application and had some problems. We
switched to server side cursors and explicit Begin and End transactions as
per Oracle documentation and noticed that triggers were firing each time the
clob was updated. The problem seems to be that Oracle submits the changes to
clob(when using serverside cursors in application) immediately and also
fires the trigger on that row if the.
The work around was to initialize clobs when the record was inserted and
thus the trigger fired only once.
However the problem now is that if an error is raised by a trigger with a
CLOB. the application get the error "ROW-00060: Internal error:
[daputchunk,2]". Has anyone ever come across this problem. Any insight would
be highy appreciated.
thanks,
Shailesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yadav, Shailesh
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 05 2003 - 08:20:58 CDT
 |
 |