| Report 6i problem after upgrading from reports 2.5 [message #89868] |
Wed, 11 August 2004 03:35 |
Manish
Messages: 79
Registered: December 2000
|
Member |
|
|
The help files for oracle say: The Before Report trigger fires before the report is executed but after queries are parsed and data is fetched.
Thats how I thought oracle executes its triggers however I have included extracts from a trace log that I got after running a report, it seams to indicate that something placed in a before_report_trigger fires before the main query has been parsed.:
start of log file..:
15:05:08 PLS ( Function: f_beforereport
15:05:10 MSG MSG-00000: Query returns no rows
15:05:10 PLS ) Function: f_beforereport
15:05:10 PLS ( Function: pr_date1formula
15:05:10 PLS ) Function: pr_date1formula
15:05:10 PLS ( Function: co_name1formula
15:05:10 PLS ) Function: co_name1formula
15:05:10 APP ( Frame
15:05:10 APP . ( Text Boilerplate B_2
15:05:10 APP . ) Text Boilerplate B_2
15:05:10 APP . ( Text Boilerplate B_6
15:05:10 APP . ) Text Boilerplate B_6
15:05:10 APP . ( Text Field F_PAGE_NO1
15:05:10 APP . ) Text Field F_PAGE_NO1
15:05:10 APP . ( Text Field F_CO_NAME
15:05:10 APP .. ( Computed Column co_name1
15:05:10 APP .. ) Computed Column co_name1
15:05:10 APP . ) Text Field F_CO_NAME
15:05:10 APP . ( Text Field F_REP_TITLE
15:05:10 APP .. ( Computed Column CP_REP_TITLE
15:05:10 APP .. ) Computed Column CP_REP_TITLE
15:05:10 APP . ) Text Field F_REP_TITLE
15:05:10 APP . ( Text Field F_REP_NAME
15:05:10 APP .. ( Computed Column CP_REP_NAME
15:05:10 APP .. ) Computed Column CP_REP_NAME
15:05:10 APP . ) Text Field F_REP_NAME
15:05:10 APP . ( Text Field F_DATE
15:05:10 APP .. ( Computed Column pr_date1
15:05:10 APP .. ) Computed Column pr_date1
15:05:10 APP . ) Text Field F_DATE
15:05:10 APP ) Frame
15:05:10 APP ( Frame
15:05:10 PLS . ( Function: m_group_grpfrformattrigger
15:05:10 PLS . ) Function: m_group_grpfrformattrigger
15:05:10 APP . ( Frame M_GROUP_GRPFR
15:05:10 APP .. ( Repeating Frame R_GROUP
15:05:10 APP ... ( Group G_1 Local Break: 0 Global Break: 0
15:05:10 APP .... ( Query Q_order_details
15:05:10 SQL EXECUTE QUERY : select grp.group_name,
dep.dept,
dep.dept_name,
dep.group_no,
sup.supplier,
sup.sup_name,
sma.authorise,
sma.reason_code,
ohr.rev_date,
etc..
The log file seams to record the Function: f_beforereport, which is in the before report trigger, firing at the start of the report and then producing an error 'no rows returned'. before continuing with the rest of the report.
If I place a simple message in the code before the call to procedure 'no_rows_returned' then the report works fine.
Incidently the report works fine in its original pre upgrade V2.5 state.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
