when following query error message: ora-29913: error in executing odciexttablefetch callout ora-01722: invalid number
the query
select l.languagename language mpi_provider.mpiprovider m, mpi_provider.provlanguage l m.providerid = l.providerattestid , m.npi = 1548204944 i thought maybe high of number, when use both/either m.npi = 1548204943 or m.npi = 1548204945 query works fine (though there no records found). if add digit, m.npi = 15482049449, works fine if cut off digit.
i can't figure out going on. ideas? npi defined number(10) , can null
