error in query block execution on different machine [message #347540] |
Fri, 12 September 2008 01:07 |
mbhavin
Messages: 32 Registered: May 2008 Location: INDIA
|
Member |
|
|
i am having query as follow
select last_ar_post from fpara
last_ar_post=>date(type date,current final account receipt date)
i am assigning this value to the place_holder that i am using at different places
:cp_last_ar_post=>date(type date)
value of :cp_last_ar_post i am using to calculate the due_days as follow
select :cp_last_ar_post-:doc_date from account_receivable
it's working fine on machine on which i developed this report
but it give error on another machine
error 422 no pl/sql translation for the bindtype given for this bind variable
both of my machine have same os(windows xp, and same cpu architecture)
|
|
|