I've been successfully using the following statements to turn on SQL tracing for TABLE FILE commands against Oracle tables and views:
-* Activate the trace facility, and make sure that only the traces we want are -* activated. SET TRACEUSER = ON SET TRACEOFF = ALL -* Activate Aggregation/Join analysis and Statement tracing. SET TRACEON = SQLAGGR//CLIENT SET TRACEON = STMTRACE//CLIENT -* Turn off the printing of a timestamp, within the statement trace. SET TRACESTAMP=OFF -RUN
When I attempt to trace a TABLE FILE command against an Oracle Package.Stored Procedure, the trace returns no generated SQL.This message has been edited. Last edited by: David Briars,
I've no clue on your issue, though would like to share a post bookmarked recently related to this(not Oracle SP's).
Table Yeilds Error on Query, Not sure why
Check Wep5622's last comments, you might need to look at the source code of HTML if you enable &ECHO.
WebFOCUS 7.7.x and 8.x
The IB HelpDesk assisted me with this question.
|Powered by Social Strata|