1 Reply Latest reply: Jul 26, 2013 5:53 AM by jariola RSS

    how to use procedure into loop with tabular form with checked check box.

    Vedant

      Dear friends,

       

      i have created tabular form with check box with below sql statement.

      {code }

      select booking_id,hotel_code,totel_amt,unit1,unit2,unit3,rate 1,rate2,rate3 from booking_master

      {code}

       

      now i want to apply procedure with that tabular form.

      i want to insert record into other table which row are checked into tabular form.

      how to apply loop into procedure.

       

      my procedure are

       

      {code}

       

      declare

      p_msg varchar2(2000);

      p_err varchar2(2000);

      begin

      pkg_booking.generate_new_booking(hotel_code,booking_id,p_msg,p_err);

      end;

       

      how to call this package into loop with tabular form rows which i have checked.

       

      Thanks