Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 14 Vote(s) - 2.14 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ORA-01722: invalid number - Error during implicit conversion
trying to figure out oracle error for few SELECT queries in 11g which were working pretty well in 10g environment of client

our Oracle Version:
We are storing numeric values under CHAR or VARCHAR2 column in few tables. This is known design issue & it can't be changed for now. Require any help ...........
Thanks given by:
Here you go ..........
it may help you out to fix this issue
Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  oracle database 12c installation error Ahmad Mujeeb 0 737 12-12-2014, 01:24 AM
Last Post: Ahmad Mujeeb
  ORA-00600: internal error code, arguments: [17182] - adding standby database to broke Pryia Rai 1 1,870 12-11-2014, 04:03 PM
Last Post: Hassan Habib
  How to Troubleshoot ORA-600 Ali Rizwan 1 594 12-11-2014, 03:45 PM
Last Post: Hassan Habib
  Oracle error messages Pryia Rai 0 1,006 08-28-2014, 03:45 AM
Last Post: Pryia Rai
  ORA-04052: error occurred when looking up remote object Sara Khan 1 3,050 08-27-2014, 03:59 PM
Last Post: Kashif Manzoor
  ORA-00439: feature not enabled: Managed Standby Richard 1 3,037 02-17-2013, 02:46 PM
Last Post: Kashif Manzoor

Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!