Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The INFILE
procedure evaluates the OLAP DML commands in the specified file and executes them in the current analytic workspace.
Note:
You cannot execute this procedure from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.INFILE ( filename IN VARCHAR2);
Table B-23 INFILE Procedure Parameters
Parameter | Description |
---|---|
|
The name of a file containing OLAP DML commands. The file path must be specified in a current directory object for your OLAP session. Use the OLAP DML CDA command to identify or change the current directory object. |
The following example executes the OLAP DML commands in the finances.inf
file. The location of the file is identified by the WORK_DIR
database directory.
EXECUTE dbms_aw.infile('work_dir/finances.inf');