template q notations

[pocelka]

I have a template script which contains q notation commands i.e.

sys.dbms_output.put_line('select output from table(dbms_workload_repository.ash_report_html(l_dbid => ' || v_dbid ||
                           ',l_inst_num => ' || v_instance || q'[,l_btime => to_date(']' || to_char(v_start,'dd.mm.yyyy hh24:mi:ss') ||
                           q'[','dd.mm.yyyy hh24:mi:ss'),l_etime => to_date(']' ||
                           to_char(v_end,'dd.mm.yyyy hh24:mi:ss') || q'[','dd.mm.yyyy hh24:mi:ss')));]');

When I try to use script from the template, template window pop-ups asking for "bind" variable values.

Is there a way how to tell template script that if Oracle's q notation is used it should ignore "[]"?

I'm using version 10.0.5.1710

 

[Theod]

Hi,

try [[ instead of [. It works for PLD Ver. 11

 

[Philippe Malera]

You can use another delimiter.http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#i42617

 

[pocelka]

You can use another delimiter.http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#i42617

Don't know why I did not think about it. I guess I'm so used to [] that I forgot that I can use also other delimiters.

Thank you...