Try:
insert into platformmapkeys( platformid, keypart1indic, keypart2indic, keypart3indic )
VALUES ( :new.platformid, v_keypart1indic, v_keypart2indic, v_keypart3indic );
- Chris
Printable View
Try:
insert into platformmapkeys( platformid, keypart1indic, keypart2indic, keypart3indic )
VALUES ( :new.platformid, v_keypart1indic, v_keypart2indic, v_keypart3indic );
- Chris
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.