Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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)
Contributors
Version history
Last update:
‎2021-05-25 09:52 AM
Updated by: