Summary

Inserting into database table in XML Data Template

Content

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

Thanks

Sanjay