Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implicit Conversion

Orcl ApexMay 29 2017 — edited May 29 2017

HI All,

Oracle is not converting VARCHAR2 Column to Number, please suggest why implicit conversion is not happening.

[Error] Execution (9: 8): ORA-01722: invalid number

SELECT

       *

FROM

       fnd_concurrent_requests

WHERE

       argument2 = 1075;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2017
Added on May 29 2017
12 comments
1,382 views