Re: PL/SQL Triggers.

We had this when PL/SQL was NOT selected as an install option on Oracle V7. Make sure that when you run SQL*PLUS, ou get something like this:

ORACLE7 Server Release 7.0.16.4.0 - Production With the procedural and distributed options PL/SQL Release 2.0.18.1.0 - Production

Also, your account must be granted CREATE TRIGGER by the system administrator

|> In article <D2MFG2.ALE_at_mail.auburn.edu>, vasudevy_at_eng.auburn.edu (Vasudev V. Yendapally) writes:
|> > This is what I get when I try to run a trigger.
|> > Could someone tell me what's actually going wrong ?
|> >
|> > /*****************************************************************/
|> > This is my trigger
|> > /*****************************************************************/
|> > CREATE trigger my_trigger
|> > BEFORE INSERT ON my_table
|> > BEGIN
|> > UPDATE my_table
|> > SET c=sysdate
|> > WHERE c IS NULL;
|> >
|> > END;
|> > /
|> > /*******************************************************************/
|> >
|> > This is what I get
|> > /*************************************/
|> >
|> > SQL>start my_trigger.sql
|> > CREATE trigger my_trigger
|> > *
|> > ERROR at line 1:
|> > ORA-00901: invalid CREATE command
|> >
|> >
|> > unknown command "END" - rest of line ignored.
|> > CREATE trigger my_trigger
|> > *
|> > ERROR at line 1:
|> > ORA-00901: invalid CREATE command
|> >
|> >
|> > /*************************************************************************/
Received on Mon Jan 30 1995 - 18:40:54 CET