This content has been marked as final.
Show 2 replies
-
1. Re: DataSource & new-connection-sql
vickyk Jun 10, 2008 1:40 PM (in response to rukus)"rukus" wrote:
Can i somehow specify more than one statement in new-connection-sql?
for example
ALTER SESSION SET NLS_DATE_FORMAT='dd/mm/yyyy hh24:mi:ss'
ALTER SESSION SET NLS_DATE_LANGUAGE='Ukrainian'
No it will not work . -
2. Re: DataSource & new-connection-sql
rukus Jun 11, 2008 3:04 AM (in response to rukus):)
anyway i found how to do that: look at this code:Begin execute immediate('ALTER SESSION SET NLS_DATE_FORMAT=''dd/mm/yyyy hh24:mi:ss'''); execute immediate('ALTER SESSION SET NLS_DATE_LANGUAGE=''Ukrainian'''); end;