OraFAQ Forum: SQL & PL/SQL » ORA-01722: invalid number ORA-02063: preceding line from

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01722: invalid number ORA-02063: preceding line from

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01722: invalid number ORA-02063: preceding line from [message #658465]

Thu, 15 December 2016 02:30

mist598
Messages: 1195
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!

Report message to a moderator

Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658466 is a reply to message #658465]

Thu, 15 December 2016 02:33

Roachcoach
Messages: 1576
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

Report message to a moderator

Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658467 is a reply to message #658465]

Thu, 15 December 2016 02:54

John Watson
Messages: 8928
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>

Report message to a moderator

Re: ORA-01722: invalid number ORA-02063: preceding line from [message #658469 is a reply to message #658465]

Thu, 15 December 2016 03:07

Michel Cadot
Messages: 68637
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 14:37:06 CDT 2024