Friday, December 15, 2006
Valid NLS characterset
When you transform from BLOB to CLOB you must set characters set. The list of all charactersets you can see with system privileges.
select * from v$nls_valid_values
where parameter = 'CHARACTERSET'
order by 2
select * from v$nls_valid_values
where parameter = 'CHARACTERSET'
order by 2
Wednesday, December 06, 2006
Setting name for file to download
Sample is here.
owa_util.mime_header('plain/text', FALSE, 'UTF-8');
htp.p('Content-Length: ' dbms_lob.getlength(v_lob_variable));
htp.p('Content-Disposition: attachment; filename="file_name.xml"');
owa_util.http_header_close;
Friday, December 01, 2006
OracleXE setting character set
As SYS user you must do the following steps:
SQLPLUS /NOLOG
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE EE8MSWIN1250;
SQL> SHUTDOWN;
SQL> STARTUP;
SQL> QUIT;
Autor: v. monomakh, Krasnodar, Russia (from OTN)
On clients you must set NLS_LANG=SLOVENIAN_SLOVENIA.EE8MSWIN1250
