Rob Kraft's Software Development Blog

Software Development Insights

One Cause of ORA-00600 with qctstc2o1

Posted by robkraft on February 24, 2015

Today one of my queries failed on Oracle because the query had too many columns.  The query is very simple, but returns 1023 columns of output.  The query is simply

SELECT * FROM TABLE1

INNER JOIN TABLE2 ON TABLE1.COL1 = TABLE2.COL1

INNER JOIN TABLE3 ON TABLE1.COL1 = TABLE3.COL1

INNER JOIN TABLE4 ON TABLE1.COL1 = TABLE4.COL1

If I remove any of the joins from the query it will succeed.  If I return fewer than 1000 columns it will succeed.  But if I run it as is I get this error:

Error report:

SQL Error: ORA-00600: internal error code, arguments: [qctstc2o1], [1], [0], [0], [1], [0], [0], []

00600. 00000 –  “internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]”

*Cause:    This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.

*Action:   Report as a bug – the first argument is the internal error number

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: