0 Replies Latest reply: Nov 18, 2012 8:26 AM by 695721 RSS

    tabular form update manual

    695721
      Dears ,
      i have manual tabular form
      select htmldb_item.checkbox(1,rownum) " ",
             x.service_id,
             x.service_name,
      htmldb_item.checkbox( 4, flag,decode( flag, 1, 1, 0) ) flag
      from (
      select htmldb_item.hidden(2,c.service_id) service_id,
                htmldb_item.text(3,s.service_name)  service_name,
                 htmldb_item.checkbox( 4, flag,decode( flag, 1, 1, 0) ) flag
      from  CUST_SERVICES c,SERVICES s 
      where c.service_id=s.service_id
      and  c.cust_id=:p6_customer_id) x
      order by 2
      and make process to save
      Type:     PL/SQL anonymous block
      Process Point : on submit - after computation and validation
      Run Process : once per page visit (defult)
      source code :
      for i in 1..htmldb_application.g_f01.count
      loop
      
      update CUST_SERVICES set flag = htmldb_application.g_f04(htmldb_application.g_f01(i));
       -- where CUST_ID=:p6_customer_id
       -- and  SERVICE_ID =htmldb_application.g_f02(htmldb_application.g_f01(i));
             
      end loop;
      put it's not save , please help