create trigger tr after insert on table_nameQuote:> 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));
> create trigger tr after insert on table_name
> insert into table2 values( a, b);
> 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
> Any help is greatly appreciated.
> Sean O
insert into table2 values( a, b);
Sybrand Bakker, Oracle DBA