Skip to main content
Contact a Moderator

Question

2
Replies
616
Views
 Praveen Kumar Gyarampalli (PraveenG15)
Virtusa Corporation

Virtusa Corporation
US
PraveenG15 Member since 2014 7 posts
Virtusa Corporation
Posted: March 10, 2018
Last activity: March 12, 2018
Posted: 10 Mar 2018 10:49 EST
Last activity: 12 Mar 2018 9:37 EDT
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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 10 Mar 2018 15:09 EST
Praveen Kumar Gyarampalli (PraveenG15)
Virtusa Corporation

Virtusa Corporation
US

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

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice