Oracle Developer Getting Started Release 6.0 A58767-02

Oracle Home Contents Index

A
Reports Express Integration

This section contains information that will enable you to integrate Oracle Express with Report Builder. It includes the following sections:

• System Configuration
• Buffer Size for Express Data
• Character Set for Express Data
• Number Ranges for Express Data

A.1 System Configuration

Creating reports that use Express data requires the following three components:

• A client, with Reports 6.0, the Reports Express Support component and the Oracle Express Connection Editor installed.
• A gateway server, with Oracle8 and the necessary PL/SQL packages installed.
• An Oracle Express 6.2 Server.

A.1.1 System Requirements

The following are the client system requirements for creating reports that use Express data:

• Windows 95, 98 or NT
• Oracle Reports Release 6.0 or later

The following are the gateway server system requirements for creating reports that use Express data:

• Windows NT
• Oracle8 Server for Windows NT with Objects Option Release 8.0.5 or later

The following are the Express server system requirements for creating reports that use Express data:

• Oracle Express Server Release 6.2 or later

For individual product requirements, refer to the Express, Oracle8, or Reports installation information for your platform.

A.1.2 Client Configuration

There are two tasks involved in client configuration. Note this assumes you have already installed Oracle Reports 6.0:

1. Install Reports Express Support and the Oracle Express Connection Editor.
2. Create an Express Connection Description.

Installing Reports Express Support and the Oracle Express Connection Editor

1. Insert the CD that contains the Reports product. If your CD-ROM drive supports the autorun feature, the Oracle Installer will start automatically. Otherwise, perform the following steps:
   1. Shut down any active Windows applications.
   2. Open the Run dialog box from the Start menu.
   3. In the Run dialog, type the following (where D: is your CD-ROM drive letter):

      D:\SETUP.EXE

   4. Click OK to start the Oracle Installer.
2. When you reach the Installation Options dialog box, choose Custom Installation or Removal and click OK.
3. From the Available Products list, select Reports Express Support and Oracle Express Connection Editor from the list. Press the control key while clicking to make multiple selections.
4. Click Install.

Creating an Express Connection Description

1. Start the Oracle Express Connection Editor from the Oracle OLAP Client program group.
2. Click Set Path. Add an Express Connection path of %ORACLE_HOME%\olap\ecf620. Add any other directory paths where you will keep Express Connection description files. Separate each path you enter from the one following it with a semicolon. When finished, click OK.
3. Click Define. Enter a filename to save these connection settings in. No filename extension is necessary as the Connection Editor will append a .XCF extension by default. Enter a Description for this connection. Choose an Express Version of Express 6.x. Enter the host name or IP address for the machine running the Express Server you wish to connect in the Host Name field. Ask your Express Server administrator if you do not know the host name or IP address for your Express Server. Finally, select ncacn_ip_tcp as the Transport. When finished, click Save. You may be prompted to select a directory from the directories you entered in the Set Path step. Your new Express Server Connection description should be listed in the Express Connection Editor.
4. Click Close to exit the Express Connection Editor.

A.1.3 Gateway Server Configuration

There are four tasks involved in the gateway server configuration:

1. Install Oracle8 Server for Windows NT with Objects Option Release 8.0.5.
2. Install Express External Oracle8 Procedures.
3. Create required administrator schema objects on the Oracle8 server.
4. Prepare user accounts with Express Support schema objects.
5. Prepare Net8 configuration files.

Installing Oracle8 Server for Windows NT with Objects Option Release 8.0.5

See the Oracle8 installation guide for your platform.

Installing Express External Oracle8 Procedures 

1.Insert the CD that contains the Report Builder product. If your CD-ROM drive supports the autorun feature, the Oracle Installer will start automatically. Otherwise, perform the following steps:

a.Shut down any active Windows applications.
b.Open the Run dialog box from the Start menu.
c.In the Run dialog, type the following (where D: is your CD-ROM drive letter):

D:\SETUP.EXE

d.Click OK to start the Oracle Installer.

2.When you reach the Installation Options dialog box, choose Custom Installation or Removal and click OK.
3.From the Available Products list, click the plus sign to expand the Reports Express Support node and choose Express External Oracle8 Procedures from the list.
4.Click Install.

