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

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
Received on Wed Sep 23 1998 - 17:26:09 CEST