Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Hyderabad
    Posts
    7

    Unanswered: Problem with date fields

    Hi,

    My application (VB) uses Oracle 8i.
    Recently it has been upgraded to Oracle 9i.
    Now we are having a problem with the application while retriving the date fields which are null. It gives an error -"22007 - Invalid Date format". But earlier we never this error. We are able to retrieve null date fileds from the SQL prompt.

    When Oracle is upgraded to 9i, do we have to change any parameters or code of the application?

    Please suggest.

    Thanks
    Vinaya

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Is the NLS_DATE_FORMAT different on the 9i database then on the 8I?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Feb 2004
    Location
    Hyderabad
    Posts
    7
    Yes,

    The NLS_DATE_FORMAT is the same for bothe 8i and 9i

    Vinaya

Posting Permissions

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