Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Trigger Enhancements in Oracle Database 11g Release 1 - Learn about the enhancements to triggers in Oracle Database 11g Release 1.



TYU said...

I believe that:

ALTER TRIGGER DISABLE;

was already possible in Oracle 7.3 !!

Is it really new? I don't believe it.

Tim... said...

Hi.

Yes. I should have checked it out. I've raised an SR with Oracle about this point and mentioned it in the article. I assume it's a mistake in the PL/SQL manual.

Cheers

Tim...

Tim... said...

Hi.

The answer is that you can now explicitly ENABLE or DISABLE a trigger at creation time.

Cheers

Tim...

TYU said...

Ok

Peter Hitchman said...

Good article, that clearly explains compound triggers. So off I went and did an implementation with them on a RHL platform. It was going OK until one of the JDBC programmes tried to insert more than 3 rows in a transaction and the rules was a ORA-07445 error. Works OK in Sql*Plus! So I have a open SR with Oracle.

Pete

fariba said...

Hi
I wrote a compound trigger with below code but I still has these errors during updating

This my Compound trigger Code on Price table

******
CREATE OR REPLACE TRIGGER TR_CHECKDATE
FOR INSERT OR UPDATE ON price
COMPOUND TRIGGER

Cnt Integer;

Before Each Row Is
BEGIN
SELECT count(*)into Cnt
FROM Price
where
(Price.ProductId = :new.ProductId)

Tim... said...

Hi.

Read the big red text. If you want help with something post it in the forum.

Cheers

Tim...

hash said...

the :new is not working in Oracle 11g
Can anyone help? Please!

Tim... said...

Hi.

:new is only relevant for row level triggers during INSERT and UPDATE operations. It id not available from DELETE triggers and it is not available at all from statement level triggers.

I'm guessing you are using it in the wrong type of trigger. Any further questions, please ask in the forum.

Cheers

Tim...

André said...

Hi Tim.

Thanks to this article. You help me so much.

Bye,

André.

DO NOT ask technical questions here, that's what my forum is for!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)