Jamdagni & Danishment, Thanks for your help. I opened a ticket with Oracle and it got fixed. See the Oracle explanation ...
This is bug 614799. Abstract: ORA-600[17034] WHEN CONSTRAINT IS VIOLATED Workaround is: set AUDIT_TRAIL=NONE or set AUDIT_TRAIL=FALSE Thanks, Bob --- Danisment Gazi Unal <[EMAIL PROTECTED]> wrote: > Hi, > > can you paste ora-600 trace files to list ? > > "Jamadagni, Rajendra" wrote: > > > Check the code in the trigger it seems that one of > the variables is getting > > assigned a value that is longer than it can hold. > The ora-20000 error is > > user generated. Check on metalink you could be > running into a bug, one of > > the posters got it resolved by pinning all the > packages in SGA. > > > > Anyways, the mantra is 'If you see ora-600 error, > first contact OWS and then > > the list.' > > > > HTH > > Raj > > > ______________________________________________________ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't > reflect that of ESPN Inc. > > > > QOTD: Any clod can have facts, but having an > opinion is an art! > > > > > ------------------------------------------------------------------------ > > Name: > ESPN_Disclaimer.txt > > ESPN_Disclaimer.txt Type: Plain Text > (text/plain) > > Encoding: 7bit > > -- > Danisment Gazi Unal > http://www.unal-bilisim.com > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Danisment Gazi Unal > 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). __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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).
