ORA-01722: invalid number
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01722: invalid number

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Question

    Hi all !
    I've encountered a very strange behavior with a PowerBuilder application ...
    The application try to insert one row with a decimal column in the prod database and get the "ORA-01722: invalid number" error.
    The same application (same .exe on the client side) connecting to the test database and trying to insert the same row does not encountered problem ...
    The nls parameters are exactly the same on both the databases.
    Any idea ?
    Thanks a lot in advance for your inputs ...


  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Could you please tell me what are the values you are trying to insert...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  3. #3
    Join Date
    Dec 2001
    Posts
    141
    Neither 56.23 and 56,23 work ...

Posting Permissions

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


Click Here to Expand Forum to Full Width