View Full Version : oracle doesn't recognize the number field

11-06-2003, 08:13 PM
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.

11-06-2003, 08:15 PM
Well are you sending the number as a number or is it being sent as a string? Post your SQL for it.

11-06-2003, 10:54 PM
here is a great link.....


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

11-07-2003, 02:35 AM
I got it work. For some reason if I put my form as a "GET" method instead of "post"it works.

11-07-2003, 03:12 AM
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.