eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_ERROR_TRANSLATIONS

Object Details

Object Name:	ALL_ERROR_TRANSLATIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Describes all error translations accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the SQL translation profile
PROFILE_NAME	VARCHAR2	(128)	Yes	Name of the SQL translation profile
ERROR_CODE	NUMBER		Yes	The error code
TRANSLATED_CODE	NUMBER			The translated error code
TRANSLATED_SQLSTATE	VARCHAR2	(5)		The translated SQLSTATE
ENABLED	VARCHAR2	(5)		Is the translation enabled?
REGISTRATION_TIME	TIMESTAMP(6)	(11)		Time the translation was registered
COMMENTS	VARCHAR2	(4000)		Comment on the translation

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      PROFILE_NAME
,      ERROR_CODE
,      TRANSLATED_CODE
,      TRANSLATED_SQLSTATE
,      ENABLED
,      REGISTRATION_TIME
,      COMMENTS
FROM SYS.ALL_ERROR_TRANSLATIONS;

Dependencies

[top of page]

SYS.ALL_ERROR_TRANSLATIONS references the following:

SYS: OBJAUTH$; SQLTXL_ERR$; USER$; _CURRENT_EDITION_OBJ

SYS.ALL_ERROR_TRANSLATIONS is referenced by following:

PUBLIC: ALL_ERROR_TRANSLATIONS
SYS: DBMS_SQL_TRANSLATOR - show dependent code