Creating required administrator schema objects on the Oracle8 server

Note: If the required administrator schema objects already exist, you can skip this task and go to Section A.1.3.4, "Preparing user accounts with Express Support schema objects".

1. Log into SQL*Plus as the SYSTEM user.
2. Run the SQL script that installs the administrator schema objects:

   SQL> @ %ORACLE_HOME%\olap\xrb60\xrb_admin.sql;

Note: The required administrator schema objects can be created in a database account other than SYSTEM. However, the account chosen as the Express support administrator must be granted the CREATE LIBRARY, CREATE PUBLIC SYNONYM, and CREATE SEQUENCE privileges in order for the required schema objects to be created successfully. Once this has been done, you may follow the instructions in the task above substituting the name of the new Express support administrator account for the SYSTEM account .

Preparing user accounts with Express Support schema objects

You must create Express Support schema objects for any schema that uses Express Support. Using existing Express Support schema objects from another schema is not supported.

Note: If you do not have a user account, you must create one before proceeding with this step.

1. Log into SQL*Plus as the SYSTEM user and grant the user account CREATE TYPE and CREATE PROCEDURE privileges to the user. For example, if the user was named expuser, the following commands would set up the necessary privileges:

    SQL> grant create type, create procedure to expuser;
   

2. Log into SQL*Plus as the user (e.g., expuser) and run the SQL script that installs the Express Support schema objects:

 SQL> @ %ORACLE_HOME%\olap\xrb60\xrb_user.sql;

Preparing Net8 configuration files

1. Your TNSNAMES.ORA file (located in %ORACLE_HOME%\net80\admin) must contain the following entry:

extproc_connection_data.world =
  (DESCRIPTION =
    (ADDRESS =
        (PROTOCOL = IPC)
        (KEY = EXTPROC0)
    )
    (CONNECT_DATA = (SID = extproc)
    )
  )

Note: The suffix of the TNSNAMES.ORA entry, e.g. world, must match the names.default_domain entry in your SQLNET.ORA file (located in %ORACLE_HOME%\net80\admin).

2. Your LISTENER.ORA file (located in %ORACLE_HOME%\net80\admin) must contain the following entry in the ADDRESS_LIST section:

(ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
)

Note: In order for changes to the LISTENER.ORA file to be implemented, the Net8 Listener on the gateway server must be stopped and started or reloaded. Information on the Net8 configuration files and the Net8 Listener can be found in the Oracle Net8 Administrator's Guide.

Note: Even when the client and the gateway server are installed and run on the same machine, the Net8 Listener must be started in order to create reports that use Express data.

A.1.4 Reports Server Configuration

If deploying a report built against Express with the Oracle Reports Server (for example, for running over the web), the following runtime parameter is required in addition to the userid, server, desformat, etc. parameters that would also be specified:

express_server="server=ncacn_ip_tcp:my_express_server/sl=1/st=1/ct=0/sv=1/"

where my_express_server is the hostname of the server running Oracle Express Server.

A.2 Buffer Size for Express Data

When a user creates a report that contains Express data, that data must be fetched from Express and stored in a memory buffer before it is displayed. The default buffer size is generally sufficient for most circumstances, and you can probably accept the default size of the buffer and not worry about making any changes.

You can specify a larger or smaller size for the buffer than the default value specifies. For example, if users generate many small reports, you might want to reduce the buffer size. If users generate very large reports, you might need to increase the size.

You change the default size of the buffer in the xrb.ini file. Keep in mind that this file resides on the Oracle8 server and is shared by many users. The server allocates the same size buffer to all users of that server for the duration of the time that data is being fetched from Express. Use care when specifying the size to fit the needs of the many users who are concurrently accessing Express data. The size should be large enough to allow users to fetch the data for their reports while ensuring that the server has sufficient memory.

A.2.1 Buffer sizes

The following list describes some of the buffer sizes:

