This content has been marked as final. Show 2 replies
For the case of worksheet script, the special characters work fine for me in 3.2.20.09.87. What version are you on?
When running the query from the Reports view, here are a couple of hints
1. In the report's SQL Query definition, use Style: Script, not Table
2. Edit your SQL Query to use bind variables, not substitution variables, like so...
3. Finally, define them in the Binds section.
select ' Action:' || :V_PATCH || ' ' || :V_ACTION || chr(10) || 'Database: '|| instance_name || chr(10) || ' Date: '||to_char(sysdate,'DD-MON-YYYY HH24:MI') || chr(10) from v$instance
Hope this helps,