2 Replies Latest reply: Apr 16, 2012 4:06 AM by user11170803 RSS

    Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception OR

    914232
      hi all

      i am facing a problem.i hav a master detail form. my 'select into' has to fectch more than one record in detail which is tabular.

      it giving error(FRM-40735:WHEN-MOUSE-CLICK TRIGGER raised unhandled exception ORA-01422).

      so i had written cursor to fetch records.

      DECLARE
      CURSOR Fetch_Rec IS
      select bill_id,mat_id,mat_code,send_qty,rec_qty,ast_no,serial_no,transact_note
      from ship_dtl;
      BEGIN
           GO_BLOCK('ship_dtl');
      FOR Get_Rec IN (select bill_id,mat_id,mat_code,send_qty,rec_qty,ast_no,serial_no,transact_note
      from ship_dtl where rec_qty=null AND rec_qty != send_qty AND BILL_ID=:SHIP_MSTR.BILL_ID) LOOP
           
      :ship_dtl.bill_id:=get_rec.bill_id;
      :ship_dtl.mat_id:=get_rec.mat_id;
      :ship_dtl.mat_code:=get_rec.mat_code;
      :ship_dtl.send_qty:=get_rec.send_qty;
      :ship_dtl.rec_qty:=get_rec.rec_qty;
      :ship_dtl.ast_no:=get_rec.ast_no;
      :ship_dtl.serial_no:=get_rec.serial_no;
      :ship_dtl.transact_note:=get_rec.transact_note;


      NEXT_RECORD;
      END LOOP;

      FIRST_RECORD;

      END;

      it is not retriving any records.please help.i also put ship_mstr.bill_id in properties of ship_dtl.bill_id(copy value)


      so please guide me how to handle it.
      thanks in advance