BI Publisher (MOSC)

MOSC Banner

how to write a code to update table in XML Data template

edited Sep 23, 2017 5:00AM in BI Publisher (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center