Error: Encountered the symbol "DECLARE" when expecting...
From: CASISOFT MindWare <CASIS_at_www.casisoft.de>
Date: Wed, 23 Sep 1998 11:07:13 +0200
Message-ID: <6uadfn$q6m$1_at_proxy01.detmold.netsurf.de>
[Quoted] [Quoted] Using Designer 2000 V2.1 / Web Application Server 3. When I generate the following procedure and execute DDL I get error messages.
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 ....
Date: Wed, 23 Sep 1998 11:07:13 +0200
Message-ID: <6uadfn$q6m$1_at_proxy01.detmold.netsurf.de>
[Quoted] [Quoted] Using Designer 2000 V2.1 / Web Application Server 3. When I generate the following procedure and execute DDL I get error messages.
DECLARE
[Quoted] 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 - 11:07:13 CEST