Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Date parameter is defined as date but I still get error
Summary: I have created p_date as a date parameter in my data model.
p_date is defined as date data type and parameter type date.
I am looking to get the days between p_date and apae1.start_date by subtracting p_date from apae1.start_date. The results should then be between 1 and 56. However I get an error about "expected Char got Date". Does this mean Oracle is not seeing p_date as a date even thought it was defined as one?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):24C
Tagged:
0