Results 1 to 4 of 4

Thread: no data found

  1. #1
    Join Date
    Jan 2004
    Posts
    19

    Unanswered: no data found

    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.
    tfil

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >what should I reference my date columns in my procedure
    HUH?
    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?

  3. #3
    Join Date
    Jan 2004
    Posts
    19
    [i]
    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.

    Where could the problem lie?
    tfil

  4. #4
    Join Date
    Jan 2004
    Posts
    37
    if you have defined the parameter as date type then you need to give the format as DD-MON-RR/YY
    else it will return an error....
    or you do an explicit conversion inside the body of your function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •