------Query Database -------

azharuddinm

A Score Level 2

over 7 years ago

I am getting following error : SQL query. SQL Message : Missing IN or OUT parameter at index:: 1

query:
select cname from schemaname.tablename where id =acid

Discussion posts and replies are publicly visible

Parents

0 aloks0189
Certified Lead Developer
over 7 years ago

@azharuddinm i think it's better to Debug the process to understand the actual cause whether there is something wrong with query or with Data i.e. id . Try passing static value for id rather than ac! or pv! and try executing the Process, if this works, means there is something wrong with the data as @Ammireddy Srinivasareddy said earlier. If still the same then i recommend try executing the same query Manually in DB

hope this will help you to debug and resolve the issue
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aloks0189
Certified Lead Developer
over 7 years ago

@azharuddinm i think it's better to Debug the process to understand the actual cause whether there is something wrong with query or with Data i.e. id . Try passing static value for id rather than ac! or pv! and try executing the Process, if this works, means there is something wrong with the data as @Ammireddy Srinivasareddy said earlier. If still the same then i recommend try executing the same query Manually in DB

hope this will help you to debug and resolve the issue
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data