Oracle OWA_CX
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 OWA_SEC OWA_UTIL
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_SEC
OWA_TEXT
OWA_UTIL
What's New In 18c
What's New In 19c

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