In addition to my previous question: supposed you cannot use Max(date), and MUST use the cursor. (may be my example is not a good one), anyway, I'd like to know how to get around this mutating problem. Thank you! --- Leslie Lu <[EMAIL PROTECTED]> wrote: > Hi all, > > I got ORA-04091: table mutating problem. Here is > the > case: select from table A and insert them into table > B. A trigger is used to check that new DATE must be > later than every DATE in B. So I open an cursor, > loop > through cursor to compare new DATE value. > > If I tested using hard coded value, the trigger > works; > if do a insert ... select, I got ORA-04091. > > I looked through metalink, didn't see anything that > can help. > > Thank you in advance. > > Leslie > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great > prices > http://auctions.yahoo.com/ > __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
