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

[Quoted] [Quoted] 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?

[Quoted] Any help is greatly appreciated.

TIA
Sean O Received on Thu Mar 30 2000 - 23:56:37 CEST