1 Reply Latest reply: May 7, 2008 1:24 PM by 638075 RSS

    Stored Procedure + Form personalization

    568940
      Hi , i have a procedure that will update a field in the table ra_cust_trx_line_gl_dist_all.
      PROCEDURE updateCcid(ccid IN NUMBER,custTrxLineId IN NUMBER) IS
       
        BEGIN
       
        UPDATE ra_cust_trx_line_gl_dist_all
      SET code_combination_id = ccid
      WHERE customer_trx_line_id = custTrxLineId;

      END updateCcid;
      I call the procedure in my form personalisation as follows
      ='BEGIN
      apps.XXGL_MAJAVOIRSEXOANT_PKG.updateCcid('''||${item.tacc_acc_assgn.code_combination_id.value},${item.tacc_acc_assgn.customer_trx_line_id.value}||''');
      END'


      But the field is not updated..


      Help please......

      Regards
      Lutchumaya