Re: Create trigger on view with long raw column

Lisa Tang wrote:

>
> I have a table t1 with a long raw column, and I need to create a view
> v1 with a long raw column being a function ff1 of the long raw column
> in t1. And I need to update t1 with reverse function rf1 whenever
> there is update, insert or delete to v1. My problem is it is not
> allowed to refer long raw from :new or :old, so I cannot get the long
> raw value when v1 is inserted, updated or deleted. Could anyone give
> me some advice or suggestions?

Suggestions

1. Do not cross post. The same people read and answer in all these groups so, to us you are repeating your question unnecessarily.
2. This is properly a question asked in comp.databases.oracle.server so please restrict all follow up to that group.
3. Include your operating system and Oracle version whenever possible. It usually makes a difference in the way we respond.
4. Use LOBs, in this case BLOB, instead of LONG or LONG RAW. The LONG family of data types has serious limitations as you see. Most of these are eliminated with LOBs. For more information, go to http://docs.oracle.com and look at the "Application Developer's Guide - Large Objects (LOBs)" in the document library for the version you use. OR
5. Provide an explanation why you insist on using a technique (LONG) that even Oracle recommends you do not use.

/Hans Received on Sun Sep 05 2004 - 09:34:27 CDT