Getting Syntax Error When trying to use input variables to populate where clause

[Michael Taylor]

What is wrong with this sql statement?

ORA-06550: line 1, column 9: PLS-00103: Encountered the symbol "01" when expecting one of the following: begin function pragma procedure subtype type current cursor delete exists prior ORA-06

DECLARE &BEGINDATE DATE;
&ENDDATE DATE;

BEGIN


SELECT MAX(CONTRACTOR_ CONTRACTS.CONTR ACT_CODE) AS CONTRACT_CODE, MAX(STUDENTS.ST UDENT_ID) AS STUDENT_ID, MAX(STUDENTS.UP PER_FIRST_NAME) AS UPPER_FIRST_NAM E, MAX(STUDENTS.UP PER_LAST_NAME) AS UPPER_LAST_NAME , MAX(STUDENTS.SS N) AS SSN, MAX(HOURS_WORKE D) AS HOURS_WORKED, MAX(HOURLY_RATE ) AS HOURLY_RATE, MAX(MAX_HOURS_P ER_STUDENT) AS MAX_HOURS_PER_S TUDENT, MAX(MAX_HOURS_P ER_STUDENT) -MAX(HOURS_WORKE D) AS HOURS_REMAINING , MAX(INCENTIVE_A MOUNT) AS INCENTIVE_AMOUN T FROM STUDENTS
INNER JOIN STUDENT_JOBS ON STUDENT_JOBS.ST UDENT_ID = STUDENTS.STUDEN T_ID
INNER JOIN JOBS ON STUDENT_JOBS.JO B_ID = JOBS.JOB_ID
INNER JOIN WORKSITES ON JOBS.WORKSITE_I D = WORKSITES.WORKS ITE_ID
INNER JOIN CONTRACTORS ON JOBS.CONTRACTOR _ID = CONTRACTORS.CON TRACTOR_ID
INNER JOIN CONTRACTOR_CONT RACTS ON CONTRACTOR_CONT RACTS.CONTRACTO R_ID = CONTRACTORS.CON TRACTOR_ID
INNER JOIN
(SELECT STUDENT_JOB_TIM ESHEETS.STUDENT _JOB_ID, SUM(HOURS_WORKE D) AS HOURS_WORKED, AVG(HOURLY_RATE ) AS HOURLY_RATE, SUM(INCENTIVE_A MOUNT) AS INCENTIVE_AMOUN T FROM STUDENT_JOB_TIM ESHEETS
GROUP BY STUDENT_JOB_TIM ESHEETS.STUDENT _JOB_ID) SUBSET ON STUDENT_JOBS.ST UDENT_JOB_ID = SUBSET.STUDENT_ JOB_ID
WHERE CONTRACTOR_CONT RACTS.CONTRACT_ CODE IN('E100','E101 ','E102','E104' ,'E105') AND CONTRACTOR_CONT RACTS.BEGIN_DAT E >= &BEGINDATE AND CONTRACTOR_CONT RACTS.END_DATE <= &ENDDATE

GROUP BY CONTRACTOR_CONT RACTS.CONTRACT_ CODE, STUDENTS.STUDEN T_ID;

END;

[Rabbit]

You're missing your declare statement for your end date variable. Also, you never set the value of those variables.