René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_standard

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;