ORA-600 [KZRTSRCP - VCOLP] Or ORA-600 [KZRTSRCP - PCOLP] While Updating Tables Protected By FGAC Policies (Doc ID 1050982.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

While updating a table protected by VPD an ORA-600 [kzrtsrcp - pcolp] or an ORA-600 [kzrtsrcp - vcolp] error can occur. The error occurs when the table has a user defined type with a LOB datatype:

conn / as sysdba

drop user test cascade;
create user test identified by test;
grant connect, resource to test;

create or replace directory DIR_TESTCASE as '\uo1\oracle\';
grant read on directory DIR_TESTCASE to public;


CREATE OR REPLACE TYPE test.atype AS OBJECT (
aclob BLOB ,
achar CHAR(8));
/

create table test.test(col1 test.atype, col2 number, col3 varchar2(100));


conn / as sysdba

create or replace function test.pol_fun(object_schema in varchar2, object_name in varchar2) return varchar2 is

d_predicate varchar2(2000);
BEGIN
d_predicate := '1=1';
RETURN d_predicate;
END pol_fun;
/

BEGIN
dbms_rls.drop_policy(object_schema =>'test',object_name=>'test',policy_name=>'piet_policy');
END;
/


BEGIN
dbms_rls.add_policy(object_schema => 'test',
object_name => 'test',
policy_name => 'piet_policy',
function_schema => 'test',
policy_function => 'pol_fun',
statement_types => 'update',
sec_relevant_cols => 'col1');
END;
/




insert into test.test values(test.atype(empty_blob(),'AAA'),2,'AAA');
insert into test.test values (NULL,10,'AAA');
insert into test.test values (NULL,20,'AAA');
commit;



set serveroutput on
conn test/test

update test.test
set col1=(select col1 from test.test where col2=10)
where col2=20;

ORA-00600: internal error code, arguments: [kzrtsrcp - pcolp], [], [], [],[], [], [], []


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