Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

SQL##f - SqlState: S1000, ErrorCode 1456 ORA-01456 may not perform insert/delete/update operation inside a READ ONLY transaction

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht

SQL##f - SqlState: S1000, ErrorCode 1456 ORA-01456 may not perform insert/delete/update operation inside a READ ONLY transaction

Last Update:

May 25, 2021 9:52:11 AM

Updated By:

Sonja_Bauernfeind

Created date:

May 14, 2019 4:25:44 AM

An ORACLE ODBC DSN connection returns:

Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1456, ErrorMsg: [Oracle][ODBC][Ora]ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
 

Utilize an ORACLE OLE DB connection instead.

 

Environment:

QlikView  
Qlik Sense Enterprise on Windows  

Labels (2)