Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> DECLARE
- 2 x INTEGER;
- 3 BEGIN
- 4 x := 'Belajar ORACLE!';
- 5 dbms_output.put_line(x);
- 6 END;
- 7 /
- DECLARE
- *
- ERROR AT line 1:
- ORA-06502: PL/SQL: numeric OR VALUE error: character TO NUMBER conversion error
- ORA-06512: AT line 4
- 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> BEGIN
- 2 dbms_output.put_line('/* ini adalah komentar program */');
- 3 END;
- 4 /
- /* ini adalah komentar program */
- PL/SQL PROCEDURE successfully completed.
- SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement