Trigger error [message #50796] |
Mon, 08 April 2002 07:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
malliga
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Dear friends,
Here we are using Oracle 8 database. i tried to create a trigger, the script will be
create trigger ctable
before create on database
begin
statements ;
end ;
/
Oracle throws an error
Invalid type trigger.
I want to monitor the user those who are all creating tables,synononyms,views, etc. or is there any way to monitor.
Pls help me in his regard.
Thanks in advance.
|
|
|
Re: Trigger error [message #50797 is a reply to message #50796] |
Mon, 08 April 2002 07:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
saleem
Messages: 65 Registered: January 2002
|
Member |
|
|
since the complete syntax is not included i would recommend you check your statement against the 'create trigger' syntax in the oracle documentation to make sure you are writing the trigger properly.
|
|
|
|