insert into platformmapkeys( platformid, keypart1indic, keypart2indic, keypart3indic )
VALUES ( :new.platformid, v_keypart1indic, v_keypart2indic, v_keypart3indic );
Chris, yes, I tried it, but I received this:
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "FITS.ADDNEWPLATFORM", line 34
ORA-20500: Trigger forces a rollback
ORA-06512: at "FITS.TRI_PLATFORMMAPKEYS", line 39
ORA-04088: error during execution of trigger 'FITS.TRI_PLATFORMMAPKEYS'
ORA-06512: at "FITS.TRI_PLATFORMS", line 90
ORA-04088: error during execution of trigger 'FITS.TRI_PLATFORMS'
ORA-06512: at line 1
The problem have been solved.
The error occur because there is another trigger associated with the table 'platformmapkeys' that checks the existance of the platformid value just generated from platform table, since the transaction it's end yet so it will always fail.
Click Here to Expand Forum to Full Width