APEX

I don't know if I should be posting this in this Forum or the BI Publisher forum, so I am posting in BOTH forums..

I love APEX, let me say that first.. And appreciate the support offered here by the group, but am running int a confusing issue when BI Publisher tries to build a report from the above type APEX report..

Here is my dilemma:

I have a number of reports that are part of a Oracle package. They return an SQL Query back to a reports region on a page. I am having to deal with the column names returned are col01, col02..

The issue I have is, when building the Application Level query to download the XML sample from in building RTF layouts in Word, you can not use this code, you MUST use a standard SQL Select.

I have taken the sql from the function returning sql, and copied into the application query, supplying the required data values for bind variables being used in the query.

An XML file is produced, and I use this to build the RTF format file that I load back into APEX and try to use it for the PDF rendering of the report. I can view the output as a PDF in the Word add on, but when I try using it with the report, it is returning an empty PDF file.

Can anyone tell me what error log files on the bi publisher side I can look at to see what error is happening?

Thank you,

Tony Miller
UTMB/EHN

Title changed, maybe SOMEONE has an idea on this??

Message was edited by:
Tony Miller