SAP Knowledge Base Article - Preview

3047677 - Stored procedure failed with "Non-read-only operation in read-only DynamicSQL statement"

Symptom

When you try to execute a stored procedure, it failed with error below.

error message.png

Could not execute 'call "Charles::GRANT_ON_SCHEMA_WITH_GRANT_OPTION"('I3110402', '_SYS_BIC', 'EXECUTE')' in 268 ms 979 µs . 
SAP DBTech JDBC: [1295]: not permitted statement: "SYSTEM"."Charles::GRANT_ON_SCHEMA_WITH_GRANT_OPTION": line 6 col 1 (at pos 212): Non-read-only operation in read-only DynamicSQL statement

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

SAP HANA Platform Edition 2.0 or higher

Product

SAP HANA, platform edition 2.0

Keywords

HANA, stored procedure, SAP DBTech JDBC, not permitted statement, Non-read-only operation in read-only DynamicSQL statement, read only, read-only , KBA , HAN-DB-SCR , SAP HANA SQL Script , How To

About this page

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

Search for additional results

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