Question

2
Replies
463
Views
PraveenG15 Member since 2014 7 posts
Virtusa Corporation
Posted: March 10, 2018
Last activity: March 12, 2018
Closed

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.

System Administration
Close popover
Moderation Team has archived post
Posted: 2 years ago

Thanks, in my case the character value is more than the column length defined thats why this SQL error code is triggered.
Share this page LinkedIn
Copied!