Re: Triggers in package

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 18 Nov 2007 23:13:33 +0100
Message-ID: <4740B90D.7050009@gmail.com>

shakespeare schrieb:
> "Maxim Demenko" <mdemenko_at_gmail.com> schreef in bericht
> news:4740A02C.7060403_at_gmail.com...

>> GeezerButler schrieb:
>>> Hi, I am totally new to Oracle so beware of stupidity :)
>>>
>>> Can triggers be defined inside a package?
>> No triggers can't be defined inside a package.
>> There is a very good source regarding triggers, packages and similar 
>> things
>> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm
>>
>> Best regards
>>
>> Maxim

>
> But: triggers can call code in packages. Which has the advantage they're
> compiled in stead of interpreted.
>
> Shakespeare
>
>

This has some advantages, but not one you mentioned (if i am not wrong, at least since 8i). You may be interested to read this thread on AskTom http://asktom.oracle.com/pls/asktom/f?p=100:11:3002549113972976::::P11_QUESTION_ID:149212348066 or search this newsgroup - it was discussed here in the past a lot. However, i don't clear understand, what is your point - i think, the question was clearly stated and clearly answered - and my point was: the thema is way too complex to diskuss it in usenet post. In my opinion, if somebody is totally new to Oracle, the best place to start is the Oracle documentation, in no way it is the usenet group. Don't take me personally, but all what you said can be wrong. Equally well, all what i say may be wrong. As it can be from everybody from the regulars here.
That is why, in my opinion, if somebody begin to learn oracle, he should do it at right place, minimizing the risk to memorize wrong concept.

Best regards

Maxim Received on Sun Nov 18 2007 - 16:13:33 CST