Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The OBJLIST function provides a list of the objects that are contained in one or more workspaces that you specify. The list of workspace objects returned by OBJLIST has duplicates removed and it is sorted in ascending order. The specified workspaces must be currently attached when you use the function.
The result, a multiline TEXT value, can be used as an argument to the OBJ function with the REFERS keyword. This usage helps in producing a cross-reference list for compilable objects, such as programs and models, in the current workspace.
Note:
OBJLIST always returns the names of all the objects in a given workspace, even when you have limited its NAME dimension.Return Value
TEXT
Syntax
OBJLIST[(text-expression)]
Arguments
A text expression that contains a single name or several names of currently attached workspaces. Each workspace name must be on a separate line of a multiline TEXT value. When you do not supply this argument, OBJLIST uses the current workspace name. When text-expression includes the name of a workspace that is not attached, OBJLIST does not return a value. Instead, it signals an error.
Examples
Example 21-9 Listing Objects in Three Workspaces
In the following example, OBJLIST returns a multiline TEXT value that includes all the objects in the three workspaces specified: mycode
, mydata
, and mytools
. The statement
SHOW OBJLIST('mycode\nmydata\nmytools')
produces the following output.
ACTUAL ADDFIVE ADVERTISING BUDGET CITYLIST CITYREPINIT CITYREPS ... YEAR
Example 21-10 Listing Referenced Objects
In the following example, OBJ(REFERS) returns a multiline TEXT value that contains every object from the mycode
, mydata
, and mytools
workspaces that is referenced in the myprog
program. The statement
SHOW OBJ(REFERS OBJLIST('mycode\nmydata\nmytools') 'myprog')
produces the following output.
ACTUAL BUDGET ... YEAR