Inserting into database table in XML Data Template
SummaryInserting into database table in XML Data Template
I am using XML Publisher reports for Oracle EBS concurrent program.
Previously, when I used Oracle Reports rdf, for complex queries I created a custom database table and inserted data into this table (by breaking down the query in smaller blocks) in the Before Report trigger, and in the main query I simply queried from this custom table. Subsequently in the After Report trigger I purged the table.
Can something similar be done when writing queries in XML Data Template (XML Publisher > Data Definitions > Data Template), i.e. insert/u[date into a database table first