OraFAQ Forum: SQL & PL/SQL » Create a trigger on a nested table

Home » SQL & PL/SQL » SQL & PL/SQL » Create a trigger on a nested table

Wed, 30 May 2007 05:50

Annee
Messages: 6
Registered: May 2007

Junior Member

Hi all.
I need to create a trigger on a nested table but I didn't know how to do it.
Can someone help me?

Thanks Very Happy

I'm using Oracle 10g

Wed, 30 May 2007 06:10

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

CREATE OR REPLACE TRIGGER trigger_name
INSTEAD OF INSERT OR UPDATE
ON NESTED TABLE nested_table_names OF parent_table_name
BEGIN

END;

Check the oracle docs for more info

Wed, 30 May 2007 06:40

Annee
Messages: 6
Registered: May 2007

Junior Member

for that, Do I need to create a view?

Wed, 30 May 2007 06:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't create a trigger on a nested table.

Regards
Michel

Previous Topic:	archive log list - ORA-01031: insufficient privileges
Next Topic:	Ora-04052 error plz help!!!

Goto Forum:

]

Current Time: Thu Dec 05 15:36:30 CST 2024