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');