SAP Knowledge Base Article - Preview

1197846 - Error: 'Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-01456: May not perform insert/delete/update operation inside a READ ONLY transaction' in Crystal Reports

Symptom

  • When refreshing a report, it generates an error.
  • In Crystal Reports, when attempting to refresh a report based off an Oracle Stored Procedure that performs either an Insert or Delete  while using an ODBC connection, it displays the error:

    "Database Connector Error: 'HY000:[Oracle][ODBC][Ora]ORA-01456: May not perform insert/delete/update operation inside a READ ONLY transaction"


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, READ ONLY WRITE ODBC CRYSTAL REPORTS INSERT DELETE UPDATE TRANSACTION ACCESSMODE , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.