Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 41 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI 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