Re: Insert Update Delete CLOB in trigger

hmm....game is not yet over.
All operations INSERT/UPDATE/DELETE works fine only when performed through backend using SQL tool (I am using DBArtisan). When I tried testing through front end application only DELETE operation worked fine. For INSERT and UPDATE operations on base table ACTIVITY, we got blank data in GEAM_ACTIVITY table for CLOB object ACTIVITY_COMMENT. I wonder if DB user which application is using is different than what I use to perform same operation thorugh SQL tool. But again trigger once set should work fine for all DB users having appropriate permissions and also DELETE operation works fine through front end. Any ideas what can be possible reasons..??

Also I see lot of new lines inserted in ACTIVITY_COMMENT field. So if I have 1 line in base table for CLOB object then I get 9 lines of output of which first and last 4 lines are blank new lines. And middle line contains actual plain text format of original CLOB object. How to get rid of these new lines?

Thanks
Saggi Received on Tue May 30 2006 - 07:33:28 CDT