Skip to Main Content

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!

PLS-00103 Error in Trigger

715303Jan 7 2010 — edited Jan 7 2010
I have a trigger inside a .sql script like this
CREATE OR REPLACE TRIGGER "my_schema"."trigger_name" 
BEFORE INSERT ON my_table
FOR EACH ROW

DECLARE
            ........
BEGIN
            ........
END trigger_name;
ALTER TRIGGER "my_schema"."trigger_name" ENABLE;
/
I executed it with the command
@my_sql_script_name.sql
It said
Warning: Trigger created with compilation errors.
I then entered
show errors trigger <trigger_name>;
Now it says
27/1     PLS-00103: Encountered the symbol "ALTER"
What does it mean? I used that ALTER TRIGGER command to enable my trigger inside the sql script. How can solve this problem, Anyone please?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Jan 7 2010
6 comments
3,205 views