Keep getting the following error :
Error starting at line 1 in command:
DECLARE
snumber S_STUDENT.STUDENTNO%TYPE;:='&snum';
saddress S_STUDENT.ADDRESS%TYPE:='&saddress';
pcode S_STUDENT.PROGRAMCODE%TYPE:='&pcode';
scode S_STUDENT.STAGECODE%TYPE:='&scode';
Error report:
ORA-06550: line 2, column 34:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
My Code:
--Declaring variables to hold a student name,a student address, a program code and a stage code.
DECLARE
snumber S_STUDENT.STUDENTNO%TYPE;:='&snum';
saddress S_STUDENT.ADDRESS%TYPE:='&saddress';
pcode S_STUDENT.PROGRAMCODE%TYPE:='&pcode';
scode S_STUDENT.STAGECODE%TYPE:='&scode';
Any help appeciated. :)