SQL Language (MOSC)

MOSC Banner

ORA-01722: invalid number resulting from sql statement

edited Jul 13, 2010 5:46PM in SQL Language (MOSC) 5 commentsAnswered
 Hello, we are receiving an ORA-01722 Invalid Number message from the following select statement:

-------------------

select sr.id, sr.formid, sr.userid, sr.sid, sr.status, sr.startdate, sr.subm
itdate
,so.outcome_code, so.outcome_description, so.outcome_user, so.outcome_date
,so.status process_status
from our_user.ourform_slr_results sr, our_user.ourprocess_outcomes so
where sr.sid = '995387210'
and sr.formid = 1
and sr.status in ('Completed','In-Progress')
and so.process_code (+) = 'SLR'
and so.process_source (+) = 'ourform_slr_results'
and so.process_id (+) = sr.id
and (so.outcome_date = (select max(outcome_date) from our_user.ourprocess_ou

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center