CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle OWA_CX
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/owachars.sql
First Availability 8.1.7
Constants SELECT value
FROM v$nls_parameters
WHERE parameter = 'NLS_CHARACTERSET';

IF value LIKE '%EBCDIC%' THEN

CREATE OR REPLACE PACKAGE owa_cx IS
 NL_CHAR CONSTANT varchar2(1) := chr(21);
 SP_CHAR CONSTANT varchar2(1) := chr(64);
 BS_CHAR CONSTANT varchar2(1) := chr(22);
 HT_CHAR CONSTANT varchar2(1) := chr(5);
 XP_CHAR CONSTANT varchar2(1) := chr(90);
END owa_cx;
/

ELSE

CREATE OR REPLACE PACKAGE owa_cx IS 
 NL_CHAR CONSTANT varchar2(1) := chr(10);
 SP_CHAR CONSTANT varchar2(1) := chr(32);
 BS_CHAR CONSTANT varchar2(1) := chr(8);
 HT_CHAR CONSTANT varchar2(1) := chr(9);
 XP_CHAR CONSTANT varchar2(1) := chr(33);
END owa_cx;
/
Dependencies
HTP OWA OWA_CACHE OWA_UTIL
 
Related Topics
OWA_UTIL
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [174 users online]    © 2010 psoug.org