AnsweredAssumed Answered

Dynamic sql in gel script

Question asked by rajeev.sharma.2 on Mar 3, 2016
Latest reply on Mar 7, 2016 by rajeev.sharma.2



I am looking forward to replicate  (syntax we use in oracle package)

execute immediate 'some sql query string'

into equivalent syntax in gel script.


For e.g.: someting like (ofcourse this is not right and not working but intent is same)

<sql:query dataSource="${nikuDS}" escapeText="0" var="test_data2">


    execute immediate 'select  4321 num from dual

    union all'' ||







and param_val will be a variable with value as "select 1234 num from dual "


Any suggestions please.


Thanks in advance