Tapi error in table with BLOB
Generating the Table API from a table with a BLOB field results in this error (while compiling the triggers/packages):
Creating Before Insert Row Trigger on 'DOCUMENTEN'
CREATE OR REPLACE TRIGGER cg$BIR_DOCUMENTEN
*
ERROR at line 1:
ORA-25003: cannot change NEW values for this column type in trigger
and
PLS-00306: wrong number or types of arguments in call to '!='
In the generated code statements like this occur (INHOUD is the BLOB field):
IF (cg$tmp_rec.INHOUD != cg$old_rec.INHOUD) THEN ...
Is there any possibility to create the TAPI without these statements for the BLOB field(s)?
Is there an other (easy) way to generate the code for the server-derived fields without having to write my own triggers?
Theo