Problem declaring Cursors at SQL*FORMS 3.0 procedure level

From: <mcgrathm_at_vax1.tcd.ie>
Date: 4 Feb 93 14:47:45 GMT
Message-ID: <1993Feb4.144745.1_at_vax1.tcd.ie>


 Hi,    

    Can anyone please help with a problem I have encountered with the declaration of cursors in procedure level pl/sql triggers in SQL*FORMS version 3.0.
The documentation suggests that the format is :-

 procedure PROCEDURE_NAME is  

  declare

      cursor C1 is
  begin

< PL/SQL statements >

  END; I also have tried :-

 procedure PROCEDURE_NAME is
 begin
  declare

      cursor C1 is
  begin

< PL/SQL statements >

  END;
end;

The error I get back is PL/SQL 20609. I am unable to determine whether this a problem with SQL*FORMS or a syntax problem.

All advice will be greatfully received.

                     Michael. 
Received on Thu Feb 04 1993 - 15:47:45 CET

Original text of this message