error while executing ASH report
We are getting below error during executing ashrpt.sql
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is ashrpt_1_1116_1100.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: ashrpt_1_1116_1100.txt
Using the report name ashrpt_1_1116_1100.txt
Summary of All User Input
-------------------------
Format : TEXT
DB Id : 2559204448
Inst num : 1
Begin time : 16-Nov-13 10:30:01
End time : 16-Nov-13 11:00:01
Slot width : Default
Report targets : 0
Report name : ashrpt_1_1116_1100.txt
select output from table(dbms_workload_repository.ash_report_text( :dbid,
*
ERROR at line 1:
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 11407