Re: Create trigger on view with long raw column

1. & 2) Sorry about that I didn't aware of this before. I will follow the rule from now on.
2. I want to do it for Window and Unix, Oracle 8.1 and 9.2
3. & 5) What I need to do is based on an existing oracle database in a customer site.

Hope to hear further suggestions.

Cheers,
LT

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<TtF_c.117506$X12.49012_at_edtnps84>...
> 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 Mon Sep 13 2004 - 05:08:11 CDT