• 64kb: This is the minimum buffer size that is allowed. Even if you specify a smaller size, the buffer will have a size of 64kb.
• 2MB: This is the default buffer size. If you do not specify a different size, the buffer will have a size of 2MB.
• 50MB: This is the maximum buffer size that is allowed. Even if you specify a larger size, the buffer will have a size of 50MB. You must ensure that the Oracle8 server has a very large amount of memory before specifying such a large buffer size.

A.2.2 Specifying the buffer size

To specify the buffer size, you must create or modify the xrb.ini file so that the setting can take effect. The following procedure explains how to make the specification in the file.

1. On the computer on which Oracle8 is running, look in the %ORACLE_HOME%/BIN directory for a file called xrb.ini. If the file exists, proceed to Step 3. Otherwise, proceed to Step 2.
2. With a text editor, create a file called xrb.ini in the %ORACLE_HOME%/BIN directory.
3. In a text editor, scroll to the [Options] section of the file, or create this section label if it does not exist.
4. Edit the value of the FetchAlloc setting if it exists; otherwise, create the setting. Enter an integer value specifying the number of bytes, such as 100000 or 6000000.
5. Save your changes and close the file.

A.2.3 Example setting for a buffer size

The following example shows a sample setting of 4MB for the buffer size.

[Options]
FetchAlloc = 4000000

A.3 Character Set for Express Data

If you have changed the default single-byte character set in Express, you must create or modify a file for Oracle Reports so that Reports will handle data from the Express database appropriately. The file is called XRB.INI and you use it to specify information about the character set that the database is using. The following procedure explains how to make the specification in the file.

1. On the computer on which Oracle8 is running, look in the %ORACLE_HOME%/bin directory for a file called XRB.INI. If the file exists, proceed to Step 3. Otherwise, proceed to Step 2.
2. With a text editor, create a file called XRB.INI in the %ORACLE_HOME%/bin directory.
3. In a text editor, scroll to the [XPCharSet] section of the file, or create this section label if it does not exist.
4. Edit the value of the XPCharSet setting if it exists; otherwise, create the setting. Use the following format for the value of the setting:

language_territory.charset

where language, territory, and charset are values obtained from the following tables.

1. Save your changes and close the file.

The following example shows a sample setting for the character set:

[XPCharSet]
XPCharSet = AMERICAN_AMERICA.US8PC437

A.3.1 Languages

The following table lists the values to enter for language in the XPCharSet setting. If the value has multiple words, include a space between each word, as shown in the following example.

[XPCharSet]
XPCharSet = BRAZILIAN PORTUGUESE_BRAZIL.WE8PC850

Language
AMERICAN	ARABIC	BENGALI
BRAZILIAN PORTUGUESE	BULGARIAN	CANADIAN FRENCH
CATALAN	CROATIAN	CZECH
DANISH	DUTCH	EGYPTIAN
ENGLISH	ESTONIAN	FINNISH
FRENCH	GERMAN DIN	GERMAN
GREEK	HEBREW	HUNGARIAN
ICELANDIC	ITALIAN	JAPANESE
KOREAN	LATIN AMERICAN SPANISH	LATVIAN
LITHUANIAN	MALAY	MEXICAN SPANISH
NORWEGIAN	POLISH	PORTUGESE
ROMANIAN	RUSSIAN	SIMPLIFIED CHINESE
SLOVAK	SLOVENIAN	SPANISH
SWEDISH	THAI	TRADITIONAL CHINESE
TURKISH	UKRAINIAN	VIETNAMESE

A.3.2 Territories

The following table lists the values to enter for territory in the XPCharSet setting.

Territory
ALGERIA	AMERICA	AUSTRIA
BAHRAIN	BANGLADESH	BRAZIL
BULGARIA	CANADA	CATALONIA
CHINA	CIS	CROATIA
CZECH REPUBLIC	CZECHOSLOVAKIA	DENMARK
DJIBOUTI	EGYPT	ESTONIA
FINLAND	FRANCE	GERMANY
GREECE	HONG KONG	HUNGARY
ICELAND	IRAQ	ISRAEL
ITALY	JAPAN	JORDAN
KOREA	KUWAIT	LATVIA
LEBANON	LIBYA	LITHUANIA
MALAYSIA	MAURITANIA	MEXICO
MOROCCO	NORWAY	OMAN
POLAND	PORTUGAL	QATAR
ROMANIA	SAUDI ARABIA	SLOVAKIA
SLOVENIA	SOMALIA	SPAIN
SUDAN	SWEDEN	SWITZERLAND
SYRIA	TAIWAN	THAILAND
THE NETHERLANDS	TUNISIA	TURKEY
UKRAINE	UNITED ARAB EMIRATES	UNITED KINGDOM
VIETNAM	YEMEN

