RE: How to process "long" in trigger?

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 21 Sep 2007 11:56:17 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9015E9469@usahm208.amer.corp.eds.com>

If the data value is less than 4K why are you using a obsolete since version 8.0 datatype of long when a varchar2(4000) would work? Otherwise use a CLOB.

One of the basic design rules is to store data in the most appropriate type column. Then you would not have this issue.

Mark D Powell -- Phone (313) 592-5148

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Friday, September 21, 2007 10:41 AM To: oracle-l_at_freelists.org
Subject: How to process "long" in trigger?

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 21 2007 - 10:56:17 CDT