ITPub博客

首页 > 数据库 > 数据库开发技术 > Database Triggers and event attributes--Event Attributes

Database Triggers and event attributes--Event Attributes

原创 数据库开发技术 作者:myhuaer 时间:2004-11-15 11:05:56 0 删除 编辑

With the introduction of the 20 new database triggers, came the creation of attribute events or variables that are set when a certain database trigger event is executed. The previous section highlighted each of the database triggers, along with the event attributes that are set and can be referenced for each trigger. Below is a list of each of the attribute events, the data type and a short description.

Attribute Event

Data Type

Description

ora_client_ip_address

VARCHAR2

Provides the IP address of the client machine when using TCP/IP

ora_database_name

VARCHAR2(50)

Provides the database name

ora_des_encrypted_password

VARCHAR2

Provides the DES encrypted password of the user being created or altered

ora_dict_obj_name

VARCHAR(30)

Provides the object name of the object being manipulated

ora_dict_obj_name_list

(name_list OUT

ora_name_list_t)

BINARY_INTEGER

Provides a list of object names being manipulated

ora_dict_obj_owner

VARCHAR(30)

Provides the owner of the object being manipulated

ora_dict_obj_owner_list(owner_list OUT ora_name_list_t)

BINARY_INTEGER

Provides the owners of the objects being manipulated

ora_dict_obj_type

VARCHAR(20)

Provides the type of object being manipulated

ora_grantee(

  user_list

  OUT ora_name_list_t)

BINARY_INTEGER

Provides the number of grantees

ora_instance_num

NUMBER

Provides the instance number.

ora_is_alter_column(

column_name IN VARCHAR2)

BOOLEAN

Provides a return value of TRUE if the specified column is altered

ora_is_creating_nested_table

BOOLEAN

Provides a return value of TRUE if the current event is creating a nested table

ora_is_drop_column(

column_name IN VARCHAR2)

BOOLEAN

Provides a return value of TRUE if the specified column is dropped

ora_is_servererror

BOOLEAN

Provides a return value of TRUE is the error specified is on the error stack

ora_login_user

VARCHAR2(30)

Provides the login schema

ora_partition_pos

BINARY_INTEGER

Provides the position in a CREATE TABLE command where the partition clause can be inserted when using the INSTEAD OF trigger

ora_privilege_list(

privilege_list OUT

ora_name_list_t)

BINARY_INTEGER

Provides the list of privileges being granted or revoked

ora_revokee (user_list OUT

ora_name_list_t)

BINARY_INTEGER

Provides a list of the revokees of the revoke command

ora_server_error

NUMBER

Provides the error on the error stack for the position specified in the stack (1 meaning the top of the stack)

ora_server_error_depth

BINARY_INTEGER

Provides the total number of errors on the error stack

ora_server_error_msg

(position in binary_integer)

VARCHAR2

Provides the error on the error stack for the position specified in the stack (1 meaning the top of the stack)

ora_server_error_num_params

(position in binary_integer)

BINARY_INTEGER

Provides the number of strings that have been substituted into the error message on the error stack for the position specified in the stack (1 meaning the top of the stack)

ora_server_error_param

(position in binary_integer,

param in binary_integer)

VARCHAR2

Provides the matching substitution value in the error message for the parameter number specified in conjunction with the position specified on the stack ( 1 meaning the top of the stack)

ora_sql_txt (sql_text out

ora_name_list_t)

BINARY_INTEGER

Provides the SQL statement of the statement that caused the trigger to execute (if the statement is lengthy, it will separate it into multiple PL/SQL table elements); the value returned specifies the number of elements

ora_sysevent

VARCHAR2(20)

Provides the system or client event that caused the trigger to execute

ora_with_grant_option

BOOLEAN

Provides a return value of TRUE if the privileges are granted with the grant option

space_error_info(

error_number OUT NUMBER,

error_type OUT VARCHAR2,

object_owner OUT VARCHAR2,

table_space_name OUT

VARCHAR2,

object_name OUT VARCHAR2,

sub_object_name OUT

VARCHAR2)

BOOLEAN

Provides a return value of true if the error is related to an out-of-space error and provides the object information of the object with the error

These attribute events allow extreme flexibility and functionality in each of the database triggers and should be used as necessary.


[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/34596/viewspace-780681/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-09-11

  • 博文量
    211
  • 访问量
    630045