14:25:57 SQL> set serveroutput on
15:13:53 SQL>
15:13:53 SQL> declare
15:13:53 2 n number;
15:13:53 3 begin
15:13:53 4 select 'ddd' into n from dual;
15:13:53 5 exception
15:13:53 6 when others then
15:13:53 7 dbms_output.put_line(sqlcode||':'||sqlerrm);
15:13:53 8 end;
15:13:53 9 /
-6502:ORA-06502: PL/SQL: 数字或值错误 : 字符到数值的转换错误PL/SQL 过程已成功完成。已用时间: 00: 00: 00.30
15:13:53 SQL>
15:13:53 SQL> declare
15:13:53 2 n number;
15:13:53 3 begin
15:13:53 4 select 'ddd' into n from dual;
15:13:53 5 exception
15:13:53 6 when others then
15:13:53 7 dbms_output.put_line(sqlcode||':'||sqlerrm);
15:13:53 8 end;
15:13:53 9 /
-6502:ORA-06502: PL/SQL: 数字或值错误 : 字符到数值的转换错误PL/SQL 过程已成功完成。已用时间: 00: 00: 00.30
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货