generic way to get primary key values inside trigger

I need to get the string representation of the value of the primary key (possibly multi-column) of the current row being inserted into a table from within a post-insert trigger.

The code should not have any hard-coded dependency on the schema of the current table.

The following is a schema-dependent implementation of this

• create a table create table test( data_type_id number(11), name varchar(20), primary key(data_type_id, name) );

--attach a trigger
--this is the non-generic version

create or replace trigger test_trigger
after insert or update on test
for each row
declare

        keystring varchar(100);
begin

• I need a generic version of the following line select '[' || :new.data_type || '][' || :new.name ']' into keystring from dual;

end;
/

Any help is appreciated. Thanks Received on Thu Apr 05 2007 - 13:23:10 CDT