ORA-600 [QERNCROWP1] WITH PARALLEL DEGREE (Doc ID 1073146.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.

Symptoms

Procedure inserting data fails with internal error, when  parallel degree is used on subquery. 
ORA-00600: internal error code, arguments: [qerncRowP1], [3], [4], [], [], [], [], [] 


-- FAILED 10.2.0.4.0 (the two select without insert failed too)
insert into t_test_target
   select * from table(pck_test.f_getprocessrow_outer(cursor(
     select * from table(pck_test.f_getprocessrow_inner(cursor(
                       select /*+ parallel(s,4) */ * from t_test_source s
                       ))) x
                   ))) y
ORA-12801: error signaled in parallel query server P003
ORA-600: internal error code, arguments: [qerncRowP1], [3], [4], [], [], 
[], [], [] ORA-6512: at "DWHMAST.PCK_TEST", line 75                    
                         

-- WORKED 10.2.0.4.0
insert into t_test_target
   select * from table(pck_test.f_getprocessrow_outer(cursor(
     select * from table(pck_test.f_getprocessrow_inner(cursor(
                       select * from t_test_source s
                       ))) x
                   ))) y

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms