Re: What's wrong with this SQL statement?

From: Troy Perchotte <max_at_headroom.com>
Date: Mon, 22 Jun 1998 11:08:10 -0700
Message-ID: <358E9D89.6754A493@headroom.com>

I have changed the statement a few additional times, still with my error. Here is what I have now:

CREATE OR REPLACE TRIGGER "DCI".INV_FIELD_ITEMS_TRIGGER BEFORE INSERT ON "DCI"."INV_FIELD_ITEMS" for each row
declare dummy number;
begin

select inv_field_items_sequence.nextval into dummy from dual; :new.item_id := dummy;
end;

I still receive the following error messages:

ora-6552 pl/sql: Compilation unit analysis terminated. ora-6553 pls-320: the declaration of the type of this expression is incomplete or malformed.

Please help.

Troy Perchotte Received on Mon Jun 22 1998 - 13:08:10 CDT