I have an Oracle app report that produces a No Data Found message. I am trying to pass two Date input arguments. If I run the same report in Infomaker, it runs fine. Do I have to edit my nls_date_format to DD-MON-YYY ? Right now, it is blank. Does Oracle automatically default the date to DD-MON-YY even if it's blank? Also, what should I reference my date columns in my procedure in order for this to work? Help ! I really don't want to make these input date parameters string datatypes. I want them to be Date datatypes.
>what should I reference my date columns in my procedure
Here is a free clue, as what you & I have typed are STRINGS!
You & I can ONLY enter strings from a keyboard.
However you can convert strings into dates using TO_CHAR.
It is bad coding practice to allow implicit date type conversions.
You should always use explicit datatype conversions.
Does this answer your question?
No. Maybe I rambled on in my description and lost the point I was trying to make.
I have two date fields --> startdate & stopdate
I enter a startdate and stopdate at my prompt in my Oracle app report.
I get No Data Found
If I run the report directly from Infomaker, I do not get the error and my report displays fine.