SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Vanishing Triggers

388246Oct 2 2003 — edited Oct 4 2003

I wonder if anyone can help.

I have some insert instead of triggers which insert into a table/s when an attempt is made to insert into a view.

Whenever a view is altered the trigger relating to the view automatically deleted. I am using plsql/developer and I am getting different responses from different sources. One is that its a known oracle bug another is that it could be plsql/developer thats doing to the drop.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2003

Added on Oct 2 2003

7 comments

409 views