Search This Blog

Friday, April 10, 2009

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

One of our Production database we are getting following ORA-00600 error

OS: Windows 2003

DB: 10.2.0.4.0 (Jan-09 CPU Applied)

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

Solution:

There is no solution yet on metalink...

Kindly submit "Trace Files" & "Alert Log" to Oracle Support

Above Error Fixed In the 11.2 Version

Metalink Note: 756784.1

Temporary Workaround:

If

An ORA-600 can occur while recompiling stored PLSQL if a procedure / function argument name matches to a columnname referred to in that function / procedure .

Then

Change the Function/procedure's argument name so that it does not match to any column name being referred in the function/procedure body.

1 comment:

Kubilay Tsil Kara said...

So good.

Well done. This has saved me time! Why couldn't they give a much more meaningful error, like " Hey, you have named your parameters the same name as your table columns..." Or something similar... I guess we have to wait for 11g R2 to fix it.

Thank you!