A.3.3 Storage Character Sets

The following table lists the values to enter for charset in the XPCharSet setting. The value is specified in the Name column.

ID	Name	Description
1	US7ASCII	ASCII 7-bit American
2	WE8DEC	DEC 8-bit West European
3	WE8HP	HP LaserJet 8-bit West European
4	US8PC437	IBM-PC Code Page 437 8-bit American
5	WE8EBCDIC37	EDCDIC Code Page 37 8-bit West European
6	WE8EBCDIC500	EDCDIC Code Page 500 8-bit West European
8	WE8EBCDIC285	EDCDIC Code Page 285 8-bit West European
10	WE8PC850	IBM-PC Code Page 850 8-bit West European
11	D7DEC	DEC VT100 7-bit German
12	F7DEC	DEC VT100 7-bit French
13	S7DEC	DEC VT100 7-bit Swedish
14	E7DEC	DEC VT100 7-bit Spanish
15	SF7ASCII	ASCII 7-bit Finnish
16	NDK7DEC	DEC VT100 7-bit Norwegian/Danish
17	I7DEC	DEC VT100 7-bit Italian
18	NL7DEC	DEC VT100 7-bit Dutch
19	CH7DEC	DEC VT100 7-bit Swiss (German/French)
20	YUG7ASCII	ASCII 7-bit Yugoslavian
21	SF7DEC	DEC VT100 7-bit Finnish
22	TR7DEC	DEC VT100 7-bit Turkish
23	IW7IS960	Israeli Standard 960 7-bit Latin/Hebrew
25	IN8ISCII	Multiple-Script Indian Standard 8-bit Latin/Indian Languages
31	WE8IS08859P1	ISO 8859-1 West European
32	EE8ISO8859P2	ISO 8859-2 East European
33	SE8ISO8859P3	ISO 8859-3 South European
34	NEE8ISO8859P4	ISO 8859-4 North and North-East European
35	CL8ISO8859P5	ISO 8859-5 Latin/Cyrillic
36	AR8ISO8859P6	ISO 8859-6 Latin/Arabic
37	EL8ISO8859P7	ISO 8859-7 Latin/Greek
38	IW8ISO8859P8	ISO 8859-8 Latin/Hebrew
39	WE8ISO8859P9	ISO 8859-9 West European & Turkish
40	NE8ISO8859P10	ISO 8859-10 North European
41	TH8TISASCII	Thai Industrial Standard 620-2533 - ASCII 8-bit
42	TH8TISEBCDIC	Thai Industrial Standard 620-2533 - EBCDIC 8-bit
43	BN8BSCII	Bangladesh National Code 8-bit BSCII
44	VN8VN3	VN3 8-bit Vietnamese
50	WE8NEXTSTEP	NeXTSTEP PostScript 8-bit West European
70	AR8EBCDICX	EBCDIC XBASIC Server 8-bit Latin/Arabic
81	EL8DEC	DEC 8-bit Latin/Greek
82	TR8DEC	DEC 8-bit Turkish
90	WE8EBCDIC37C	EBCDIC Code Page 37 8-bit Oracle/c
91	WE8EBCDIC500C	EBCDIC Code Page 500 8-bit Oracle/c
92	IW8EBCDIC424	EBCDIC Code Page 424 8-bit Latin/Hebrew
93	TR8EBCDIC1026	EBCDIC Code Page 1026 8-bit Turkish
94	WE8EBCDIC871	EBCDIC Code Page 871 8-bit Icelandic
95	WE8EBCDIC284	EBCDIC Code Page 284 8-bit Latin American/Spanish
110	EEC8EUROASCI	EEC Targon 35 ASCI West European/Greek
113	EEC8EUROPA3	EEC EUROPA3 8-bit West European/Greek
114	LA8PASSPORT	German Government Printer 8-bit All-European Latin
140	BG8PC437S	IBM PC Code Page 437 8-bit (Bulgarian Modification)
150	EE8PC852	IBM PC Code Page 852 8-bit East European
152	RU8PC866	IBM PC Code Page 866 8-bit Latin/Cyrillic
153	RU8BESTA	BESTA 8-bit Latin/Cyrillic
154	IW8PC1507	IBM PC Code Page 1507/862 8-bit Latin/Hebrew
155	RU8PC855	IBM PC Code Page 855 8-bit Latin/Cyrillic
156	TR8PC857	IBM PC Code Page 857 8-bit Turkish
158	CL8MACCYRILLIC	Mac Client 8-bit Latin/Cyrillic
159	CL8MACCYRILLICS	Mac Server 8-bit Latin/Cyrillic
160	WE8PC860	IBM PC Code Page 860 8-bit West European
161	IS8PC861	IBM PC Code Page 861 8-bit Icelandic
162	EE8MACCES	Mac Server 8-bit Central European
163	EE8MACCROATIANS	Mac Server 8-bit Croatian
164	TR8MACTURKISHS	Mac Server 8-bit Turkish
165	IS8MACICELANDICS	Mac Server 8-bit Icelandic
166	EL8MACGREEKS	Mac Server 8-bit Greek
167	IW8MACHEBREWS	Mac Server 8-bit Hebrew
170	EE8MSWIN1250	MS Windows Code Page 1250 8-bit East European
171	CL8MSWIN1251	MS Windows Code Page 1251 8-bit Latin/Cyrillic
172	ET8MSWIN923	MS Windows Code Page 923 8-bit Estonian
173	BG8MSWIN	MS Windows 8-bit Bulgarian Cyrillic
174	EL8MSWIN1253	MS Windows Code Page 1253 8-bit Latin/Greek
175	IW8MSWIN1255	MS Windows Code Page 1255 8-bit Latin/Hebrew
176	LT8MSWIN921	MS Windows Code Page 921 8-bit Lithuanian
177	TR8MSWIN1254	MS Windows Code Page 1254 8-bit Turkish
178	WE8MSWIN1252	MS Windows Code Page 1252 8-bit West European
179	BLT8MSWIN1257	MS Windows Code Page 1257 8-bit Baltic
180	D8EBCDIC273	EBCDIC Code Page 273/1 8-bit Austrian German
181	I8EBCDIC280	EBCDIC Code Page 280/1 8-bit Italian
182	DK8EBCDIC277	EBCDIC Code Page 277/1 8-bit Danish
183	S8EBCDIC278	EBCDIC Code Page 278/1 8-bit Swedish
184	EE8EBCDIC870	EBCDIC Code Page 870 8-bit East European
185	CL8EBCDIC1025	EBCDIC Code Page 1025 8-bit Cyrillic
186	F8EBCDIC297	EBCDIC Code Page 297 8-bit French
187	IW8EBCDIC1086	EBCDIC Code Page 1086 8-bit Hebrew
188	CL8EBCDIC1025X	EBCDIC Code Page 1025 (Modified) 8-bit Cyrillic
190	N8PC865	IBM-PC Code Page 865 8-bit Norwegian
191	BLT8CP921	Latvian Standard LVS8-92(1) Windows/Unix 8-bit Baltic
192	LV8PC1117	IBM-PC Code Page 1117 8-bit Latvian
193	LV8PC8LR	Latvian Version IBM-PC Code Page 866 8-bit Latin/Cyrillic
194	BLT8EBCDIC1112	EBCDIC Code Page 1112 8-bit Baltic Multilingual
195	LV8RST104090	IBM-PC Alternative Code Page 8-bit Latvian (Latin/Cyrillic)
196	CL8KOI8R	RELCOM Internet Standard 8-bit Latin/Cyrillic
197	BLT8PC775	IBM-PC code Page 775 8-bit Baltic
201	F7SIEMENS9780X	Siemens 97801/97808 7-bit French
202	E7SIEMENS9780X	Siemens 97801/97808 7-bit Spanish
203	S7SIEMENS9780X	Siemens 97801/97808 7-bit Swedish
204	DK7SIEMENS9780X	Siemens 97801/97808 7-bit Danish
205	N7SIEMENS9780X	Siemens 97801/97808 7-bit Norwegian
206	I7SIEMENS9780X	Siemens 97801/97808 7-bit Italian
207	D7SIEMENS9780X	Siemens 97801/97808 7-bit German
210	WE8GCOS7	Bull EBCDIC GCOS7 8-bit West European
211	EL8GCOS7	Bull EBCDIC GCOS7 8-bit Greek
221	US8BS2000	Siemens 9750-62 EBCDIC 8-bit American
222	D8BS2000	Siemens 9750-62 EBCDIC 8-bit German
223	F8BS2000	Siemens 9750-62 EBCDIC 8-bit French
224	E8BS2000	Siemens 9750-62 EBCDIC 8-bit Spanish
225	DK8BS2000	Siemens 9750-62 EBCDIC 8-bit Danish
231	WE8BS2000	Siemens EBCDIC.DF.04 8-bit West European
235	CL8BS2000	Siemens EBCDIC.EHC.LC 8-bit Cyrillic
239	WE8BS2000L5	Siemens EBCDIC.DF.04.L5 8-bit West European/Turkish
241	WE8DG	DG 8-bit West European
251	WE8NCR4970	NCR 4970 8-bit West European
261	WE8ROMAN8	HP Roman8 8-bit West European
262	EE8MACCE	Mac Client 8-bit Central European
263	EE8MACCROATIAN	Mac Client 8-bit Croatian
264	TR8MACTURKISH	Mac Client 8-bit Turkish
265	IS8MACICELANDIC	Mac Client 8-bit Icelandic
266	EL8MACGREEK	Mac Client 8-bit Greek
267	IW8MACHEBREW	Mac Client 8-bit Hebrew
277	US8ICL	ICL EBCDIC 8-bit American
278	WE8ICL	ICL EBCDIC 8-bit West European
279	WE8ISOICLUK	ICL special version ISO8859-1
351	WE8MACROMAN8	Mac Client 8-bit Extended Roman8 West European
352	WE8MACROMAN8S	Mac Server 8-bit Extended Roman8 West European
353	TH8MACTHAI	Mac Client 8-bit Latin/Thai
354	TH8MACTHAIS	Mac Server 8-bit Latin/Thai
368	HU8CWI2	Hungarian 8-bit CWI-2
380	EL8PC437S	IBM-PC Code Page 437 8-bit (Greek modification)
381	EL8EBCDIC875	EBCDIC Code Page 875 8-bit Greek
382	EL8PC737	IBM-PC Code Page 737 8-bit Greek/Latin
383	LT8PC772	IBM-PC Code Page 772 8-bit Lithuanian (Latin/Cyrillic)
384	LT8PC774	IBM-PC Code Page 774 8-bit Lithuanian (Latin)
385	EL8PC869	IBM-PC Code Page 869 8-bit Greek/Latin
386	EL8PC851	IBM-PC Code Page 851 8-bit Greek/Latin
390	CDN8PC863	IBM-PC Code Page 863 8-bit Canadian French
401	HU8ABMOD	Hungarian 8-bit Special AB Mod
500	AR8ASMO8X	ASMO Extended 708 8-bit Latin/Arabic
554	AR8NAFITHA711	Nafitha Enhanced 711 Server 8-bit Latin/Arabic
555	AR8SAKHR707	SAKHR 707 Server 8-bit Latin/Arabic
556	AR8MUSSAD768	Mussa'd Alarabi/2 768 Server 8-bit Latin/Arabic
557	AR8ADOS710	Arabic MS-DOS 710 Server 8-bit Latin/Arabic
558	AR8ADOS720	Arabic MS-DOS 720 Server 8-bit Latin/Arabic
559	AR8APTEC715	APTEC 715 Server 8-bit Latin/Arabic
560	AR8MSAWIN	MS Windows Code Page 1256 8-Bit Latin/Arabic
560	AR8MSWIN1256	MS Windows Code Page 1256 8-Bit Latin/Arabic
561	AR8NAFITHA721	Nafitha International 721 Server 8-bit Latin/Arabic
563	AR8SAKHR706	SAKHR 706 Server 8-bit Latin/Arabic
565	AR8ARABICMAC	Mac Client 8-bit Latin/Arabic
566	AR8ARABICMACS	Mac Server 8-bit Latin/Arabic
590	LA8ISO6937	ISO 6937 8-bit Coded Character Set for Text Communication
797	US8NOOP	No-op character set prohibiting conversions
829	JA16VMS	JVMS 16-bit Japanese
830	JA16EUC	EUC 16-bit Japanese
832	JA16SJIS	Shift-JIS 16-bit Japanese
833	JA16DBCS	IBM DBCS 16-bit Japanese
835	JA16EBCDIC930	IBM DBCS Code Page 290 16-bit Japanese
836	JA16MACSJIS	Mac client Shift-JIS 16-bit Japanese
840	KO16KSC5601	KSC5601 16-bit Korean
842	KO16DBCS	IBM DBCS 16-bit Korean
845	KO16KSCCS	KSCCS 16-bit Korean
850	ZHS16CGB231280	CGB2313-80 16-bit Simplified Chinese
851	ZHS16MACCGB231280	Mac client CGB2313-80 16-bit Simplified Chinese
860	ZHT32EUC	EUC 32-bit Traditional Chinese
861	ZHT32SOPS	SOPS 32-bit Traditional Chinese
862	ZHT16DBT	Taiwan Taxation 16-bit Traditional Chinese
863	ZHT32TRIS	TRIS 32-bit Traditional Chinese
864	ZHT16DBCS	IBM DBCS 16-bit Traditional Chinese
865	ZHT16BIG5	BIG5 16-bit Traditional Chinese
866	ZHT16CCDC	HP CCDC 16-bit Traditional Chinese
870	AL24UTFFSS	Unicode UTF-8
997	JA16TSTSET2	ASCII-based 16-bit Test Character Set
998	JA16TSTSET	Shift-sensitive ASCII-based Test Character Set

