SAM

SQL> DECLARE
  2   x INTEGER;
  3  BEGIN
  4   x := 'belajar oracle!';
  5   dbms_output.put_line(x);
  6  EXCEPTION
  7   WHEN value_error THEN
  8   dbms_output.put_line('kesalahan pada pengisian nilai...');
  9  END;
 10  /
kesalahan pada pengisian nilai...

PL/SQL PROCEDURE successfully completed.

SQL> @d:\nafi\sesi1.SQL
kesalahan pada pengisian nilai...

PL/SQL PROCEDURE successfully completed.

SQL> SET echo ON
SQL> @d:\nafi\sesi1.SQL
SQL> DECLARE
  2   x INTEGER;
  3  BEGIN
  4   x := 'belajar oracle!';
  5   dbms_output.put_line(x);
  6  EXCEPTION
  7   WHEN value_error THEN
  8   dbms_output.put_line('kesalahan pada pengisian nilai...');
  9  END;
 10  /
kesalahan pada pengisian nilai...

PL/SQL PROCEDURE successfully completed.

SQL>