Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: AFTER CREATE trigger (object actually being REPLACED)

Re: AFTER CREATE trigger (object actually being REPLACED)

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 29 Nov 2007 15:44:25 -0500
Message-ID: <13ku95bbj93a72@corp.supernews.com>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1196366789.806991_at_bubbleator.drizzle.com...
> Syltrem 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...
>>
>> Thanks
>
> The only way I can think of doing this would be to query all_objects,
> or a similar source, to see if the object already exists in the named
> schema.

Thing is, this is an AFTER create trigger. So the object will always exist.
So I've got to use the creation date I guess ?

Syltrem

> --

> 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 - 14:44:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US