Release 9.2.0.2
Part Number A96160-01
 Contents |
 Index |
| Oracle Data Provider for .NET Developer's Guide Release 9.2.0.2 Part Number A96160-01 |
|
Oracle.DataAccess.Client Namespace, 12 of 26
The OracleGlobalization class is used to obtain and set the Oracle globalization settings of the session, thread, and local computer (read-only).
Class Inheritance
Object
OracleGlobalization
public sealed class OracleGlobalization : ICloneable, IDisposable
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
An exception is thrown for invalid property values. All newly set property values are validated, except the TimeZone property.
Changing the OracleGlobalization object properties does not change the globalization settings of the session or the thread. Either the SetSessionInfo method of the OracleConnection object or the SetThreadInfo method of the OracleGlobalization object must be called to alter the session's and thread's globalization settings, respectively.
// C# // Sets thread globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves thread globalization info OracleGlobalization ogi = OracleGlobalization.GetThreadInfo(); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi.Language); //Set thread's language ogi.Language = "FRENCH"; OracleGlobalization.SetThreadInfo(ogi); OracleGlobalization ogi2; OracleGlobalization.GetThreadInfo(ogi2); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi2.Language);
Namespace: Oracle.DataAccess.Client
Assembly: Oracle.DataAccesss.dll
OracleGlobalization members are listed in the following tables:
The OracleGlobalization static methods are listed in Table 4-75.
The OracleGlobalization properties are listed in Table 4-76.
OracleGlobalization public methods are listed in Table 4-80.
| Public Method | Description |
|---|---|
|
Creates a copy of an OracleGlobalization object |
|
|
|
Inherited from |
The OracleGlobalization static methods are listed in Table 4-78.
GetClientInfo returns an OracleGlobalization object instance that represents the Oracle globalization settings of the local computer.
This method returns an OracleGlobalization instance that represents the globalization settings of the local computer.
This method refreshes the provided OracleGlobalization object with the globalization settings of the local computer.
This method returns an OracleGlobalization instance that represents the globalization settings of the local computer.
// C# public static OracleGlobalization GetClientInfo();
An OracleGlobalization instance.
// C# // Retrieves the client globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves the client globalization info OracleGlobalization ogi = OracleGlobalization.GetClientInfo(); //Retrieves the client globalization info using overloaded method OracleGlobalization ogi2; OracleGlobalization.GetClientInfo(ogi2); //Print the language name in client globalization info Console.WriteLine("Client machine language: " + ogi.Language); Console.WriteLine("Client machine language: " + ogi2.Language);
This method refreshes the provided OracleGlobalization object with the globalization settings of the local computer.
// C# public static void GetClientInfo(OracleGlobalization oraGlob);
// C# // Retrieves the client globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves the client globalization info OracleGlobalization ogi = OracleGlobalization.GetClientInfo(); //Retrieves the client globalization info using overloaded method OracleGlobalization ogi2; OracleGlobalization.GetClientInfo(ogi2); //Print the language name in client globalization info Console.WriteLine("Client machine language: " + ogi.Language); Console.WriteLine("Client machine language: " + ogi2.Language);
GetThreadInfo returns or refreshes an OracleGlobalization instance.
This method returns an OracleGlobalization object instance of the current thread.
This method refreshes the OracleGlobalization object instance with the globalization settings of the current thread.
This method returns an OracleGlobalization instance of the current thread.
// C# public static OracleGlobalization GetThreadInfo();
An OracleGlobalization instance.
Initially, GetThreadInfo() returns an OracleGlobalization object that has the same property values as that returned by GetClientInfo(), unless the application changes it by invoking SetThreadInfo().
// C# Retrieves the thread globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves the thread globalization info OracleGlobalization ogi = OracleGlobalization.GetThreadInfo(); //Retrieves the thread globalization info using overloaded method OracleGlobalization ogi2; OracleGlobalization.GetThreadInfo(ogi2); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi.Language); Console.WriteLine("Thread language: " + ogi2.Language);
This method refreshes the OracleGlobalization object with the globalization settings of the current thread.
// C# public static void GetThreadInfo(OracleGlobalization oraGlob);
Initially GetThreadInfo() returns an OracleGlobalization object that has the same property values as that returned by GetClientInfo(), unless the application changes it by invoking SetThreadInfo().
// C# Retrieves the thread globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves the thread globalization info OracleGlobalization ogi = OracleGlobalization.GetThreadInfo(); //Retrieves the thread globalization info using overloaded method OracleGlobalization ogi2; OracleGlobalization.GetThreadInfo(ogi2); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi.Language); Console.WriteLine("Thread language: " + ogi2.Language);
This method sets Oracle globalization parameters to the current thread.
// C# public static void SetThreadInfo(OracleGlobalization oraGlob);
Any .NET string conversions to and from ODP.NET Types, as well as ODP.NET Type constructors, use the globalization property values where applicable. For example, when constructing an OracleDate structure from a .NET string, that string is expected to be in the format specified by the OracleGlobalization.DateFormat property of the thread.
// C# // Sets thread globalization info. ... string ConStr = "User Id=myschema;Password=mypassword;" + "Data Source=oracle;"; OracleConnection con = new OracleConnection(ConStr); con.Open(); //Retrieves thread globalization info OracleGlobalization ogi = OracleGlobalization.GetThreadInfo(); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi.Language); //Set thread's language ogi.Language = "FRENCH"; OracleGlobalization.SetThreadInfo(ogi); OracleGlobalization ogi2; OracleGlobalization.GetThreadInfo(ogi2); //Print the language name in thread globalization info Console.WriteLine("Thread language: " + ogi2.Language);
The OracleGlobalization properties are listed in Table 4-79.
This property specifies the calendar system.
// C# public string Calendar {get; set;}
A string representing the Calendar.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_CALENDAR setting of the local computer. This value is the same regardless of whether the OracleGlobalization object represents the settings of the client, thread, or session.
This property specifies a client character set.
// C# public string ClientCharacterSet {get;}
A string that the provides the name of the character set of the local computer.
The default value is the character set of the local computer.
This property represents a method of comparison for WHERE clauses and comparison in PL/SQL blocks.
// C# public string Comparison {get; set;}
A string that provides the name of the method of comparison.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_COMP setting of the local computer.
This property specifies the string to use as a local currency symbol for the L number format element.
// C# public string Currency {get; set;}
The string to use as a local currency symbol for the L number format element.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_CURRENCY setting of the local computer.
|
See Also:
|
This property specifies the date format for Oracle Date type as a string.
// C# public string DateFormat {get; set;}
The date format for Oracle Date type as a string
ObjectDisposedException - The object is already disposed.
The default value is the NLS_DATE_FORMAT setting of the local computer.
This property specifies the language used to spell names of days and months, and date abbreviations (for example: a.m., p.m., AD, BC).
// C# public string DateLanguage {get; set;}
A string specifying the language.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_DATE_LANGUAGE setting of the local computer.
This property specifies the dual currency symbol, such as Euro, for the U number format element.
// C# public string DualCurrency {get; set;}
A string that provides the dual currency symbol.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_DUAL_CURRENCY setting of the local computer.
|
See Also:
|
This property specifies the string to use as an international currency symbol for the C number format element.
// C# public string ISOCurrency {get; set;}
The string used as an international currency symbol.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_ISO_CURRENCY setting of the local computer.
|
See Also:
|
This property specifies the default language of the database.
// C# public string Language {get; set;}
The default language of the database.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_LANGUAGE setting of the local computer.
Language is used for messages, day and month names, and sorting algorithms. It also determines NLS_DATE_LANGUAGE and NLS_SORT parameter values.
This property indicates whether CHAR and VARCHAR2 columns use byte or character (default) length semantics.
// C# public string LengthSemantics {get; set;}
A string that indicates either byte or character length semantics.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_LENGTH_SEMANTICS setting of the local computer.
This property determines whether data loss during an implicit or explicit character type conversion reports an error.
// C# public bool NCharConversionException {get; set;}
A string that indicates whether or not a character type conversion causes an error message.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_NCHAR_CONV_EXCP setting of the local computer.
This property specifies the characters used for the decimal character and the group separator character for numeric values in strings.
// C# public string NumericCharacters {get; set;}
A string that represents the characters used.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_NUMERIC_CHARACTERS setting of the local computer.
This property specifies the collating sequence for ORDER by clause.
// C# public string Sort {get; set;}
A string that indicates the collating sequence.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_SORT setting of the local computer.
This property specifies the name of the territory.
// C# public string Territory {get; set;}
A string that provides the name of the territory.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_TERRITORY setting of the local computer.
Changing this property changes other globalization properties.
This property specifies the string format for TimeStamp types.
// C# public string TimeStampFormat {get; set;}
The string format for TimeStamp types.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_TIMESTAMP_FORMAT setting of the local computer.
This property specifies the string format for TimeStampTZ types.
// C# public string TimeStampTZFormat {get; set;}
The string format for TimeStampTZ types.
ObjectDisposedException - The object is already disposed.
The default value is the NLS_TIMESTAMP_TZ_FORMAT setting of the local computer.
This property specifies the time zone region name or hour offset.
// C# public string TimeZone {get; set;}
The string represents the time zone region name or the time zone offset.
ObjectDisposedException - The object is already disposed.
The default value is the time zone region name of the local computer
TimeZone is only used when the thread constructs one of the TimeStamp structures. TimeZone has no effect on the session.
TimeZone can be either an hour offset, for example, 7:00, or a valid time zone region name that is provided in V$TIMEZONE_NAMES, such as US/Pacific. Time zone abbreviations are not supported.
This property returns an empty string if the OracleGlobalization object is obtained using GetSessionInfo() or GetSessionInfo(OracleGlobalization). Initially, by default, the time zone of the session is identical to the time zone of the thread. Therefore, given that the session time zone is not changed by invoking ALTER SESSION calls, the session time zone can be fetched from the client's globalization settings.
OracleGlobalization public methods are listed in Table 4-80.
| Public Method | Description |
|---|---|
|
Creates a copy of an OracleGlobalization object |
|
|
|
Inherited from Component |
This method creates a copy of an OracleGlobalization object.
// C# public object Clone();
An OracleGlobalization object.
ICloneable
The cloned object has the same property values as that of the object being cloned.
// C# ... //Need a proper casting for the return value when cloned OracleGlobalization ogi_cloned = (OracleGlobalization) ogi.Clone(); ...
|
 Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|
