Date parameter is defined as date but I still get error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!