This discussion is archived
1 Reply Latest reply: Jul 26, 2013 3:53 AM by jariola RSS

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

Vedant Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points