Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
No Output When Adding Parameters in the Bursting Query
This is my snippet of my added code. Both SUCCESS SCHEDULE
USING HARDCODED DATES
USING LINE2 PARAMETER
Answers
-
Hi
Just to test if it is a datatype issue , can you check if below format works
WHERE TRUNC(htrgs.START_TIME) BETWEEN TO_DATE(:p_startDate, 'DD/MM/YYYY') AND TO_DATE(:p_endDate, 'DD/MM/YYYY')
You can also capture diagnostic log to check the processing
Regards,
Prabhu
0 -
@Prabhu Krishnamoorthy -Oracle Hi, Thank you for your response, it shows error when running the DM,
Also this is the Diagnostic if using the the Parameter above.
0 -
Hi
Thanks. So it appears to be format mismatch
From BI Publisher documentation
Oracle BI Publisher always binds date column or date parameter as a timestamp object.
To avoid timestamp conversion, define the parameter as a string and pass the value with formatting as 'DD-MON-YYYY' to match the RDBMS date format.
Hope this helps
Regards,
Prabhu
0