Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


The HIDE command hides the text of a program, so that you cannot display it using the DESCRIBE command, the EDIT command, or the OBJ function. You can perform all other actions on the program, including executing, compiling, renaming, or exporting.

When you hide a program, you supply a seed expression, which Oracle OLAP uses to encrypt the program text. You can use this seed expression later with the UNHIDE command to make the text visible.


HIDE prog-name seed-exp



The name of the program whose text you want to hide. Do not enclose the program name in quotes.


A single-line text expression to be used as a seed value in the encryption of the program text. Do not specify NA for this value.

Keep a record of this seed expression, so that you can use it later with the UNHIDE command. The seed expression you specify in the UNHIDE command must be byte-for-byte the same value as you used in this command. Also, the seed expression is case-sensitive, so record uppercase and lowercase characters carefully.


Exporting and Importing with the Seed

When you export and import a hidden program, the text remains hidden in the analytic workspace in which it is imported. It retains the same seed expression for use with the UNHIDE command.

Forgetting the Seed Expression

When you want to use the UNHIDE command on a program but you have forgotten the seed expression, you can call Oracle OLAP Products Technical Support for help in solving your problem. Before calling, make a connection to Oracle OLAP from OLAP Worksheet and attach the analytic workspace that contains the hidden program.


Example 14-8 Hiding Program Text

The following example hides the text of a program called sales_rpt.

HIDE sales_rpt 'Crystal'