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 OraERP.com 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
#1
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:
10.2.0.5.0
to
11.2.0.3.0
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 ...........
Hassan
Reply
Thanks given by:
#2
Here you go ..........
http://www.gokhanatil.com/2009/11/implic...01722.html
it may help you out to fix this issue
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  oracle database 12c installation error Ahmad Mujeeb 0 723 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,814 12-11-2014, 04:03 PM
Last Post: Hassan Habib
  How to Troubleshoot ORA-600 Ali Rizwan 1 580 12-11-2014, 03:45 PM
Last Post: Hassan Habib
  Oracle error messages Pryia Rai 0 991 08-28-2014, 03:45 AM
Last Post: Pryia Rai
  ORA-04052: error occurred when looking up remote object Sara Khan 1 2,992 08-27-2014, 03:59 PM
Last Post: Kashif Manzoor
  ORA-00439: feature not enabled: Managed Standby Richard 1 3,011 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!