Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: invalid number

s_dot1985Nov 8 2010 — edited Nov 9 2010
All,

I'm running a very simple query in Oracle SQL Developer:

select * from schema.table

And i get an ORA-01722: invalid number error!

Also i cant use the browser to access the data in the table.


When i run the query in TOAD, no problem.

Something is going wrong in Oracle SQL Developer, anybody know what it could be?

Also when i opened it this morning the tips box came on at start up randomly (i turned off the tips box off over a year ago when i first installed it).


Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2010
Added on Nov 8 2010
#sql-developer
3 comments
311 views