Dynamic SQL Queries with a ROUTINE (CODE) database mounted in read-only mode: ERROR #5002: ObjectScript error: <UNDEFINED>ShowPlan+6^%apiSQL *sqlOrig
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?
Discussion (0)0
Comments
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