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

Hi,

 

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">

    <![CDATA[

    execute immediate 'select  4321 num from dual

    union all'' ||

    ${param_val}

  ]]>

  </sql:query>

  </core:catch>

 

 

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

 

Any suggestions please.

 

Thanks in advance

 

 

Regards

Rajeev

Outcomes