How to process "long" in trigger?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Fri, 21 Sep 2007 07:40:54 -0700 (PDT)
Message-ID: <733778.2528.qm@web60820.mail.yahoo.com>

we have table with column type "long" in it(actually this "long" field store ASCII text and less than 4000 characters). The ORACLE database is 9ir2. We tried to create "logical standby database", but "logical stansdby database" does NOT update "long" field.

The way I tried to do is use "trigger" when update "long" table, insert new data (since this "long" store ASCII data) into another table with "varchar2". The problem I got is "trigger" can NOT handle "long".

Anyone has way to handle this?

Thanks.        

---

Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 21 2007 - 09:40:54 CDT