-
Notifications
You must be signed in to change notification settings - Fork 10
/
install_nocrypto.sql
37 lines (29 loc) · 1.12 KB
/
install_nocrypto.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
-- avoids compiling procedures that require dbms_crypto. Use this install script if dbms_crypto was
-- not granted to your schema
--
set define off
alter session set plsql_optimize_level=3;
prompt Creating package XUTL_CDF ...
@@MSUtilities/CDFManager/xutl_cdf.pks
@@MSUtilities/CDFManager/xutl_cdf.pkb
--@@MSUtilities/OfficeCrypto/xutl_offcrypto.pks
--@@MSUtilities/OfficeCrypto/xutl_offcrypto.pkb
prompt Creating type ExcelTableCell ...
@@ExcelCommons/plsql/ExcelTableCell.tps
prompt Creating type ExcelTableCellList ...
@@ExcelCommons/plsql/ExcelTableCellList.tps
prompt Creating package ExcelTypes ...
@@ExcelCommons/plsql/ExcelTypes.pks
@@ExcelCommons/plsql/ExcelTypes.pkb
prompt Creating package ExcelFmla ...
@@ExcelCommons/plsql/ExcelFmla.pks
@@ExcelCommons/plsql/ExcelFmla.pkb
prompt Creating package XUTL_XLSB ...
@@ExcelCommons/plsql/xutl_xlsb.pks
@@ExcelCommons/plsql/xutl_xlsb.pkb
prompt Creating package ExcelGen ...
-- this compile directive prevents compiling a procedure that requires dbms_crpto
ALTER SESSION SET plsql_ccflags='no_crypto:TRUE';
@@plsql/ExcelGen.pks
@@plsql/ExcelGen.pkb
ALTER SESSION SET plsql_ccflags='';