Oracle OWA_CX
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose EBCDIC character set support constant declarations
AUTHID DEFINER
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_CACHE OWA_UTIL
OWA OWA_SEC  
Documented No
First Available 8.1.7
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owachars.sql

Related Topics
Built-in Functions
Built-in Packages
OWA
OWA_COOKIE
OWA_CUSTOM
OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved