2 Replies Latest reply on Jun 11, 2008 3:04 AM by rukus

    DataSource & new-connection-sql

    rukus

      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'

        • 1. Re: DataSource & new-connection-sql
          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/yyyy hh24:mi:ss'
          ALTER SESSION SET NLS_DATE_LANGUAGE='Ukrainian'


          No it will not work .



          • 2. Re: DataSource & new-connection-sql
            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;