[jboss-user] [JCA/JBoss] - Re: DataSource new-connection-sql

2008-06-11 Thread rukus
:) anyway i found how to do that: look at this code: | Begin | execute immediate('ALTER SESSION SET NLS_DATE_FORMAT=''dd/mm/ hh24:mi:ss'''); | execute immediate('ALTER SESSION SET NLS_DATE_LANGUAGE=''Ukrainian'''); | end; View the original post :

[jboss-user] [JCA/JBoss] - Re: DataSource new-connection-sql

2008-06-10 Thread vickyk
rukus wrote : Can i somehow specify more than one statement in new-connection-sql? | for example | ALTER SESSION SET NLS_DATE_FORMAT='dd/mm/ hh24:mi:ss' | ALTER SESSION SET NLS_DATE_LANGUAGE='Ukrainian' No it will not work . View the original post :