Examine the following block of code:
Which line in the above code would result in errors upon execution?
A. line 5
B. line 8
C. line 2
D. line 7
Examine the following block of code:
Which line in the above code would result in errors upon execution?
A. line 5
B. line 8
C. line 2
D. line 7
DECLARE
status VARCHAR2(10) NOT NULL DEFAULT ‘TRUE’;
net_value NUMBER:=555;
done BOOLEAN;
valid_id BOOLEAN:=TRUE;
BEGIN
done:=(net_value>100);
status:=valid_id;
END;
/
ORA-06550: line 8, column 13:
PLS-00382: expression is of wrong type