set serveroutput ON..........ERROR at line 1: ORA-00922: missing or invalid
915330Apr 12 2012 — edited Apr 12 2012Hi friends,
I am installed oracle 10g on windows machine.
i m practicing PL/Sql in sql*plus
when i try to run this code
set serveroutput ON
declare
v_sum number;
begin
select sum(sal) into v_sum from emp;
dbms_output.put_line(v_sum);
end;
it gives this error
ERROR at line 1:
ORA-00922: missing or invalid
if i remove first line that is "set serveroutput on"
then it does not snow the output.
Kindly help :)