Re: Error: Encountered the symbol "DECLARE" when expecting...

Missed the original Q: so I'm following up on the news group.

Error DECLARE usually means that you're missing a corresponding END in the code associated with a trigger.

Make sure all IF's have corresponding END IF's, BEGIN's and END's, etc...

Would be nice if the error message hinted toward the actual problem, instead of spinning your gears in the wrong spot.

Arnold Schommer <aschommer_at_fs-edv.de> wrote:

> CASISOFT MindWare wrote:
> >
> > Using Designer 2000 V2.1 / Web Application Server 3.
> > When I generate the following procedure and execute DDL I get
> > error messages.
> >
>
> Where is the Procedure header ? something like
> PROCEDURE SEEK_ITEM IS
> > DECLARE
> this 'DECLARE' _must_ not occur within a procedure/function, but in
> nameless PL/SQL-Blocks or triggers
> > CURSOR artikel_cur IS SELECT * FROM artikel;
> > BEGIN
> > IF NOT artikel_cur%isopen
> > THEN
> > OPEN artikel_cur;
> > END IF;
> >
> > CLOSE artikel_cur;
> > END;
> >
> > CDI-11307 Warning: (compilation error in PROCEDURE 'SEEK_ITEM'
> > at 1/60): PLS-00103: Encountered the symbol "DECLARE" when expecting
> > one of the following:
> > begin function package ....
> >
> > Procedure Type is Declarative.
> > If I have a procedure, as example, with nothing than htp.print ('test')
> > there is everything ok. No problem to start the procedure via Browser.
> >
> > Who can help?
> >
> > Wolfgang Fuerniss

--
joebrown
_at_leading.net