Re: Oracle 8i Lite - Does Create Trigger work????

From: <michael_bialik_at_my-deja.com>
Date: Tue, 12 Oct 1999 21:01:58 GMT
Message-ID: <7u07js$dd0$1@nnrp1.deja.com>

Hi.

As far as I know - Oracle Lite means - NO PL/SQL! No functions/procedures/packages and triggers there.

Michael.

In article <380252c9_at_news.siscom.net>,
"Hal Dunithan" <hal_at_freelantzsolutions.com> wrote:
> Ok, seems simple enough.
>
> CREATE TRIGGER T440_ELIGIBILITY_TGR
> BEFORE INSERT
> ON T440_ELIGIBILITY
> FOR EACH ROW
> BEGIN
> SELECT T440_id_elgb_id_seq.Nextval
> INTO :NEW.T440_id_elgb_id
> FROM dual;
> END;
>
> Works on Oracle Server 8i....
>
> Yet, it doesn't work in Oracle 8i Lite. I keeping getting a syntax
error.
>
> Any ideas?
> Thanks!
>
> -Hal-
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 12 1999 - 16:01:58 CDT