Advertisement
Guest User

SAM

a guest
Sep 6th, 2019
657
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SQL> DECLARE
  2.   2     x INTEGER;
  3.   3  BEGIN
  4.   4     x := 'Belajar ORACLE!';
  5.   5     dbms_output.put_line(x);
  6.   6  END;
  7.   7  /
  8. DECLARE
  9. *
  10. ERROR AT line 1:
  11. ORA-06502: PL/SQL: numeric OR VALUE error: character TO NUMBER conversion error
  12. ORA-06512: AT line 4
  13.  
  14. SQL> DECLARE
  15.   2     x INTEGER;
  16.   3  BEGIN
  17.   4     x := 'belajar oracle!';
  18.   5     dbms_output.put_line(x);
  19.   6  EXCEPTION
  20.   7     WHEN value_error THEN
  21.   8     dbms_output.put_line('kesalahan pada pengisian nilai...');
  22.   9  END;
  23.  10  /
  24. kesalahan pada pengisian nilai...
  25.  
  26. PL/SQL PROCEDURE successfully completed.
  27.  
  28. SQL> BEGIN
  29.   2     dbms_output.put_line('/* ini adalah komentar program */');
  30.   3  END;
  31.   4  /
  32. /* ini adalah komentar program */
  33.  
  34. PL/SQL PROCEDURE successfully completed.
  35.  
  36. SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement