...

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



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

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

A1ien51
11-06-2003, 10:54 PM
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.....

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

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum