how to write a code to update table in XML Data template
Hi All,
I have a code like this, but due to performance issue i had created function to update table and passing group level columns as a parameter.
group name="G_inv_term" dataType="varchar2" source="Q_invoice"
groupFilter="FLTARINVXML.g_inv_termgroupfilter(:G_invoice.CUSTOMER_TRX_ID, :G_invoice.TERM_COUNT, :G_inv_term.TERM_SEQUENCE_NUMBER,:G_invoice.TRX_TYPE,:G_invoice.PRINTING_COUNT)">
so instead of above group filer i am trying to using function to update table.
FUNCTION update_cust_trx()
RETURN varchar2
IS
pragma autonomous_transaction;
v_cust_id NUMBER;
UPDATE ra_customer_trx_all