Xref: alice comp.databases.oracle.server:65127
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Newsgroups: comp.databases.oracle.server
References: <rtb1f4iu8os44@corp.supernews.com>
Subject: Re: Creating Triggers in Oracle 8i Lite 4.0
Date: Thu, 9 Sep 1999 08:49:38 -0600
Lines: 46
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
X-Original-NNTP-Posting-Host: 207.228.85.84
Message-ID: <37d7c8b7@news.cadvision.com>
X-Trace: 9 Sep 1999 08:48:23 -0700, 207.228.85.84
Organization: CADVision Development Corporation (http://www.cadvision.com/)
X-Original-NNTP-Posting-Host: 204.50.1.43
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.icl.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.nyu.edu!nntp.cadvision.com!news.cadvision.com!207.228.85.84

With 8i Lite you can use only Java to create stored procedures and triggers.

--
Terry Dykstra
Canadian Forest Oil Ltd.

Richard Speiss wrote in message ...
>I am trying to convert a SQL Anywhere database to Oracle 8I Lite 4.0 and am
>very new to the Oracle environment.  So far I have been able to create the
>users, tables,  indexes, and sequences.  So far so good.
>
>Now I am trying to create a trigger using a sequence.  I am logged into
>SQLPlus under SYSTEM and I just keep getting syntax errors.  This is my
>script:
>
>create or replace trigger MaintenanceLog_BI
>  before insert on "DBA"."MaintenanceLog"
>  for each row
>  when (new.Counter is null)
>  begin
>    select trunc(seqMaintenanceLogAuto.NextVal)
>           into :new.Counter from Dual;
>  end;
>/
>
>When I execute the START TRIG.SQL line I get:
>
>*
>Error at line 1:
>OCA-30021: error preparing/executing SQL statement
>[POL-5228] syntax error
>
>From all of the samples that I have found I'm pretty sure the command is
>correct.  The table and column do exist.
>
>What am I doing wrong?
>
>Thanks
>Richard Speiss
>
>
>
>
>