Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder Bengal313's Avatar
    Join Date
    Jun 2002
    Location
    Metro Detroit
    Posts
    298
    Thanks
    8
    Thanked 0 Times in 0 Posts

    oracle doesn't recognize the number field

    Environment: Apache 2, php 4.3.2, Linux Suse, Oracle 9i, Dreamweaver MX ( Phakt 2.6 extension)

    I have a php search page that queries a oracle database. The seach fields are "house_number" and "street_name". When I search the database I get this error: "ORA-01722: invalid number".
    Which means that the oracle database doesn't recognize the number entered in the house_number field as a number. In the database the field is listed as type number. How can I resolve this without having to change the data type in my database.
    "Knowledge Speaks But Wisdom Listens"

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,280
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Well are you sending the number as a number or is it being sent as a string? Post your SQL for it.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    here is a great link.....

    http://www.orafaq.com/error/ora-01722.htm

    Read Up, it tells you what all of your problems can be and ways to fix them.....

  • #4
    Regular Coder Bengal313's Avatar
    Join Date
    Jun 2002
    Location
    Metro Detroit
    Posts
    298
    Thanks
    8
    Thanked 0 Times in 0 Posts
    I got it work. For some reason if I put my form as a "GET" method instead of "post"it works.
    "Knowledge Speaks But Wisdom Listens"

  • #5
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,280
    Thanks
    4
    Thanked 83 Times in 82 Posts
    If that change fixed the problem then my guess is your POST variables did not have values which could indicate you did not access the POST data correctly or you have some kind of configuration problem.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster


  •  

    Posting Permissions

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