Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01722: invalid number ORA-02063: preceding line from
ORA-01722: invalid number ORA-02063: preceding line from [message #658465] Thu, 15 December 2016 02:30 Go to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Hi All,

I am querying below simple statement

select * from xxc_audit.xxc_number@apps_to_flexprod
where SERIAL_NUMBER='ABG108'

ORA-01722: invalid number
ORA-02063: preceding line from APPS_TO_FLEXPROD

can u please help me why it is showing the above error?

Thank You!

Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658466 is a reply to message #658465] Thu, 15 December 2016 02:33 Go to previous messageGo to next message
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
01722, 00000, "invalid number"
// *Cause: The specified number was invalid.
// *Action: Specify a valid number.

Use a valid number
Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658467 is a reply to message #658465] Thu, 15 December 2016 02:54 Go to previous messageGo to next message
John Watson
Messages: 7699
Registered: January 2010
Location: Global Village
Senior Member
It looks as though you are relying on implicit type casting to compare a string literal with a numeric column. Not a reliable solution:
orclz>
orclz> select * from scott.emp where empno='1234';

no rows selected

orclz> select * from scott.emp where empno='A1234';
select * from scott.emp where empno='A1234'
                                    *
ERROR at line 1:
ORA-01722: invalid number


orclz>
Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658469 is a reply to message #658465] Thu, 15 December 2016 03:07 Go to previous message
Michel Cadot
Messages: 66049
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You still did not feedback in your previous topics.
You still did not post your Oracle version.
You still did not format your post.
You still did not follow the forum rules.

Previous Topic: Concatenating an array output into one single string
Next Topic: Hierarchy Query Help
Goto Forum:
  


Current Time: Wed Dec 12 13:06:25 CST 2018