Database Triggers and event attributes--Event Attributes【Blog 搬家】
Database Triggers and event attributes--Event Attributes
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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-661922/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Database Triggers and event attributes--Event AttributesDatabase
- Database Triggers and event attributes--Database System Events【Blog 搬家】Database
- Database Triggers and event attributes--Introduction[Blog 搬家]Database
- Database Triggers and event attributes--DDL/Client Events【Blog 搬家】Databaseclient
- Database Triggers and event attributes--Database System EventsDatabase
- Database Triggers and event attributes--IntroductionDatabase
- Database Triggers and event attributes--DDL/Client EventsDatabaseclient
- oracle Database Event trace 設定【Blog 搬家】OracleDatabase
- float datatype in Oracle database 【Blog 搬家】OracleDatabase
- Oracle Database Link Problems【Blog 搬家】OracleDatabase
- Oracle event 10231 【Blog 搬家】Oracle
- Database Link 建立注意的兩點【Blog 搬家】Database
- Oracle System Event TriggersOracle
- Oracle backgroud Process【Blog 搬家】Oracle
- oracle Distinct|Unique 異同【Blog 搬家】Oracle
- Oracle DDL 執行過程【Blog 搬家】Oracle
- HP -Data Protector Restore file system【Blog 搬家】REST
- V$SESSION_LONGOPS bug 【Blog 搬家】SessionGo
- 限制End User Session數量 【Blog 搬家】Session
- Trim() 函式的介紹【Blog 搬家】函式
- Oracle Date Function 講解和事例【Blog 搬家】OracleFunction
- ora -03232 問題解決【Blog 搬家】
- oracle ora-00997 problems【Blog 搬家】Oracle
- RMAN 只備份當前資料?【Blog 搬家】
- exp/imp expdp/impdp Tables 萬用字元 % 的使用【Blog 搬家】字元
- Oracle Optimizer -RBO (理解Rule-based 優化器)【Blog 搬家】Oracle優化
- oracle Database Event trace 設定OracleDatabase
- 資料庫加密Product_user_profile(PUP) TABLE FOR security 【Blog 搬家】資料庫加密
- MM-DD-RRRR / MM-DD-YYYY 的區別【Blog 搬家】
- Oracle10g V$OSSTAT 關於PHYSICAL_MEMORY_BYTES 的 Bug【Blog 搬家】Oracle
- 說服您的CTO使用事件溯源 -Event Store Blog事件
- oracle 9i database 在win2k server上搬家(轉摘)OracleDatabaseServer
- Triggers 授權
- 搬家成功了!
- jQuery attributes(上)jQuery
- 圖靈搬家啦!圖靈
- Oracle 21C TriggersOracle
- zabbix Triggers Top 100