'how to save a oracle form field values to a database table

BEGIN
  INSERT INTO tbmt_brg_agency_letters
    (ID,
     MTBRG_CREATE_DAT,
     MTBRG_ORNNN_ID,
     MTBRG_RATING_AGENCY_TXT,
     MTBRG_EXTRNL_LTR_RATING_TXT)
  VALUES
    ( MTBLR_SEQ.NEXTVAL,
     :VWMTBRG.CREATE_DAT,
     :VWMTBRG.ORNNN_ID,
     :VWMTBRG.RATING_AGENCY_TXT,
     :VWMTBRG.EXTERNAL_LETTER_RATING_TXT);
  COMMIT;
END;

when i tried to save form values to a table it not saving, I'm using WHEN-BUTTON-PRESSED trigger. I'm trying to insert one table values to other table which are selected using a dropdowm in a form.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source