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, Simple and Absolutely Free.

Thread Rating:
  • 9 Vote(s) - 1.67 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 551 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,297 12-11-2014, 04:03 PM
Last Post: Hassan Habib
  Oracle error messages Pryia Rai 0 771 08-28-2014, 03:45 AM
Last Post: Pryia Rai
  ORA-04052: error occurred when looking up remote object Sara Khan 1 2,235 08-27-2014, 03:59 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!