1 package ad_inst as
2 /* $Header: adinsts.pls 120.0 2005/05/25 11:57:41 appldev noship $ */
3 --
4 -- Package
5 -- AD_INST
6 -- Purpose
7 -- Support for R10.7 and higher server side code.
8 -- Notes
9 -- 1. This package is created in a priviledged account.
10 -- It is recommended that this package be created in 'system'
11 -- 2. The priviledged account requires the following explicit
12 -- priviledges to run (i.e. these priviledges cannot be obtained
13 -- from a role, like 'dba'):
14 -- grant create user to system;
15 -- grant select any table to system;
16 -- grant create any procedure to system;
17 -- grant create any trigger to system;
18 -- grant create any view to system;
19 -- grant execute any procedure to system;
20 -- grant drop any procedure to system;
21 -- grant drop any trigger to system;
22 -- grant drop any view to system;
23 -- grant drop any synonym to system;
24 -- grant unlimited tablespace to system with admin option;
25 -- These privledges should be granted to system in addbXXX.sql
26 --
27 -- History
28 -- 15-NOV-94 B Lind Created
29 --
30 error_buf varchar2(32760);
31
32 procedure compile_schema
33 (in_schema in varchar2);
34 --
35 -- Purpose
36 -- Compile all 'invalid' objects in a schema
37 -- Arguments
38 -- compile_schema The oracle user name to compile
39 -- Example
40 -- none
41 -- Notes
42 -- 1. This is used over the DBMS compile_schema procedure because
43 -- for performance reasons it is only desirable to recompile
44 -- objects that are invalid
45 -- 2. Any compilation errors are ignored.
46 --
47
48 procedure do_apps_ddl
49 (in_schema in varchar2,
50 ddl_text in varchar2);
51 --
52 -- Purpose
53 -- Execute the SQL statement in the schema <username>
54 -- This is done by creating the following pl/sql block:
55 -- begin <username>.apps_ddl.apps_ddl(:<ddl_text>); end;
56 -- Arguments
57 -- in_schema The schema in which to run the statement
58 -- ddl_text SQL statement to execute
59 -- Example
60 -- none
61 -- Notes
62 -- 1. Requires that the APPS_DDL has been created in the target schema
63 --
64 --
65
66 end ad_inst;