分类(Oracle)
SQLERRM SQLCODE 的简单用法
2008/05/20 15:38

set serveroutput on

 1  declare
 3  begin
 4   insert into tmp_3(user_no,tc) values(98765432103211,'IJ');
 5   exception when others then
 6   DBMS_OUTPUT.put_line   (       'ERR:insert_exception_log: '
 7                                                                ||   TO_CHAR   (SQLCODE)
 8                                                                ||   '   '
 9                                                                ||   SQLERRM
10                                                              );
11 end;

 

 

Tags: Oracle
相关日志:
+引用(0) |
发表评论
昵称  密码  游客无需密码
网址  电邮  注册
验证码 请输入左侧图片中的字符
记住我