Re: SQL*Plus not parsing "create trigger" and "create type" commands

Sean O. <sunseano_at_yahoo.com> wrote in message news:38e3cb18.2474768_at_news1.sympatico.ca...
> Hello,
>
> I'm having bizarre problems trying to create triggers or types.
> SQL*Plus does not seem to respond after the command is entered. My
> environment is the following:
>
> windows nt workstation 4
> oracle server 8i (8.1.5)
> sql*plus 8.1.5 (both command line/windows versions)
>
> For example:
>
> create type t as object (c varchar2(3));
> <or>
> create trigger tr after insert on table_name
> begin
> insert into table2 values( a, b);
> end;
>
> In both cases, after I enter the semi-colon, I'm still at the line
> number prompt. Not until I press "." (period) do I get back to the
> "SQL>" prompt. Plus, Oracle doesn't register that I've done anything.
> If I check the user_triggers table, my trigger isn't there.
>
> Here's the bizarre part. Using the Oracle ODBC Test Tool, it works!!
>
> Has anyone encountered this problem, and does anyone know how to fix
> it?
>
> Any help is greatly appreciated.
>
> TIA
> Sean O

create trigger tr after insert on table_name

   begin
     insert into table2 values( a, b);
  end;
/ <-

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 30 2000 - 23:57:55 CEST