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).
