I have a query that uses JSON_OBJECT functions to build a json document. It uses the syntax with a colon. The query works when I execute it in sql worksheet in sqldev, but when I include it in a cursor definition in a package the package does not compile, but thinks the colon(s) ask for a bind variable.
How can we avoid this?