Dynamic SQL Queries with a ROUTINE (CODE) database mounted in read-only mode: ERROR #5002: ObjectScript error: <UNDEFINED>ShowPlan+6^%apiSQL *sqlOrig

Question

Question

Sylvain Guilbaud · Mar 7

#SQL #InterSystems IRIS #InterSystems IRIS for Health

Using IRIS 2024.1.2 when I mount the routine database as read-only I get an error when executing dynamic SQL queries.

What globals need to be mapped in a read-write database in order to allow execution plans to be written?

Go to the original post written by @Sylvain Guilbaud

Discussion (1)1

Log in or sign up to continue

score 0 · Answer 1 · 2025-03-10T06:42:15-04:00

Hi,

I just tried putting a database as read-only and then executing a dynamic SQL query which worked for me.
Are you able to provide some more information? For example, the SQL query, any <PROTECT> in the audit log? etc

Thank you