DevOps, CI/CD and Automation

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!

URGENT: comparing Oracle data and AS400 data

390813Sep 9 2003 — edited Sep 9 2003

hi all,
our reports version is 6.0.8.0.3. for our reports some times we use our AS400 tables directly.
for one of our reports purpose we need to pass user parameters for customer number and customer name and depending on the value entered data should be generated. if nothing is entered then it should pick all the values.

i have written the following query
a.custname like nvl(:customername,'%')
and this custname field is from AS400 table.
with out these parameters report worked fine. but after created user parameters and written sql code inside query then while running report it is giving an error called
"Error while connecting to a non oracle system through oracle system. In valid token value ......" etc.

how to resolve this problem.
we created a view and in the view definition we used AS400 tables along with oracle tables.

any help is appreciated.

tnks
nivas.