What is the output of the following code?
declare v_length_nr NUMBER :=5.5; v_width_nr NUMBER :=3.5; v_area_nr NUMBER; begin v_area_nr:=v_length_nr*v_width_nr DBMS_OUTPUT.put_line ('Area:'||area_nr); end; /
DBMS_OUTPUT.put_line('Area:'||area_nr); * ERROR at line 7: ORA-06550: line 7, column 5: PLS-00103: Encountered the symbol "DBMS_OUTPUT" when expecting one of the following: . ( * @ % & = - + ; < / > at in is mod remainder not rem
<> or != or ~= >= <= <> and or like between || member SUBMULTISET_ The symbol "." was substituted for "DBMS_OUTPUT" to continue. SQL>
When you have a missing semicolon, the error message you see might not identify the problem clearly.
Oracle tries to give you as much information as possible.