Question
Virtusa Corporation
US
Last activity: 12 Mar 2018 9:37 EDT
Obj-Browse SQL query: Error sqlcode=-302 sqlstate=22001
Hi,
I have used obj-browse with criteria col A = Param value to fetch results from a table. Data type of col A is CHAR (18)
At run time in tracer i see this error sqlcode=-302 sqlstate=22001. I checked the Param value passed is more than 18 characters and this value doesnot exist in table. When i execute same SQL with same Param value in DB visualizer i get 0 results which is expected.
Can anyone explain why at run time this error is observed sqlcode=-302 sqlstate=22001.
Thanks & Regards,
Praveen.