sql - Mutating table exception when selecting max(date column of TABLE_X) in an after update trigger for TABLE_X -


i have trigger (sorry can't display actual sql because of company rules , different machine): 

create or replace trigger tr_table_x_au after update   on table_x each row  declare   cursor cursor_select_fk     select fk_for_another_table       table_y y, table_z z      :new.joining_col = y.joining_col        , y.joining_col = z.joining_col        , :new.filter_condition_1 = y.filter_condition_1        , :new.filter_condition_2 = y.filter_condition_2        , :new.some_date_col = (select max(some_date_col)                                    table_x                                   filter_condition_1 = :new.filter_condition_1                                      , filter_condition_2 = :new.filter_condition_2) begin   rec in cursor_select_fk loop     pck_some_package.some_proc(rec.fk_for_another_table);   end loop; end tr_table_x_au;

we resulted triggers since enhancement. nested query selecting max date seems cause of problem. changing sysdate results no exceptions. idea on how can max date during execution of trigger table_x? thanks!

edit: also, seems similar functions such count,sum,etc... produces same error. knows workaround this?

a mutating table table being modified update, delete, or insert statement, or table might updated effects of delete cascade constraint.

the session issued triggering statement cannot query or modify mutating table. restriction prevents trigger seeing inconsistent set of data.

trigger restrictions on mutating tables

which means, cannot issue max(some_date_col) on table_x in row-level trigger.

compound trigger possible workaround.


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more