ORA-00911: 无效字符

将日志台打印出来的SQL代码复制到 PLSQL 中运行了一下,发现是能取到数据的,并不会报错!
SQL代码如下:
1 select b.id, 2 b.is_valid, 3 c.app_id system_id, 4 c.app_name system_name, 5 e.att_path as app_serh_id 6 from (select * 7 from SGWPDM_SYS_USER_SYSTEM a 8 where a.user_id = 'B2D16654E09D455EA3F257DF57BEBFB4') b, 9 SGCIS_DEV_ALLY_APP c, 10 SGCIS_DEV_ALLY_APP_PUBISH d, 11 t_Mx_Attachment e, 12 SGCIS_DEV_ALLY_APP_CLIENTTYPE f 13 where b.system_id = c.app_id 14 and b.system_id = d.app_id 15 and d.icon_image_id = e.pk_val 16 and d.publish_id = f.publish_id 17 and f.dict_id in ('4028abf4722743d4017227596b8f9032', 18 '4028abf4722743d4017227596b8f9029');
最后发现是不能够在代码中的sql语句末尾添加‘;’,在plsql 中写了并顺手复制到代码中的;

浙公网安备 33010602011771号