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!

Getting an error ORA-01722: invalid number in select clause

Mark Lawrence HernandezOct 28 2019 — edited Oct 29 2019

Hi,

I have a query then I getting this error "Invalid number". Please see my query below,

select imt.transaction_reference,

imt.transaction_id, cit.txn_source_ref_doc_number

from

inv_material_txns imt

left join cst_inv_transactions cit on imt.transaction_id = cit.txn_source_ref_doc_number

Then I got the error when I put the imt.transaction_reference. When I check the datatype of the column in Oracle, it was "Number".

Can someone help me on this?

Thanks,

Lawrence

Added on Oct 28 2019

4 comments

1,953 views