Re: how to concate a string in insert statement using ibatis?

[Jason King]

In Oracle || is the string concatenation operator

'abc'||#orderId# should work.
suprememenu wrote:

suprememenu wrote:

hi all,
   i would like to know how can i contact a string in insert statemnet
using ibatis?

insert into knet (TRACK_ID, STORE_ID,

       order_id
       DATE

) values(

         #trackId#,
                #storeId#,
               'abc'+#orderId#,
                SYSDATE)


i mean for the column orderId i need to add a static string . when i tried
the above i am getting error ... Cause: java.sql.SQLException: ORA-01722:
invalid number