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

In article <38e3cb18.2474768_at_news1.sympatico.ca>, sunseano_at_yahoo.com (Sean O.) wrote:
> 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?
>

for statements that can contain semi colons (eg: triggers,procedures, types, packages, etc) - you must enter a / in column 1 to 'run' the block. eg:

create trigger t
before insert on t
begin
null;
end;
/

The slash runs the buffer.

> Any help is greatly appreciated.
>
> TIA
> Sean O
>

--
Thomas Kyte tkyte_at_us.oracle.com
Oracle Service Industries http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.