Question

2
Replies
534
Views
Close popover
Praveen Kumar Gyarampalli (PraveenG15)
Virtusa Corporation

Virtusa Corporation
US
View ProfileSend Message
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
Close popover
Praveen Kumar Gyarampalli (PraveenG15)
Virtusa Corporation

Virtusa Corporation
US
View ProfileSend Message

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 Share via LinkedIn Copying...
Copied!