1 Reply Latest reply: Jul 9, 2013 8:50 PM by oracleistheway RSS

    Is it possible to use AND condition in oraext:query-database()


      Hi everyone.


      I believe the answer to my question is no since it seems straight forward if it were possible, but I was unsuccessful in doing so.


      I tried:

      oraext:query-database(concat('select create_ts from menu where order_num=', substring($ticket,10,15), ' and where table_num=', substring($ticket,20,5)),false(),false(),'jdbc:oracle:thin:sysdba/oracle1@localhost:21/SOAINFRA')


      Can anyone else confirm that using AND condition cannot be used in oraext:query-database()?