Oracle Reports bypassing Report Writer

[techstar]

I would like bypass the Delphi report writer by running an Oracle report and then displaying the report as an editable document. I would like to do this by dynamically creating the Oracle SQL for a report, sending it to Oracle via a DOA tOracleQuery, then capturing the output of the query on a line by line basis.

Unfortunately, a number of problems seem to stand in the way. First, using TOracleQuery, Oracle does not want to actually run standard Oracle report commands (e.g., Column). Next, the TOracleQuery object want to capture the fields as opposed to the rows of output.

Has anyone found a way to do this?

------------------
Perry Schwartz
TechStar International

 

[Paul Campbell]

This may not work for you, but I thought I'd pass it along anyway. I've done what you're trying to do by constructing the Oracle SQL script file as an ordinary text file (say, MyScript.SQL). The script would have spool commands to capture your SQL output. You'd then shell out and execute the script (like, SQLPLUS SYSTEM/MANAGER@MYDB @MyScript.SQL) and then read in the spooled file after completion. Not the most elegant way, but it works.