Re: AFTER CREATE trigger (object actually being REPLACED)

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 Nov 2007 17:52:43 -0800
Message-ID: <1196387556.285561@bubbleator.drizzle.com>

joel garry wrote:
> 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

The trigger referred to by Syltrem is an AFTER DDL EVENT TRIGGER. They are not "on the view" they are on the DATABASE or SCHEMA.

http://www.psoug.org/reference/ddl_trigger.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Nov 29 2007 - 19:52:43 CST