Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 vamsi Darivemula (vamsiD30) Pega Developer
Cognizant
IN
vamsiD30 Member since 2016 1 post
Posted: May 18, 2018
Last activity: May 21, 2018
Posted: 18 May 2018 8:54 EDT
Last activity: 21 May 2018 13:33 EDT
Closed

There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

when we are trying to insert more data than (4000) into column varchar(4000) and it doesn't throws the below error. it truncates the data and it saves in to the column. Usually it need to throw below Error why it doesn't throws the error??

com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1461 SQLState: 72000 Message: ORA-01461: can bind a LONG value only for insert into a LONG column

To see attachments, please log in.
Data Integration

Posted: 6 years ago
Posted: 21 May 2018 13:33 EDT
Anil Vanaparthi (vanaa)
PEGA
Senior Manager, Services Engineering, Case Management
Pegasystems Inc.
IN
It doesn't throw error for data more than column length, it truncates and the total value is stored in blob. If you use report definition you will get exposed data i.e truncated data, whereas when you use obj-open you get the complete value of the property. Thanks.
To see attachments, please log in.

Related content:

Question Solved

ORA-01461: can bind a LONG value only for insert into a LONG column

Question

ORA-01461: can bind a LONG value only for insert into a LONG column.

Question

Getting the error ORA-01461: can bind a LONG value only for insert into a LONG column

Question

Data base: ORA-01461: can bind a LONG value only for insert into a LONG column

Question Solved

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Question Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question

There was a problem getting a list: code: 0 SQLState: 42703 Message: ERROR: column PC0.buddyname does not exist Position: 203

Question

Pega 73 Upgrade Error - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PXSAVEDATETIME": invalid identifier

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

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