Re: AFTER CREATE trigger (object actually being REPLACED)

On Nov 29, 10:34 am, "Syltrem" <syltremz..._at_videotron.ca> wrote:
> Hi
>
> I have an AFTER CREATE trigger.
> I can verify what kind of object has been created by using the
> ora_dict_obj_type event attribute function, but is there such a function
> that would tell me if the object is being added *or* replaced ?
>
> The object here is a VIEW, and a CREATE OR REPLACE does not always create
> the view... in such case I don't want to do anything but the trigger gets
> fired anyway.
>
> Or do I have to query DBA_OBJECTS to check CREATED and LAST_DDL_TIME to make
> an educated guess ?
>
> Or any better way that you know of...
>

I'm confused - the docs say you can't use an after trigger on a view? I'm guessing you are seeing an undefined result that should have thrown an error on trigger creation? Maybe it will be clear if you give example code.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm#sthref7912

jg

--
@home.com is bogus.
Lock up your kids!  http://www.knbc.com/news/14720151/detail.html