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>
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