Oracle 中的触发器错误，请大家帮忙看看哪里错了！ - ITeye问答
大家看看我这个 触发器 哪里错了，执行时 报 ORA-00036: Maximum number of recursive sql levels (50) exceeded
错误
create or replace trigger deletebefor_out_shipstoptime
& after& insert or update or delete
& on TBLSHIPINFO&
& begin
&&& delete from TBLSHIPINFO t& where t.out_shipstoptime&(select to_char(sysdate-4,'YYYY-MM-DD')&& from dual);
&&& end deletebefor_out_
网上 说的是：ORA-00036:_超过递归_SQL_(50)_级的最大值
但不明白是什么意思，如何改
问题补充：但是我在修改一条数据的时候还是不成功呀！并且是在修改后触发，这也没有形成死循环呀！
你执行是修改，触发器中改为修改后触发，这样也是死循环啊
1你对表TBLSHIPINFO建的delete触发器，而触发器的内容又是向表TBLSHIPINF中delete数据，所以这个触发器一直在被递归调用。 故形成死循环
2 最好不要对表的delete和insert建立触发器，没多大用处
已解决问题
未解决问题请大家帮忙看看这个jquery调试dialog的问题。即不报错，也不出来。。。
各位 ，jquery调试太困难了。请大家帮忙看看在那出的问题。
&meta http-equiv=&X-UA-Compatible& content=&IE=7.5&&
&meta http-equiv=&Content-Type& content=&text/ charset=GBK&&
&title&&/title&
&&& &!--& --&&&&
&&& & &link rel=&stylesheet& type=&text/css& href=&/clickDemo/assets/style.css& title=&Style&/&
&&&& &link rel=&stylesheet& type=&text/css& href=&/clickDemo/assets/css/syntax-highlighter.css&/&
&&&& &script type=&text/javascript& src=&/clickDemo/assets/js/syntax-highlighter.js&&&/script&
&&&&&&& &link href=&/clickDemo/click/control.css& rel=&stylesheet& type=&text/css&/&
&link href=&/clickDemo/click/menu.css& rel=&stylesheet& type=&text/css&/&
&link href=&/clickDemo/assets/js/jqueryui/themes/sunny/jquery.ui.all.css& rel=&stylesheet& type=&text/css&/&
&div class=&page&&
& &div class=&header&&
& &&& &div class=&title-left&&
&&& &/div&
&&&&&&&&&&&
&&&&& &/div&
&&div class=&content& &
&table width=&95%&&
&&td align=&center&&& &!DOCTYPE HTML PUBLIC &-//W3C//DTD HTML 4.01 Transitional//EN&&
&&& &title&myUI.html&/title&
&&& &meta http-equiv=&keywords& content=&keyword1,keyword2,keyword3&&
&&& &meta http-equiv=&description& content=&this is my page&&
&&& &meta http-equiv=&content-type& content=&text/ charset=UTF-8&&
&&& &!--&link rel=&stylesheet& type=&text/css& href=&./styles.css&&--&
&&& This is my HTML page. &br&&br&&br&&form method=&post& name=&HtmlForm& id=&HtmlForm& action=&/clickDemo/page/myUI.htm&&
&input type=&hidden& name=&form_name& id=&HtmlForm_form_name& value=&HtmlForm&/&
&input type=&hidden& name=&bypass_validation& id=&HtmlForm_bypass_validation& value=&false&/&
&table class=&form& id=&HtmlForm-form&&&tbody&
&table class=&fields& id=&HtmlForm-fields&&&tbody&
&tr class=&fields&&
&td class=&fields& align=&left&&&label for=&HtmlForm_name&&name&/label&&span class=&required&&*&/span&&/td&
&td align=&left&&&input type=&text& name=&name& id=&HtmlForm_name& value=&dsdf& size=&20& title=&name|name &/&&/td&
&/tbody&&/table&
&/td&&/tr&
&tr&&td align=&left&&
&table class=&buttons& id=&HtmlForm-buttons&&&tbody&
&tr class=&buttons&&&td class=&buttons&&&input type=&submit& name=&form-sub& id=&HtmlForm_form-sub& value=&show dialog&/&&/td&&/tr&
&/tbody&&/table&
&/td&&/tr&
&/tbody&&/table&
&/td&&/tr&
&script src=&/clickDemo/click/control.js& type=&text/javascript&&&/script&
&!--[if lt IE 7]&
&script src=&/clickDemo/click/menu-fix-ie6.js& type=&text/javascript&&&/script&
&![endif]--&
&script src=&/clickDemo/assets/js/jqueryui/jquery-1.6.2.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/external/jquery.bgiframe-2.1.2.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.core.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.widget.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.mouse.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.draggable.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.position.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.resizable.js& type=&text/javascript&&&/script&
&script src=&/clickDemo/assets/js/jqueryui/ui/jquery.ui.dialog.js& type=&text/javascript&&&/script&
&!--[if lt IE 7]&
&script id=&rootMenu-js-setup& type=&text/javascript&&
Click.addLoadEvent(function(){
&if(typeof Click != 'undefined' && typeof Click.menu != 'undefined') {
&& if(typeof Click.menu.fixHiddenMenu != 'undefined') {
&&&& Click.menu.fixHiddenMenu(&rootMenu&);
&&&& Click.menu.fixHover(&rootMenu&);
&![endif]--&
&script type=&text/javascript&&
$(function(){$('#jquery-dialog').dialog({buttons:{Ok:function(){$(this).dialog('close');location='/clickDemo/page/myUI.htm?actionLink=okLink'},Cancel:function(){$(this).dialog('close');}}});})
$(function(){ &&$(&#jquery-dialog&).dialog({ &&&buttons:{ &&&&&Ok&:function(){ &&&&&$(this).dialog(&close&); &&&&&location=&&; &&&&}, &&&&&Cancel&:function(){ &&&&&$(this).dialog(&close&); &&&&} &&&} &&}); &});
谢谢。我再试试。}