-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|