A.4 Number Ranges for Express Data

The following sections describe the acceptable ranges for numbers in Express data.

A.4.1 Very large positive or negative numbers

Express can store extremely large positive or negative numbers. In most cases, these numbers can easily be displayed in Reports. However, if the number is outside of a certain range, it cannot be displayed in Reports. An "out of range data error" message is displayed if an Express decimal number x is found in the following range:

x > 9.9999999999999999999999999999999999999 * 10¹²⁵

x < -9.9999999999999999999999999999999999999 * 10¹²⁵

A.4.2 Rounding very small numbers

Express can store extremely small decimal numbers, such as numbers less than zero with several hundred decimal places. In most cases, these numbers can easily be displayed in reports. You can use a setting to specify whether numbers outside of certain ranges are rounded up to zero and displayed as zero in reports or whether a "rounding data error" message is displayed. The setting affects an Express decimal number x in the following ranges:

-1 * 10^-125 < x <= -4.94065645841246544 * 10^-324

4.94065645841246544 * 10^-324 <= x < 1 * 10^-125

A.4.3 Specifying the rounding setting

To specify the setting for rounding, you must create or modify the xrb.ini file, so that the setting can take effect. The following procedure explains how to make the specification in the file.

1. On the computer on which Oracle8 is running, look in the %ORACLE_HOME%/BIN directory for a file called xrb.ini. If the file exists, proceed to Step 3. Otherwise, proceed to Step 2.
2. With a text editor, create a file called xrb.ini in the %ORACLE_HOME%/BIN directory.
3. In a text editor, scroll to the [Options] section of the file, or create this section label if it does not exist.
4. Edit the value of the ZeroSmallNumbers setting if it exists; otherwise, create the setting. Specify one of the following values:

   Value	Description
   0	Display an error message rather than displaying very small numbers in reports.
   1	Round very small numbers up to zero and display them in reports. (This is the default setting.)

5. Save your changes and close the file.

A.4.4 Example setting for rounding

The following example shows a sample setting for the rounding setting.

[Options]
ZeroSmallNumbers = 0