> I have attempted with the procedure below but am having difficulties.
>
> Thanks
>
> CREATE PROCEDURE GET_TIMETABLE ( FOR_DATE DATE ) RETURNS (
> CLASS INTEGER, TEACHER_ID INTEGER, STAFF_ID INTEGER, FORM_RUN
> INTEGER, PERIOD_ID INTEGER
> )
> AS
> DECLARE VARIABLE TE_CYCLE_START_DAY DATE; DECLARE VARIABLE
> TE_TIMETABLE_ID INTEGER; DECLARE VARIABLE CY_DAYS_IN_CYCLE
> INTEGER; DECLARE VARIABLE DAYS_DIFF INTEGER; DECLARE VARIABLE
> RESULT_DISPLAY_DAY INTEGER; DECLARE VARIABLE FORM_RUN_ID
> INTEGER; BEGIN
> SELECT

You might need endlines after semicolons. It also lends itself to easier
reading...

CREATE PROCEDURE GET_TIMETABLE (
FOR_DATE DATE
) RETURNS (
CLASS INTEGER,
TEACHER_ID INTEGER,
STAFF_ID INTEGER,
FORM_RUN INTEGER,
PERIOD_ID INTEGER
)
AS
DECLARE VARIABLE TE_CYCLE_START_DAY DATE;
DECLARE VARIABLE TE_TIMETABLE_ID INTEGER;
DECLARE VARIABLE CY_DAYS_IN_CYCLE INTEGER;
DECLARE VARIABLE DAYS_DIFF INTEGER;
DECLARE VARIABLE RESULT_DISPLAY_DAY INTEGER;
DECLARE VARIABLE FORM_RUN_ID INTEGER;
BEGIN
SELECT ...

(You are probably doing this anyway, and my silly email client stripped out
the line breaks. If so, I apologise...)

Nige.