How to process "long" in trigger?
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 21 Sep 2007 07:40:54 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
