数据修改过程中出现问题—— ora-20595, ora-06512, ora-04088

[tangxiudong123]

如题

[minitoy]

呵呵,无图无真相

[tangxiudong123]

ora-20595: no data found in single select.
ora-06512: at "TEST.TR_U_COMPONENT", line 60
ora-04088: error during excution of trigger 'TEST.TR_U_COMPONENT'

[tangxiudong123]

图片怎么上啊？我上了可是在别的机器显示不出来，我郁闷的

[jg_huang]

看不到图

[心中的彩虹]

[Quote=引用 2 楼 tangxiudong123 的回复:]
ora-20595: no data found in single select.
ora-06512: at "TEST.TR_U_COMPONENT", line 60
ora-04088: error during excution of trigger 'TEST.TR_U_COMPONENT'
[/Quote]
详细的语句

从错误上看 激活了触发的条件

[心中的彩虹]

[Quote=引用 6 楼 wkc168 的回复:]
引用 2 楼 tangxiudong123 的回复:
ora-20595: no data found in single select.
ora-06512: at "TEST.TR_U_COMPONENT", line 60
ora-04088: error during excution of trigger 'TEST.TR_U_COMPONENT'

详细的语句

从错……
[/Quote]

'TEST.TR_U_COMPONENT'
仔细看你的触发器的触发体

[tangxiudong123]

ora-20595: no data found in single select.
ora-06512: at "TEST.TR_U_COMPONENT", line 60
ora-04088: error during excution of trigger 'TEST.TR_U_COMPONENT'

WHEN NO_DATA_FOUND THEN
raise_application_error (-20595, 'No data found in a single select.');