|
|
Installing
dbms_standard is installed when $ORACLE_HOME/rdbms/admin/dbmsstdx.sql is sourced (which is normally made at the
creation of a database.
Procedures and functions
It contains the following procedures and functions:
- procedure raise_application_error(num binary_integer, msg varchar2, keeperrorstack boolean default FALSE);
- function inserting return boolean;
- function deleting return boolean;
- function updating return boolean;
- function updating (colnam varchar2) return boolean;
- procedure commit;
- procedure commit_cm(vc varchar2);
- procedure rollback_nr;
- procedure savepoint(save_point varchar2);
- procedure set_transaction_use(vc varchar2);
- procedure rollback_sv(save_point varchar2);
- function sysevent return varchar2 ;
- function dictionary_obj_type return varchar2 ;
- function dictionary_obj_owner return varchar2 ;
- function dictionary_obj_name return varchar2 ;
- function database_name return varchar2 ;
- function instance_num return binary_integer ;
- function login_user return varchar2 ;
- function is_servererror (errno binary_integer) return boolean;
- function server_error(position binary_integer) return binary_integer;
- function des_encrypted_password(user varchar2 default null) return varchar2;
- function is_alter_column (column_name varchar2) return boolean;
- function is_drop_column (column_name varchar2) return boolean;
- function grantee (user_list out ora_name_list_t) return binary_integer ;
- function revokee (user_list out ora_name_list_t) return binary_integer ;
- function privilege_list (priv_list out ora_name_list_t) return binary_integer ;
- function with_grant_option return boolean ;
- function dictionary_obj_owner_list (owner_list out ora_name_list_t) return binary_integer;
- function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer;
- function is_creating_nested_table return boolean;
- function client_ip_address return varchar2;
- function sql_txt (sql_text out ora_name_list_t) return binary_integer;
- function server_error_msg (position binary_integer) return varchar2;
- function server_error_depth return binary_integer;
- function server_error_num_params (position binary_integer) return binary_integer;
- function server_error_num_params (position binary_integer)
- function server_error_param(position binary_integer, param binary_integer) return varchar2;
- function partition_pos return binary_integer;
|