-
In my Integeration unit one of the view like
where rt.id = tsa.plus_id
and t.party_id = p.party_id
and t.party_id = st.party_id(+)
/
is working fine .
when moved to production it is not working.
but when sufficed like to_char it works fine
where rt.id =to_char( tsa.plus_id)
and t.party_id = p.party_id
and t.party_id = st.party_id(+)
/
all the base tables have the same datatypes .
any idea why ???
Radhakrishnan.M
-
Data and Oracle version are also the same?
Maybe in production values of tsa.plus_id contain non-numeric characters.
-
VERSION is one and the same in both.
both have numeric values only.
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|