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

 Pranavi DONTHIREDDY (pranavid)
COFORGE DPA AUSTRALIA PTY LTD

COFORGE DPA AUSTRALIA PTY LTD
AU
pranavid Member since 2015 8 posts
COFORGE DPA AUSTRALIA PTY LTD
Posted: Apr 23, 2018
Last activity: Apr 24, 2018
Posted: 23 Apr 2018 7:08 EDT
Last activity: 24 Apr 2018 2:53 EDT
Closed

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

Hi All,

When running the BIX to Database Format. we are getting the error as

ORA-01461: can bind a LONG value only for insert into a LONG column because of which it is skipping the insertion of records into DB.

we are running the Extract manually in the designer studio.

only for some records we are getting the error. we need to know when exactly we will get the error.how to resolve the issue.

BIX version :7.2.1 and pega version 7.2.1

Thanks,

Pranavi.

To see attachments, please log in.
Data Integration
Reporting

Posted: 6 years ago
Posted: 24 Apr 2018 2:53 EDT
Sandeep Kumar Gunanchipalli (sandeepg)
OCBC Bank
Sandeep Gunanchipalli
OCBC Bank
SG

Hi,

Please look into below posts related to this issue

https://collaborate.pega.com/question/ora-01461-can-bind-long-value-only-insert-long-column

https://docs-previous.pega.com/database-management/troubleshooting-ora-01460-and-ora-01461-errors-database-operations-oracle-10203

https://collaborate.pega.com/question/ora-01461-can-bind-long-value-only-insert-long-column

Hope this helps.

To see attachments, please log in.

Related content:

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