dakujem, pouzili sme vas trigger.
2009/10/23 Richard Holly <[email protected]>: > Ak mate pochybnosti o tom ci je connectionInitSql spustane, > tak mozete vyuzit oracle after logon trigger. V tomto pripade uz nie je > nutne definovat connectionInitSql. > V nasledujucom kode si zmente usera VAS_USER a spustte to ako cele sys. > > CREATE OR REPLACE TRIGGER set_sk_collation AFTER logon ON DATABASE > DECLARE username VARCHAR2(30); > cmmd VARCHAR2(64); > BEGIN > cmmd := 'ALTER SESSION SET NLS_SORT=XSLOVAK_CI'; > username := sys_context('USERENV', 'SESSION_USER'); > IF(username LIKE 'VAS_USER') THEN > EXECUTE IMMEDIATE cmmd; > END IF; > EXCEPTION > WHEN others THEN > NULL; > END; > / > > > > > Ivan Polak wrote / napísal(a): > > Zdravim konferenciu, > > mam takyto problem pri ziskavani dat z Oracle DB select ... order by > name, ale vracia mi a...z a az potom á, atd, teda diakriticke znaky > nie su vclenene do abecedy ale su na konci listu. > > napr. > > A > B > C > .. > Z > Á > Č > Š > > pripojenie do DB mam definovane nasledovne" > > < > Resource > name="jdbc/incidentDataSource" > auth="Container" > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" > url="jdbc:oracle:thin:@10.1.0.111:1521:XE" > username="....." > password="...." > maxActive="100" > maxIdle="30" > maxWait="10000" > connectionInitSql="SQL alter session set NLS_SORT=XSLOVAK_CI" > /> > > ale connectionInitSql="SQL alter session set NLS_SORT=XSLOVAK_CI" zda > ze nefunguje. > > kde by som mal spravit zmenu aby to fungovalo? > > dakujem > > Ivan > >
