1 package APPS_ARRAY_DDL AUTHID DEFINER as
2 /* $Header: adaaddls.pls 120.2 2012/03/29 16:47:21 jwsmith ship $ */
3 --
4 -- Package
5 -- APPS_ARRAY_DDL
6 -- Purpose
7 -- Dynamic DDL support for large objects needing >32K SQL statements
8 -- Notes
9 -- 1. This package is created in each Oracle E-Business Suite account
10 -- 2. Each account requires the following explicit
11 -- privileges to run (i.e. these privileges cannot be obtained
12 -- from a role, like 'connect'):
13 -- grant create session to <schema>
14 -- grant alter session to <schema>
15 -- grant create database link to <schema>
16 -- grant create synonym to <schema>
17 -- grant create view to <schema>
18 -- grant create cluster to <schema>
19 -- grant create procedure to <schema>
20 -- grant create sequence to <schema>
21 -- grant create table to <schema>
22 -- grant create trigger to <schema>
23 -- Currently AutoInstall grants the neccessary privs to each schema
24 --
25 glprogtext dbms_sql.varchar2s;
26 procedure apps_array_ddl
27 (lb in integer,
28 ub in integer);
29
30 procedure apps_array_ddl
31 (lb in integer,
32 ub in integer,
33 newline_flag in varchar2);
34
35 end APPS_ARRAY_DDL;