Oracle Graphics Runtime Help
To learn how to use help. Press F1

  Reference Information

Descriptions of Graphics Builder Runtime menus.

  Troubleshooting

Descriptions of Graphics Builder error messages and exceptions.


 Reference Information

File Menu

Edit Menu

Window Menu

Help Menu


Edit Menu

This menu lists the standard Edit menu options: Undo, Cut, Copy, Paste, and Clear. See your Windows documentation for details.

This menu also contains the following Graphics Edit menu items:

 Import

Export

Tools Options


Export

Stores a module from the current display into a file or the database.

The following are descriptions of the Export submenu items:

Drawing

Stores the contents of the showing layers into a file or the database.  Choosing this command shows the Export dialog box.

Image

Stores the selected image into a file or the database.  Choosing this command shows the Export Image dialog box.

Sound

Loads a sound into the current display.  Choosing this command shows the Export Sound dialog box.

Text

Places text from a file into a PL/SQL Program Unit editor.  Choosing this command shows your system's Save File dialog.

Template

Stores a chart template from the current display to a file or the database.  Choosing this command shows the Export dialog box.

Color Palette

Stores the current display's color palette into a file or the database.  Choosing this command shows the Export dialog box.


Tools Options

Changes various Graphics Builder options.

Select the dialog tab for the options you want to set:

Defaults Tab

Sets copyright message, color palette, number/date format lists, and page size.

Preferences Tab

Sets startup options, and other general settings.


Defaults Tab

Sets copyright message, color palette, number/date format lists, and page size.

Dialog Box Options

Copyright Message

Is the default text that will appear in a newly created display's Get Info dialog in the Copyright field.  This setting takes effect with the next display you create or open.

Color Palette

Sets options related to the color palette in use.

File	Is the name of the file that contains the color palette to be used for any new displays you create.  If this field is blank, Graphics Builder uses its default color palette.  This field must contain the color palette's full or relative pathname.  This setting takes effect with the next display you create or open.

Mode	Determines how a display's color palette is implemented on your system.  Each time you make a different display active, Graphics Builder tries to modify your system's color palette to match--or come as close as possible to--that display's color palette.  Since your system can handle only a limited number of colors at once, Graphics Builder may not be able to accurately show multiple displays simultaneously if they are using different color palettes.   This setting takes effect with the next display you create or open.  The list contains the following options:

Editable means Graphics Builder temporarily replaces your system's color palette with the palette of the active display.  Each time a new display is made active, its color palette replaces the system palette.  The active display will then be shown accurately, although the appearance of the inactive displays may suffer.  The palette must be Editable in order to modify or import a color palette.

Read Only - Shared means Graphics Builder continues to append each active display's color palette to your system's original palette until there is no room left in the palette for any more colors.  That palette becomes the single palette that all open displays share.  If you make a display that uses entirely different colors active, it may not be shown accurately.

Read Only - Private means each time you make a display active, Graphics Builder appends that display's color palette to your system's original palette until there is no room left in the palette for any more colors.  That palette becomes the palette that is used whenever that display is active.  The active display is then shown accurately, although the appearance of the inactive displays may suffer.

Format Lists

Sets the date and number formats that are available by default in the number and date format dialog boxes.  This setting takes effect immediately.  You can choose the following buttons:

Date	Sets the date format masks, and shows the Date Format dialog box.

Number	Sets the number format masks, and shows the Number Format dialog box.

Page Size

Sets the width, height, and units of a physical page, which determines the placement of page break lines on the layout.  Note that the layout can be larger than the page size.

Save

Accepts the options and saves them in your options file.  For more information, see the Oracle Developer Installation Guide.


Preferences Tab

Sets startup options, and other general settings.

Dialog Box Options

Startup

Sets several options that control the behavior of Graphics Builder when you first run it.

Open	Determines whether Graphics Builder opens or creates a display by default.

No Display means no display is initially created or opened when you first run Graphics Builder.

New Display means Graphics Builder automatically creates a new display and shows its Layout editor.

Open File means Graphics Builder automatically shows the Filter dialog box, allowing you to initially open a display from a file.

Logon at Startup	Shows the Connect dialog box when you first run Graphics Builder.  If you connect to a database using the USERID executable argument, the Connect dialog does not appear.  This setting takes effect the next time you run an Graphics Builder executable.

General

Sets general options.

Sound Output

Is the output device to be used when playing sounds.  The items that appear in this list are system-specific.  For more information, refer to your system documentation.  This setting takes effect immediately.

Image Compression

Specifies the compression scheme used to compress all image in the display when you save or generate a display, or copy an image to the Clipboard.

If you select a compression scheme that is not applicable to an image in the display, that image is not compressed.  For example, if you select PackBits and save a display containing a color image, that image is not compressed.  This setting takes effect with the next display you create or open.

Automatic Character Set Conversion

Specifies whether Graphics Builder automatically converts a display's text into the character set specified by the NLS_LANG environment variable when the display is opened.  This setting takes effect with the next display you create or open.

Smooth Redraw at Runtime

Determines how Graphics Builder updates portions of the layout that are affected by drawing operations.  This setting takes effect at Runtime.

If this setting is off, Graphics Builder individually draws each modified object within a damage region.

If this setting is on, Graphics Builder first renders each of the modified objects in an internal buffer.  When the rendering is complete, the layout is updated with a single redraw.

Smooth Redraw significantly reduces flickering of the layout as it is updated.  However, if the damage region is large, the internal buffer generated by Smooth Redraw may require a large amount of memory.  We recommend that you leave Smooth Redraw on unless you encounter memory problems.

Keep Backup File

Specifies whether Graphics Builder keeps a backup copy of the display each time you save it.  The backup file has the same base name as the original, and the filename extension is changed to .bak.  For example, if you save the display trends.ogd, the backup file is named trends.bak.

Apply Properties on Navigation

Specifies whether changes in a property sheet are automatically applied when you show another object's properties in that property sheet (e.g., by selecting another object from the property sheet's drop-down list).  If this check box is not on, you will be prompted to save pending changes when necessary.

Apply Query Properties on Navigation

Specifies whether changes in the Query property sheet are automatically applied when you execute the query.  If this check box is not on, you will be prompted to save pending changes when necessary.

Save

Accepts the options and saves them in your options file.  For more information, see the Oracle Developer Installation Guide.


File Menu

This section describes the following Graphics Builder File menu items:

Open

Close

Revert

Connect

Disconnect

Page Setup

Print

Most Recently Accessed Files List

Exit


Open

Retrieves an existing display that is stored in a file or the database.

While several different displays can be open simultaneously, multiple instances of one display cannot be open in the same Graphics Builder session.

Dialog Box Options

Object Access

Specifies the location of the display to open.  Choosing Database shows the Open from Database dialog box.  Choosing File System shows the Open File dialog for your system.

Display

Specifies the type of files or modules to view when selecting one to open.


Close

Dismisses the current display.

If the display has not been saved since changes were made, a dialog box appears from which you choose to save the changes, discard the changes, or cancel the close operation.


Connect

Logs you on to a database.

You can type in each text box separately, or you can type the following all on one line in the User Name text box:

username/password@database

You can also type just the user name and database in the User Name text box, and type the password in the password text box so that it is not displayed:

username@database

Dialog Box Options

User Name

Is the user name of the database account to connect to.

Password

Is the password for the database account.

Database

Is the connect string that specifies the database.  To connect to a remote database, you must also type the appropriate SQL*Net database connect string.


Disconnect

Closes your current database connection.


Page Setup (Print Setup)

Sets page size, orientation, and other output-related settings.

This dialog is system-specific.  For more information, refer to your system documentation.


Print

Prints the layout to the default printer.

Only the layers that are showing will be printed.

Your system may display a Printer dialog when the Print menu item is chosen.  For more information, refer to your system documentation.


Most Recently Accessed Files List

Lists the four most recently accessed files, in descending order.  Possible filetypes are .ogd and .pll.  Double-clicking the filename of an .ogd file opens that file in the designer, while double-clicking the filename of a .pll file loads the library.


Exit (Quit)

Ends your Graphics Builder Designer session.

All open displays are closed, and the session is ended.  If any displays have been modified since they were last saved or opened, you will be prompted to save the changes, discard the changes, or abort the exit operation.


Help Menu

The Help menu is system-specific.  For more information, refer to your system documentation.  However, the menu items listed below always appear:

Contents

Get Module Info

About Graphics Builder


Contents

Invokes the Graphics Builder help system.  If applicable, the help system uses the standard help interface for your operating system.  If not, the Oracle Help system is shown.


Get Module Info

Shows the creation and revision information for the current display.

Dialog Box Options

Created

Shows information about the display creation, if the display is stored in the database.

By	Is the user name of the user who first saved the display in the database.

Date	Is the date at which the display was first saved in the database.

Version	Is the Graphics Builder version used to create the display.

Last Modified

Shows information about the display modification, if the display is stored in the database.

By	Is the user name of the user who most recently saved the display in the database.

Date	Is the date at which the display was most recently saved in the database.

Version	Is the Graphics Builder version used to most recently update the display.

Copyright

Shows copyright information about the display.  Copyright is useful is you plan to distribute the display to others.  It also appears in the Get Module Info dialog box in the Graphics Builder Runtime executable.  Type text here that you want to be shown within runtime versions of the display that you distribute.  The default for this field is the contents of the Copyright Message field in the Tools Options dialog box.


About Graphics Builder

Shows information about the Graphics Builder executable, including the version number and copyright notice.


Window Menu

This menu lists the standard Window menu options: Cascade, Tile, and Arrange Icons. See your Windows documentation for details.

This menu also lists all of the Oracle Graphics Builder windows that are currently open, and it allows you to choose one to activate.

The chosen window will be made the active window, and it will be moved in front of all other windows.  For example, if you have the Layout editor and Chart Template editor open, and the Layout editor is active (in front of all other windows), you can choose the Chart Template editor from the Window menu to activate it.  For more information on the Window menu, refer to your system documentation.


Import

Imports a module from a file or the database.

The following are descriptions of the Import submenu items:

Drawing

Imports the contents from a drawing file.  Choosing this command shows the Import Dialog Box  .

Display

Imports a display.  Choosing this command shows the Import Display dialog box.

From Database

Imports an object from a database.  Choosing this command shows the Import from Database Dialog Box

Image

Imports an image.  Choosing this command shows the Import Image dialog box.

Sound

Imports a sound file.  Choosing this command shows the Import Sound dialog box.


Revert

Reverts to the previously saved version of the file.


Select Data Tables dialog box

  Related Topics

Description  The Select Data Tables dialog box enables you to include datasource objects from the connected database into your query.

This dialog box contains:

Show	Specifies whether or not to display tables, views, queries, snapshots, and/or synonyms in the list box.
Drop-down box	Specifies from which datasource to display the objects.  You can also select a table from a separate account or database .
Select Data Tables	Lists the available datasource objects you can include in your query.  Tip
Info	Displays information on the selected object:  the kind, name, owner, date it was created, and comments.
Include	Includes the selected item into the Query Builder workspace.
Close	Closes the dialog box without including a datasource object.


Accessing other accounts in the current database

  Related Topics

To access tables in other accounts in the current database:

1	Click the current database name.  The Include button becomes an Open button, and the list box displays a list of accounts in the current database.

2	Click the name of the account you want to open.

3	Click Open, or simply double-click the account name.  Query Builder displays a list of tables in that account, and the Open button again becomes the Include button, enabling you to include tables in the usual manner.


Opening other accounts

  Related Topics

If the table you want is not listed in the current database, you can navigate to other accounts and databases and select tables from those accounts.

To navigate to other accounts and databases:

1	Click the box above the list of tables.  You will see two selections:  the name of the current database and the word Databases.

2	To access tables in other accounts in the current database, click here.

If you are unable to connect to a listed database, it may be due to an invalid link caused by a network problem or a changed remote password.  Contact your database administrator for assistance.


Including a table more than once

  Related Topics

If you include the same table more than once in a query, duplicate tables are automatically assigned system-generated alias names composed of the name for the base table, followed by an underscore and an alphanumeric sequence.


Select Related Tables dialog box

Description  The Select Related Tables dialog box enables you to include tables that are related to the selected table in the Query window.

This dialog box contains:

Show	This option is not available.
Drop-down box	Specifies whether or not to display all related tables.
Select Data Tables	Lists the available related tables.  Tip
Info	Displays information on the selected table:  the kind, name, owner, date it was created, and comments.
Include	Includes the selected table.
Close	Closes the dialog box without including a related table.


Rename Table dialog box

  Related Topics

Description  The Rename Table dialog box enables you to rename the currently active table.

This dialog box contains:

Default Table Name	Specifies the current name of the table.
List box	Lists the tables you have open to rename.
New Name	Specifies the new table name.
Define	Updates the table name while keeping the dialog box open.


Identifying a renamed table

In a stored query, it is not immediately apparent whether a particular table has a user-defined name or its original name.

To find out if a particular table has been renamed:

1	Click [image] in the Icon bar.

2	Click the table in question in the list of Available Tables.

If the table has been renamed, the alias name appears in the New Name: field and a different name (the original table name) in the Default Table Name: field.

SQL users can also identify renamed tables by clicking [image] in the Icon bar. This brings up the Show SQL dialog box, where any name changes appear in the SELECT statement in standard SQL syntax for table aliases.


Set Relationship dialog box

  Related Topics

Description  The Set Relationship dialog box enables you to create simple, self, composite, unmatched, and non-equal relationships between two tables.

This dialog box contains:

Relationship	Specifies the origin (in A->) and target (in B->) column names.
Operator	Specifies the type of relationship between the columns.
Use Relationship in Query	Specifies if your relationship will be used in the query.  Default is checked.
A not found in B radio button	Specifies that the data retrieved is all data common to both tables, in addition to data that is in table A, but not in table B.
B not found in A radio button	Specifies that the data retrieved is all data common to both tables, in addition to data that is in table B, but not in table A.
Suppress Mismatches radio button	Default.  Specifies that the data retrieved is common for both tables.


About relationships

  Related Topics

A relational database consists of a number of related tables.  Each table is made up of columns (sometimes called fields) which are arranged vertically.  Each column has a name, and contains a unique type of data.

Relationships, or joins, define how a column in one table relates to a column in another table.  In many cases, the relationships you need are already defined in the database.  Relationships also reduce data redundancy.  Whenever there is a relationship between columns in different tables, you can use the tables together in a query.  Note

Related columns do not always share the same names.  You can always relate columns that share the same datatype, and in some instances you can relate columns of different datatypes, if the relationship makes sense.  For example, you can always relate a Number datatype column with a Character column, since a number can also be interpreted as a character.  In fact, almost any column (except long text columns) can be related to Character columns.

Relationships can be user-defined (temporary) or established in the underlying data dictionary  Relationships in the data dictionary automatically appear when you include related tables (tables that have a primary/foreign key relationship).  You do not have to do anything to use these relationships, since they are always valid.  These can be created or modified using the Schema Builder.

User-defined relationships are valid only for the query in which you create them.  Creating a user-defined relationship does not establish a corresponding permanent relationship in the underlying table.  The main difference between the two is that in the case of a user-defined relationship, you must draw the relationship line; in a relationship stored in the database, Query Builder draws it for you.

Note (Report Builder only):  Report Builder data links are not the same as Query Builder relationships.  Data links are created between two or more queries, where Query Builder relationships (or joins) are created within a single query.  For more information, see the Report Builder online help.


Activating and deactivating a relationship

  Related Topics

Relationships that you create using the mouse are automatically activated and deactivated as they are needed in a query.  Active relationships are displayed with a heavy black line; inactive relationships are shown as grey lines.

To manually activate a relationship using the mouse:

  Double-click an inactive relationship line.

To deactivate a relationship:

  Double-click the active relationship line.


Define Column dialog box

Description  The Define Column dialog box enables you to create a new column in your query based on values in another column. Defined columns appear in both the Datasource panel and the Results window.

This dialog box contains:

Defined Columns	Specifies the name of the column you want to create.
List box	Lists existing defined columns.
Defined as	Specifies the expression of the selected column.
Define	Applies the definition to the column.
Remove	Deletes the selected column.
Paste Column	Displays the Paste Column dialog box.
Paste Func	Displays the Paste Function dialog box.
Note:  The defined column is only a part of your query and will not modify the table definition saved in the database.


Sort dialog box

Description  The Sort dialog box enables you to sort the data in your query according to columns in your table.

This dialog box contains:

Available Columns	Lists the table columns you can sort in the Results window.
Sorted Columns	Lists the table columns that are currently sorted in the Results window.
Copy	Copies the selected column from the Available Columns list to the Sorted Columns list.
Remove	Removes the selected column from the Sorted Columns list.
Sorting Order	Sorts the selected column in Ascending or Descending order. Default is Ascending.


Query Builder Help

  Related Topics

Building a new query

Adding conditions to a query

Creating a simple relationship

Defining a column

Sorting query data


About Query Builder

  Related Topics

Query Builder is an easy-to-use data access tool designed for analysts, managers, and other business professionals.  It provides a logical and intuitive means to access information from your organization's databases for analysis and reporting.

Query Builder is designed for professionals who do not have a computer programming or database background.  Because of its powerful query features and its support of Structured Query Language (SQL) statements, experienced database users and programmers will find that Query Builder serves many of their needs as well.

In Query Builder's graphical Query window , you can specify a request for data from your organization's database(s).  The request for data is called a query.

You can use Query Builder to define almost any query that you would build using a SQL SELECT statement.  Query Builder automatically generates the appropriate SELECT FROM [table.column] clause based on columns displayed in the Query Builder workspace.


Column Sequence dialog box

Description  The Column Sequence dialog box enables you to adjust your query results in the Query Builder workspace.

This dialog box contains:

Available Columns	Lists the table columns you can display in the Query Builder workspace.  Tip
Displayed Columns	Lists the table columns that are currently displayed in the Query Builder workspace.
Copy	Copies the selected column from the Available Columns list to the Displayed Columns list.
Remove	Removes the selected column from the Displayed Columns list.
Format	Displays the Format dialog box.
Totals	Displays the Totals dialog box.
Execute	Runs the query.


Paste Column dialog box

  Related Topics

Description  The Paste Column dialog box enables you to paste an existing column from a selected table into your query.

This dialog box contains:

List box	Lists the columns you can paste.  Tip


Paste Function dialog box

Description  The Paste Function dialog box enables you to paste a function into your condition or query.

This dialog box contains:

Show Categories	Specifies the types of functions that display in the list box:  number, character, date, conversion, group, other.
List box	Lists the available functions under the selected category.
Paste Arguments	Specifies whether or not to include the argument (the expression within the parentheses of a function that supplies information for the function to use).


Show SQL dialog box

  Related Topics

The Show SQL dialog box displays the SQL statements for your query thus far. You cannot edit or copy the SQL statements in the Show SQL dialog box.


The column or columns that uniquely identify each row of a table.  Primary keys appear in bold.


A column that refers to the primary key values in another table. Foreign keys appear in italics.


The sources from which a query retrieves data, including tables, views, queries, synonyms, and snapshots.


A datasource made up of columns from one or more database tables combined into one logical table.


A string consisting of a function or operation and the database column(s) to be operated on (for example, SALARY+COMMISSION).


To conform to naming conventions, each query name must begin with a letter and can contain up to 30 letters and numbers.  If you don't use naming conventions when naming database queries, Query Builder will convert the name to a "literal" value (enclosed in double quotes).


About the Conditions panel

The Conditions panel is a section of the Query window that contains the Condition field, where you enter expressions and conditions.  Query Builder conditions automatically generate WHERE or HAVING clauses, as appropriate.

The table and column names indicate which columns will be filtered in the condition.  You may omit the table name if the column name is unique.  Tip

Note:  When you activate the Condition field, the cursor will have  a (+) sign, indicating that any item you click on will be added to your condition.  To deactivate this, you can click [image] in the Icon Bar.


About the Query window

When you open a query, Query Builder displays it in the Query window, split into two panels:

•	the Conditions panel, where the Condition field is located.  It is used to refine the query.

•	the Datasource panel, which displays the tables (views, snapshots, and so forth) used in the query.

Depending on your preferences, the panels may be split vertically or horizontally.

Each table is displayed in a box containing the name of the table and the names of columns in that table.  There are a number of icons that help identify the current database object.  The icons indicate whether descriptive comments are attached, the type of datasource, the column's datatype, and whether indexes have been defined for tables in the query.

Lines are drawn to indicate the relationships between columns.  Relationships are set up between tables to identify how a column in one table relates to a column in another table.

A check mark to the left of the column name indicates the column has been included in the query.  This means that Query Builder will search for data corresponding to the column name when you run the query.  No check mark indicates that column's data will not be included.


About the Datasource panel

  Related Topics

The Datasource panel is the section of the Query window where items, such as tables and relationships, display.


About the Icon Bar

  Related Topics

The Icon Bar displays at the top of the Query Builder window.  Click on each icon to view a description.


Save icon

Saves your query to the specified file.


Cut icon

Cuts the selected text and places it on your operating system's clipboard.


Copy icon

Copies the selected text onto your operating system's clipboard while the original text remains intact.


Paste icon

Pastes the current clipboard items into the active location.  If there is nothing on the clipboard, nothing will be pasted.  You can paste any text that you have cut or copied.


Clear icon

Removes the selected item (i.e., text, table).  Unlike the Cut command, Clear does not place the removed item(s) on your operating system's clipboard.


Select All icon

Selects every item in the active window.  For example, if the Conditions panel is active, all conditions in the panel will be selected.


Select Data Tables icon

Displays the Select Data Tables dialog box.


Select Related Tables icon

Displays the Select Related Tables dialog box.  This icon is available only when the table you have selected has a related table in the connected database.


Rename Table icon

Displays the Rename Table dialog box.  This icon is available only when there is at least one table in the Query Builder workspace.


Get Info icon

Displays the Info dialog box and information on the selected database object.  This icon is available only if a datasource object is active.


Set Table Relationship icon

Displays the Set Relationship dialog box.  This icon is available only when there is more than one table in the Datsource panel to relate.


Show SQL icon

Displays the Show SQL dialog box and the SQL for the active query.


Column Sequence icon

Displays the Display dialog box.


Define Column icon

Displays the Define Column dialog box.


Sort icon

Displays the Sort dialog box.


And icon

Inserts the AND operator into your condition.  This icon is available only when the Condition field is active.  You can also type AND directly into the Condition field.


Or icon

Inserts the OR operator into your condition.  This icon is available only when the Condition field is active.  You can also type OR directly into the Condition field.


Not icon

Inserts the NOT operator into your condition to negate your condition.  This icon is available only when the Condition field is active.  You can also type NOT directly into the Condition field.


Ungroup Conditions icon

Ungroups conditions that are combined with logical operators, such as AND, OR, NOT.  This icon is available only when you have selected a logical operator in the Conditions panel.


Accept icon

Validates and accepts the active condition.  This icon is available only when the Condition field is active.  You can also press the Enter or Return key when the Condition field is active to accept and validate your condition.


Cancel icon

Cancels the current condition.  This icon is available only when the Condition field is active.


Paste Column icon

Displays the Paste Column dialog box.  This icon is available only when the Condition field is active.


Paste Function icon

Displays the Paste Function dialog box.  This icon is available only when the Condition field is active.


About datatypes

  Related Topics

The most common datatypes in Query Builder are:

CHAR or VARCHAR2	CHAR is used for fixed length character data, to a maximum size of 255 bytes and a default size of 1 byte.  VARCHAR2 is for variable length character strings to a maximum size of 2000 bytes.  You must specify size for VARCHAR2.
NUMBER	NUMBER indicates that the database column contains numbers (integers, decimals, or any other type of numeric values).  You can perform calculations on numbers represented in the NUMBER datatype, but not on numbers represented by the CHAR datatype.
DATE	DATE indicates that the database column contains date values.  Valid dates ranging from January 1, 9999 BC to December 31, 9999 AD.  Default format is DD-MON-YY as in '01-JAN-92'.
NUMBER(p,s)	The range of p (decimal precision) is 1 to 38. The range of s (scale) is -84 to 127.  Decimal precision is the number of digits to store.  The scale is the number of digits to the right of the decimal point.  If the scale is negative, the actual data is rounded to the specified number of places to the left of the decimal point.  For example, a specification of (10, -2) means round to the hundreds.
Additionally, Query Builder provides limited support for the following Oracle datatypes:

LONG	A LONG column contains alphanumeric data of variable length up to 2 gigabytes (or 231-1).  When you include a LONG column in a Query Builder query, the first 2000 characters are displayed.
RAW	Raw binary data.  Maximum size is 255 bytes.  Values must be inserted as character strings in hexadecimal notation.  Values are displayed in hexadecimal.  You must specify size for RAW datatypes.
LONG RAW	LONG RAW displays raw binary data up to 2 gigabytes (this appears in hexadecimal in the Results window).  LONG RAW datatypes are subject to the same limits as RAW datatype.
Note:  Query Builder supports datatype conversions in cases where conditions and expressions reference different datatypes in their comparison.  Refer to the Oracle8 Server SQL Language Reference Manual for additional information.


Datatype icons

  Related Topics

The following supported datatypes for all the columns in a datasource object are represented by icons located in the right hand column of the object in the Query Builder workspace.

Datatype	Icon	Description
Character		Use the Character datatype for fixed length character data, to a maximum size of 255 bytes and a default size of 1 byte. Note:  You can represent numbers using the Character datatype, but you can only perform calculations with numeric datatypes.
Varchar2		Use the Varchar2 datatype for variable length character strings, to a maximum size of 2000 bytes.  You must specify a size for the Varchar2 datatype.
Number		Use the Number datatype for integer or floating data. You must enter a precision length (number of digits) for integer data. Floating datatype is for decimal numbers. When you assign this datatype to a column, you must specify both the precision and the scale. The precision (total number of digits in the number) can range from 1 to 38.  The scale (number of digits to the right of the decimal point) can range from -84 to 127.  If the scale is negative, the actual data is rounded to the specified number of places to the left of the decimal point.  For example, a specification of (10,2) means 10 digits with 2 to the right of the decimal point.  A specification of (10,-2) effectively means a 10-digit integer, rounded to the nearest hundred.
Date		Use the Date datatype for any type of date.  Valid dates range from January 1, 4712 BC to December 31,4712 AD.  The default date format is DD-MON-YY, as in ‘01-JAN-97.’
Long		Use the Long datatype for long text fields of alphanumeric data of variable length, up to 2 gigabytes.
Raw		Use the Raw datatype for raw binary data.  The maximum size is 255 bytes.  Values must be inserted as character strings in hexadecimal notation, and values are displayed in hexadecimal.  You must specify a size for raw data.
Long Raw		The Long Raw datatype is for storing up to 2 gigabytes of raw binary data (which is entered and displayed in hexidecimal form).  Long Raw datatypes do not require a specified size.
MLSLABEL		Use the MLSLABEL datatype for storing the binary format of a label used on a secure operating system.  Labels are used by Trusted ORACLE to mediate access to information.  You can also define columns with this datatype if you are using the standard ORACLE Server.  For more information on Trusted ORACLE, including this datatype and labels, see the Trusted ORACLE8 Server Administrator's Guide.


Datasource object notation

  Related Topics

Shown below is an example of two datasource objects, linked by a relationship.

Click any icon, indicator, or part of these objects to display a description.


Object type indicator

The icon in the upper left corner of any datasource object indicates its type:

  Table

  View

  Query

  Snapshot

  Synonym


Object title

This is the name of the datasource object.  You can change the name by clicking on the object title.


Comment indicator

This icon indicates that this object (or column) has a comment associated with it.  Double-click this icon to open the Info dialog box, where you can view the comments.


Column Name

This is the name of one of the columns in this object.  If you double-click a column name, the column will be included in your query.


Datatype indicators

These icons indicate the datatypes of their respective columns. If you click and hold on one of these icons, a pop-up menu appears, and you can choose a different datatype.


Relationship line

A gray line drawn between two columns indicates that a relationship has been created between the columns at either end of the line. The line is drawn from the foreign key to the primary key.


Self-relationship indicator

This icon indicates that a self-relationship has been created between this column (foreign key) and another column (primary key) in the same table.


Primary key

A column name displayed in boldface indicates that this column has been defined as a primary key for the object.


Foreign key

A column name displayed in italics indicates that this column is a foreign key, related to a primary key in another column.  Setting up a relationship between two columns is the only way to define a foreign key.


 Troubleshooting

This topic explains how to handle error messages and exceptions, and lists them in numeric sequence.  It covers the following topics:

handling error messages

abnormal conditions

Graphics Builder error messages

Graphics Builder exceptions

error message codes

calling Oracle customer support


Graphics Error Messages
Graphics Builder Error Messages

This section describes the Graphics Builder error messages.  The errors are listed in order by their error code number.

OG-00001:	Batch compilation error(s)

 Cause:	You tried to run a display in the PL/SQL debugger, but Graphics Builder detected an error while performing a batch compilation of the display's program units.

 Action:	Show the Batch Compiler, then correct the listed PL/SQL errors.

OG-00002:	Button procedure not found

 Cause:	You associated a button procedure with an object or a layer, but Graphics Builder could not find a procedure with that name.

 Action:	If the procedure does not exist, create it.  Also, verify that you typed the procedure name correctly.

OG-00005:	Program unit consistency error(s)

 Cause:	You tried to run a display that contains consistency errors.

 Action:	Show the Consistency Checker, and perform a consistency check.  Then correct the listed errors.

OG-00006:	Parameter truncation occurred

 Cause:	You assigned a value that is longer than 2000 bytes to a parameter of type CHAR.

 Action:	The maximum length of a CHAR parameter is 2000 bytes.

OG-00030:	Invalid program unit specification

 Cause:	You tried to apply a program unit that has an invalid specification.

 Action:	Insert a valid header, then try again.

OG-00032:	Duplicate PL/SQL program unit name

 Cause:	You tried to create a program unit with the same name as that of an existing program unit.

 Action:	Give your program units unique names.

OG-00057:	Trigger procedure not found

 Cause:	You associated a procedure with a trigger, but Graphics Builder could not find a procedure with that name.

 Action:	If the procedure does not exist, create it.  Also, verify that you typed the procedure name correctly.

OG-00064:	Program unit parameter extraction failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00066:	Database connection setting in PL/SQL failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00068:	Save of PL/SQL attached library list failed

 Cause:	Graphics Builder encountered an error while trying to save the list of attached PL/SQL libraries.

 Action:	If saving to a database, verify that the Graphics Builder tables are installed correctly.  If saving to a file, verify that you have write privileges, that you have not run out of disk space, and that no other situations exist in which you would not be able to write a file.

OG-00069:	Load of PL/SQL attached library list failed

 Cause:	Graphics Builder encountered an error while trying to load the list of attached PL/SQL libraries.

 Action:	If loading from a database, verify that the Graphics Builder tables are installed correctly.  If loading from a file, verify that you have read privileges, that you have access to the libraries in question (e.g., they are in the current directory or the directory specified by the ORAPLSQLLOADPATH environment variable), and that no other situations exist in which you would not be able to read a file.

OG-00070:	Delete of PL/SQL attached library list failed

 Cause:	Graphics Builder encountered an error while trying to delete the list of attached PL/SQL libraries.

 Action:	Verify that the Graphics Builder tables are installed correctly.

OG-00071:	Display contains uncompiled program unit(s)

 Cause:	You tried to run a display that contains program units that have not been compiled.

 Action:	Compile all of the program units, then save or generate the display before running it.

OG-00072:	Program unit load failed

 Cause:	Graphics Builder encountered an error while trying to load a program unit.

 Action:	Verify that all database tables or other program units that the program unit references are accessible, and that the Graphics Builder tables are installed correctly.

OG-00076:	One or more PL/SQL program units is too big for encoding

 Cause:	You tried to save a display that contains one or more program units that exceed the maximum contiguous memory size allowed for your system.

 Action:	Break your large program units into smaller ones.  For more information on your system's memory constraints, see the Graphics Builder documentation for your operating system.

OG-00078:	Unable to create breakpoints.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00079:	Runtime simulation aborted.

 Cause:	You canceled an operation before entering runtime simulation.

OG-00077:	One or more PL/SQL program units is too big to be decoded

 Cause:	You tried to open a display that contains one or more program units that exceed the maximum contiguous memory size allowed for your system.

 Action:	Open the display on the system on which it was created, and break your large program units into smaller ones.  For more information on your system's memory constraints, see the Graphics Builder documentation for your operating system.

OG-00401:	No timer name specified

 Cause:	You tried to apply changes in the Timer Triggers dialog box, but the selected timer's name in the Rename text field is blank.

 Action:	Type a name in the Rename text field, or delete the timer.

OG-00402:	Duplicate timer name specified

 Cause:	You tried to apply changes in the Timer Triggers dialog box, but the selected timer's name is the same as that of another timer.

 Action:	Give the timer a unique name by typing it in the Rename text field.

OG-00403:	Duplicate document name specified

 Cause:	You tried to do one of the following in a single Graphics Builder session:

A.	Open a display in the Builder that is already open in the Builder.

B.	Open a display in runtime simulation that is already open in runtime simulation.

C.	Open a display in the Runtime executable that is already open in the Runtime executable.

 Action:	In a single Graphics Builder session, you can perform one of the above Open operations on a specific display only once.

OG-00406:	No sound name specified

 Cause:	You tried to apply changes in the Sounds dialog box, but the selected sound's name in the Rename text field is blank.

 Action:	Type a name in the Rename text field, or delete the sound.

OG-00407:	Duplicate sound name

 Cause:	You tried to apply changes in the Sounds dialog box, but the selected sound's name is the same as that of another sound.

 Action:	Give the sound a unique name by typing it in the Rename text field.

OG-00408:	Timer interval of zero specified

 Cause:	You tried to apply changes in the Timer Triggers dialog box, but the selected timer's interval is set to 0 minutes and 0 seconds.

 Action:	Type valid numbers in the Interval text fields, or delete the timer.

OG-00409:	No procedure specified for timer

 Cause:	You tried to apply changes in the Timer Triggers dialog box, but the selected timer's trigger procedure in the Procedure text field is blank.

 Action:	Type the name of a PL/SQL trigger procedure in the Procedure text field, or delete the timer.

OG-00410:	Could not create timer

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00411:	Designer display not found.

 Cause:	You tried to synchronize program units from a runtime simulation display to the Builder display, but the Builder display could not be found.

 Action:	Ensure the Builder display is open, and that you have not changed its name since running it.

OG-00412:	More than one node is selected.

 Cause:	You selected multiple nodes in the Object Navigator, and then attempted an operation that requires that only one node is selected.

 Action:	Select only one node, then try again.

OG-00413:	No display is selected.

 Cause:	You attempted an operation that requires that a display is selected, but no display is selected.

 Action:	Select a display, then try again.

OG-00414:	This display is already running.

 Cause:	You attempted to run a display in runtime simulation, but that display is already running.

 Action:	Select another display, or close the display that is running.

OG-00415:	Duplicate parameter name specified.

 Cause:	You attempted to create a parameter with a name already in use by another parameter.

 Action:	Use a unique name for the parameter.

OG-00416:	No parameter name specified.

 Cause:	You attempted to create a parameter, but you did not specify its name.

 Action:	Specify a name for the parameter.

OG-00505:	List count error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00507:	Invalid query type

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00508:	Chart template not found

 Cause:	You tried to update a chart, but the chart template on which it is based could not be found.  The possible causes of this error include:

A.	You deleted the chart template.

B.	You renamed the chart template.

 Action:	You can change the template on which the chart is based by selecting a new template in the chart's Chart Properties dialog box.  In addition, you can take the following action(s) to correct this error:

If A.	Create a new chart template with the same name as the deleted template.

If B.	Rename the chart template so it matches the name expected by the chart.

OG-00511:	No chart template specified

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00512:	No query specified

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00513:	Query has no data.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00514:	No document pointer specified

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00516:	Communications context load failure

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00517:	Communications interface load failure

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00518:	Inter-product data transmission failed

 Cause:	Another Oracle product invoked Graphics Builder and requested that Graphics Builder provide it with the contents of a display, but Graphics Builder encountered an error while trying to communicate with that product.

 Action:	Verify that Graphics Builder was invoked in the synchronous communication mode.  Also, verify that a system error did not occur that would prevent the products from communicating with each other.

OG-00519:	Date to string conversion failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00520:	Integration error - <message>

 Cause:	An error occurred while trying to integrate with another product.

 Action:	Review the error message returned, then refer to the documentation for the other product.

OG-00521:	Help not initialized.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00522:	Invalid printer name.

 Cause:	An error occurred while trying to locate a printer.

 Action:	Verify that the printer is connected and working.

OG-00524:	No query name specified.

 Cause:	You attempted to create a query, but you did not specify its name.

 Action:	Specify a name for the query.

OG-00525:	Duplicate query name specified.

 Cause:	You attempted to create a query with a name already in use by another query.

 Action:	Use a unique name for the query.

OG-00528:	Duplicate column name.

 Cause:	You attempted to create a column with a name already in use by another column.

 Action:	Use a unique name for the column.

OG-00529:	No column name specified.

 Cause:	You attempted to create a column, but you did not specify its name.

 Action:	Specify a name for the column.

OG-00532:	Cannot update chart while update in progress.

 Cause:	You attempted to update a chart while it is already being updated.  Most likely, you attempted operation within a chart-related trigger that causes another chart update.

 Action:	Verify that you are not doing anything that will update the chart while it is already being updated.

OG-00533:	Drill-down parameter does not exist.

 Cause:	Graphics Builder tried to set a parameter used by a drill-down chart, but the parameter does not exist.

 Action:	Verify that the parameter exists, and is correctly assigned to the chart.

OG-00602:	Accept of program unit failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00604:	Cancel of program unit failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00608:	Unable to execute PL/SQL procedure

 Cause:	Graphics Builder encountered an error while trying to execute a PL/SQL procedure.

 Action:	Make sure the procedure has not been uncompiled inadvertently.

OG-00609:	Internal PL/SQL execution error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00622:	Invalid parameter position

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00630:	Internal PL/SQL library attach failure

 Cause:	Graphics Builder encountered an error while trying to attach an internal library.

 Action:	If the display is stored in the database, verify that the Graphics Builder tables are installed correctly.  If the display is stored in a file, verify that the file your are trying to open is a valid display file.

OG-00632:	Internal PL/SQL library insert error

 Cause:	Graphics Builder encountered an error while trying to insert a program unit into a library.

 Action:	If the display is stored in the database, verify that the Graphics Builder tables are installed correctly.  If the display is stored in a file, verify that your file system has enough free space.

OG-00633:	Internal PL/SQL library deletion failure

 Cause:	Graphics Builder encountered an error while trying to delete an internal library.

 Action:	Verify that the Graphics Builder tables are installed correctly.

OG-00637:	Unhandled PL/SQL exception <exception_number>

 Cause:	Graphics Builder encountered a PL/SQL exception while executing a program unit.

 Action:	Take note of the exception number listed at the end of the error message, then refer to the following table for more information about the exception:

Exception range	Exception type	Refer to

----------------------------------------------------------------------------------------

0-99999	Oracle/PL/SQL	Oracle7 Server Messages

and Codes Manual

102000-102499	Graphics Builder built-in	PL/SQL Exceptions

104500-104999	TOOL_INT package	PL/SQL Exceptions

105000-105499	TOOL_RES package	Oracle Procedure Builder

Developer's Guide

105500-105999	ORA_NLS package	Oracle Procedure Builder

Developer's Guide

300000-300499	DEBUG package	Oracle Procedure Builder

Developer's Guide

300500-300999	LIST package	Oracle Procedure Builder

Developer's Guide

302000-302499	TOOL_ERR package	Oracle Procedure Builder

Developer's Guide

302500-302999	TEXT_IO package	Oracle Procedure Builder

Developer's Guide

OG-00801:	Data query execution error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00802:	SQL query execution error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-00901:	Invalid parameter name entered

 Cause:	You typed an invalid parameter name in the Name column of the Parameter Table.

 Action:	Use a valid parameter name.

OG-00902:	Invalid parameter type entered

 Cause:	You typed an invalid parameter type in the Type column of the Parameter Table.

 Action:	Type one of the following valid parameter types: CHAR, DATE, or NUMBER.

OG-00903:	Invalid parameter value entered

 Cause:	You typed an invalid parameter value in the Value column of the Parameter Table.

 Action:	Type a value that is valid for the parameter type you specified.

OG-01001:	Unable to find expected resource.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01002:	Unable to find expected resource.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01103:	High-level sound dialog failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01105:	Unable to load display

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01106:	Record cache read initialization failure

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01107:	Sound conversion failed

 Cause:	You tried to import or create a sound, but the conversion of the sound from its original sample rate and encoding scheme failed.  This is most likely to happen if your sound is too large.

 Action:	Import or create a smaller sound.

OG-01108:	Unable to read from sound import file

 Cause:	You tried to import a sound, but the file to be imported does not contain valid sound data.

 Action:	Verify that the file contains valid sound data.

OG-01109:	Could not create cursor.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01110:	Could not find printer.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01301:	Unable to open data file

 Cause:	You tried to execute a query that retrieves its data from a file, but Graphics Builder could not open the file.  The possible causes of this error include:

A.	The file does not exist.

B.	You do not have the necessary privileges to open the file.

C.	A system error prevented Graphics Builder from opening the file.

 Action:	You can take the following action(s) to correct this error:

If A.	Create the necessary file.

If B.	Change-or have your system administrator change-your privileges accordingly.

If C.	Consult your system documentation or contact your system administrator.

OG-01304:	Unable to create cache for data.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01305:	Invalid SYLK data file format

 Cause:	You defined a query to reference a SYLK file, but the specified file is not in that format.

 Action:	Verify that you specified the correct format and file.

OG-01306:	Invalid PRN data file format

 Cause:	You defined a query to reference a PRN file, but the specified file is not in that format.

 Action:	Verify that you specified the correct format and file.

OG-01307:	Invalid WKS data file format

 Cause:	You defined a query to reference a WKS file, but the specified file is not in that format.

 Action:	Verify that you specified the correct format and file.

OG-01601:	Unable to create cax at startup

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01603:	Unable to create DE context

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01604:	Unable to create DE UI context

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01605:	Unable to create main layout window

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01606:	Unable to startup resource manager

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01607:	Unable to init ZOM.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01610:	Unable to create PL/SQL batch compiler

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01613:	Unable to create PL/SQL editor window

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01614:	PL/SQL program unit creation failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01615:	Unable to create DE execution context

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01616:	Unable to create cav at startup

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01617:	Unable to create non-modal interpreter

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01618:	Unable to create modal interpreter

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01619:	Could not initialize error handler

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01620:	Could not initialize object store

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01621:	Could not initialize Oracle Image

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01622:	Could not initialize Oracle Sound

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01623:	Could not initialize Oracle Help

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01625:	Could not set batch window attributes

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01626:	Too many arguments for command line option

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01627:	Duplicate specification for command line option

 Cause:	You invoked a Graphics Builder executable from a command line and passed it command line arguments, but you used the same command line keyword more than once.

 Action:	You can specify a command line keyword no more than once in a single command line.  To specify multiple values for a keyword, use a value list.

For more information, see "Value Lists" in the chapter "Executables" of the Graphics Builder Reference Manual.

OG-01629:	Positional input after command line keyword

 Cause:	You invoked a Graphics Builder executable from a command line and specified a keyword and its value, followed by a value with no keyword.

 Action:	If you use a keyword on a command line, you must use keywords in all subsequent command line arguments.  You may omit keywords only if their values are listed in the order specified by the executable's syntax, and if they do not follow another command line argument that explicitly uses its keyword.

OG-01630:	Invalid value for command line option

 Cause:	You invoked a Graphics Builder executable from a command line and specified an invalid value for a command line keyword.

 Action:	You must specify valid command line values.

For more information, see "Value Lists" in the chapter "Executables" of the Graphics Builder Reference Manual.

OG-01631:	Improperly-formed list in command line

 Cause:	You invoked a Graphics Builder executable from a command line and specified multiple values for a command line keyword; however, the value list is improperly formed.

 Action:	You must surround a value list with parentheses, and place a comma between each value.  Note that your system may have special restrictions on using parentheses and commas on a command line.

For more information, see "Value Lists" in the chapter "Executables" of the Graphics Builder Reference Manual.

OG-01632:	Illegal list input in command line

 Cause:	You specified a list of values for an executable keyword for which multiple values are not allowed.

 Action:	Do not specify multiple values for keywords that accept only one value.

OG-01633:	Command file not found

 Cause:	Graphics Builder could not find the command file specified by the CMDFILE executable keyword.

 Action:	Verify that the file exists and is in a readable format.

OG-01635:	Could not create PL/SQL browser

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01636:	Could not create library browser

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01638:	SQLLIB initialization failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01639:	Tools integration initialization failed

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01640:	Unable to create data table window

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01641:	Unable to create parameter table window

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01643:	Unable to create chart template window.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01644:	Unable to create data table window.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01642:	Unable to create chart template window

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01901:	Generic object store error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01902:	Cannot find layer to be saved.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01903:	Unexpected empty layer list in layout view

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01904:	Could not open the database store

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-01905:	Cannot fetch user name.

 Cause:	Graphics Builder encountered an error while trying to resolve an unknown or unspecified username by requesting resolution from the server.  For example, if you do not enter a username in the Connect dialog box, Graphics Builder asks the server to resolve an OPS$ username.

 Action:	Verify that the username is registered and appears in the USER_USERS table.

OG-02205:	These objects do not belong to the same group.

 Cause:	You tried to simultaneously select two objects that are not children of the same group object.

 Action:	You can select multiple objects only if they are members of the same group.

OG-02207:	Must select exactly one group.

 Cause:	You selected one or more single objects, or more than one group object, and then attempted to ungroup, select the children, or an an object to a group.

 Action:	These operations require that exactly one group object be selected.

OG-02212:	Object selected is not a group.

 Cause:	You selected a single object, then attempted to selecte its children.

 Action:	By definition, a single object has no children.  This operation requires that you select exactly one group object.

OG-02213:	Object has no parent.

 Cause:	You selected an object, then attempted to select its parent, but the object is not a member of a group, and therefore has no parent.

 Action:	You can select the parent only of an object that is a member of a group.

OG-02215:	Object is not editable

 Cause:	You selected the Reshape tool, then clicked on a control point of an object that cannot be reshaped.

 Action:	You cannot reshape a symbol, chart, or group object.

OG-02313:	Select exactly one image to export.

 Cause:	You tried to export an image, but there are either no images or more than one image selected.

 Action:	Select only one image to export.

OG-02502:	Cannot find file or cannot read file.

 Cause:	You tried to open a file, but Graphics Builder could not find or read the file.  The possible causes of this error include:

A.	The file does not exist.

B.	You do not have the necessary privileges to open the file.

C.	A system error prevented Graphics Builder from opening the file.

 Action:	You can take the following action(s) to correct this error:

If A.	Create the necessary file.

If B.	Change-or have your system administrator change-your privileges accordingly.

If C.	Consult your system documentation or contact your system administrator.

OG-02503:	Cannot open file for writing.

 Cause:	You tried to write to a file, but Graphics Builder encountered an error.  The possible causes of this error include:

A.	You do not have the necessary privileges to write to the file.

B.	A system error prevented Graphics Builder from writing the file.

 Action:	You can take the following action(s) to correct this error:

If A.	Change-or have your system administrator change-your privileges accordingly.

If B.	Consult your system documentation or contact your system administrator.

OG-02505:	Cannot open database store. Database may not be configured properly.

 Cause:	Graphics Builder encountered an error while trying to store a module in the database (e.g., save a display, export a drawing, etc.).

 Action:	Verify that you have the necessary access privileges to store data in the Graphics Builder tables.

OG-02506:	Cannot print.  Check printer settings.

 Cause:	Graphics Builder encountered an error while trying to print.

 Action:	Verify that your printer and printing environment are configured correctly.  For more information, refer to your system documentation.

OG-02507:	Cannot open file or file is not in the format specified.

 Cause:	You tried to import a file, but either Graphics Builder encountered an error while trying to open the file, or the file is not in the specified format.

 Action:	Verify that you can access the file, and that it is in the correct format.

OG-02508:	Cannot find document in database.

 Cause:	You tried to open a module that is stored in the database, but Graphics Builder could not find a module with that name.

 Action:	Verify that the module you specified exists in the database, and that the current user has the appropriate privileges.

OG-02701-2718:	Error while reading CGM file.

 Cause:	You tried to import a CGM file, but Graphics Builder encountered an error while trying to read it.  It is likely that the file is either damaged, or it is not a valid CGM file.

 Action:	Verify that the file is a valid CGM file.

OG-02801-2806:	File I/O error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-03003:	Cannot display image.

 Cause:	You are attempting to open a display containing an image within the Builder, but you do not have sufficient memory to display the image.

 Action:	Save your display and quit Graphics Builder, then, if possible, free up memory and try again.  For information on memory requirements, see the Graphics Builder documentation for your operating system.

OG-03101:	Oracle Toolkit error

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-03501:	Cannot find resource file.  Check your environment settings.

 Cause:	Graphics Builder could not locate a necessary resource file.

 Action:	Verify that your environment settings are correct.  For more information, see the Graphics Builder documentation for your operating system.

OG-03507:	Cannot find color palette file.  Check your environment settings.

 Cause:	Graphics Builder could not locate the default color palette file named vgid.ros.

 Action:	Verify that your environment settings are correct.  For more information, see the Graphics Builder documentation for your operating system.

OG-03701-3702:	Not enough memory.

 Cause:	Graphics Builder ran out of memory.

 Action:	Save your display and quit Graphics Builder.  For information on memory requirements, see the Graphics Builder documentation for your operating system.

OG-03704:	Object store error.

 Cause:	This is an abnormal condition.

 Action:	For more information, see Abnormal Conditions.

OG-03800-3812:	Could not write CGM file.

 Cause:	You tried to export a drawing as CGM, but Graphics Builder encountered an error.  The possible causes of this error include:

A.	You do not have the necessary privileges to write to the file.

B.	A system error prevented Graphics Builder from writing the file.

 Action:	You can take the following action(s) to correct this error:

 	If A.	Change-or have your system administrator change-your privileges accordingly.

If B.	Consult your system documentation or contact your system administrator.

OG-04002:	Column not found in query data.

 Cause:	You created a chart based on a query that contained certain data columns, then you changed the query such that one or more of those columns were no longer present.  When you tried to update the chart, it looked for those columns, but couldn't find them.

 Action:	Update the chart's field mapping so that it plots only columns that exist in the query.

OG-04003:	User-specified axis minimum/maximum/step is invalid.

 Cause:	You entered a Minimum axis value that is greater than the Maximum value.

 Action:	Enter a Minimum value that is less than the Maximum, or select Auto for one or both values.

OG-04005:	Cannot plot negative value in stacked data.

 Cause:	The Plot Position of a field in the chart is set to Stacked, but the query contains negative data.

 Action:	You can plot only positive data values in a Stacked chart.

OG-04006:	Cannot plot negative or zero data in log chart.

 Cause:	You created an axis chart in which one of the axes uses a logarithmic scale, but the field that maps to that axis contains negative data values.

 Action:	You can plot only positive data values in along a logarithmic axis.

OG-04007:	Cannot plot negative data in percent chart.

 Cause:	The query on which a percent chart is based contains negative data values.

 Action:	You can plot only positive data values in a percent chart.

OG-04008:	Zero sum/minimum/maximum in percent chart.

 Cause:	You created a chart whose data values are plotted as a percentage of the sum/minimum/maximum of all data values, but the sum/minimum/maximum is zero.

 Action:	A percentage cannot be computed if the sum/minimum/maximum is zero.

OG-04010:	Cannot plot negative data in pie chart.

 Cause:	The query on which a pie chart is based contains negative data values.

 Action:	You can plot only positive data values in a pie chart.

OG-04011:	Sum of data greater than total value specified.

 Cause:	You specified a Total Value for the pie chart that is less than the query's actual sum of data.

 Action:	Set the Total Value for the pie chart to be greater than or equal to the actual sum of data returned by the query.

OG-04012:	Data overflow:: try a different axis precision.

 Cause:	You created or updated a chart that contains a date axis, but the range of its data is too big.   For example, if the data spans many years, and the axis step size is seconds, this error occurs.

 Action:	Set the axis step size to a larger unit, resulting in fewer subdivisions of the axis.

OG-04013:	Legend columns cannot be zero.

 Cause:	You set the number of columns that appear in the legend to 0.

 Action:	Set the number of columns that appear in the legend to at least 1.

OG-04014:	No data available to chart.

 Cause:	You tried to update a chart whose associated query has not been executed.  This can happen if the query references the database, but the database is not connected, or if a SYLK, WKS, or PRN file cannot be found.

 Action:	Verify the database is connected or the file exists.

OG-04015:	Too many rows of data.

 Cause:	You tried to execute a query, but the query returned more rows of data than Graphics Builder can process on your system.

 Action:	Limit your query so that fewer rows are returned.


About PL/SQL built-in exceptions

This section describes all of the Graphics Builder built-in exceptions.  The exceptions are first listed by their error codes, then each one is described completely.  The syntax, description, and error message are provided for each.

If unhandled, each exception will temporarily stop the display execution and raise the listed error message.  After the message is raised and you accept it, the display execution will continue.

For information about scoping rules and propagation of exceptions, see the PL/SQL User's Guide and Reference.


Exceptions by error code

  Related Topics

Description

Error Code	Exception Name
102000	OG_Internal_OG_Error
102001	OG_Internal_Tk_Error
102002	OG_Invalid_Window_Dimensions
102003	OG_Invalid_Object_Handle
102004	OG_Invalid_Query_Handle
102005	OG_Invalid_Template_Handle
102006	OG_Invalid_Buttonproc_Handle
102007	OG_Invalid_Sound_Handle
102008	OG_Invalid_Window_Handle
102009	OG_Invalid_Layer_Handle
102010	OG_Invalid_Timer_Handle
102011	OG_Invalid_Display_Handle
102012	OG_Layer_Not_Child_Of_Root
102013	OG_Hide_Active_Layer
102014	OG_Parent_Not_Group
102015	OG_Invalid_Color_Name
102016	OG_Invalid_Pattern_Name
102017	OG_Invalid_Join_Style
102018	OG_Invalid_Cap_Style
102019	OG_Invalid_Dash_Style
102020	OG_Invalid_Object_Type
102021	OG_Root_Object_Destruction
102022	OG_Invalid_Arrowstyle
102023	OG_Invalid_Symbol_Index
102024	OG_Invalid_Symbol_Size
102025	OG_Invalid_Text_Spacing
102026	OG_Invalid_Text_Horalign
102027	OG_Invalid_Text_Horjust
102028	OG_Invalid_Text_Vertalign
102029	OG_Invalid_Text_Vertjust
102030	OG_Open_Display_Failure
102031	OG_Invalid_Child_Index
102032	OG_Invalid_Child_Del_Total
102033	OG_Invalid_Point_Index
102034	OG_Active_Layer_Del
102035	OG_Invalid_Point_Del_Total
102036	OG_Invalid_Cmptext_Index
102037	OG_Invalid_Cmptext_Del_Total
102038	OG_Invalid_Smptext_Index
102039	OG_Invalid_Smptext_Del_Total
102040	OG_Invalid_Field_Index
102041	OG_Invalid_Field_Del_Total
102042	OG_Invalid_Data_Flag
102043	OG_Column_Type_Mismatch
102044	OG_Invalid_Column_Name
102045	OG_Invalid_Field_Type
102046	OG_Main_Window_Destruction
102047	OG_Invalid_Cursor_Offset
102048	OG_Invalid_Userexit_Invocation
102049	OG_Userexit_Failure_Error
102050	OG_Userexit_Fatal_Error
102051	OG_Userexit_Unknown_Error
102052	OG_Invalid_Chart_Update_Mask
102053	OG_Invalid_Row_Number
102054	OG_Invalid_Chart_Creation_Attr
102055	OG_No_Database_Connection
102056	OG_Invalid_External_Location
102057	OG_Invalid_Transfer_Mode
102058	OG_Invalid_Event_Mask
102059	OG_Host_Failure_Error
102060	OG_Invalid_Bbox
102061	OG_Not_Chart_Object
102062	OG_Not_Group_Object
102063	OG_Not_Polygon_Object
102064	OG_Not_Image_Object
102065	OG_Not_Text_Object
102066	OG_Invalid_Arc_Fill
102067	OG_Invalid_Field_Template
102068	OG_Missing_Chart_Field
102069	OG_Invalid_Field_Datatype
102070	OG_Invalid_Data_Value
102071	OG_Pctchart_Zero
102072	OG_No_Dependent_Fields
102073	OG_Piechart_Sum_Overflow
102074	OG_Date_Overflow
102075	OG_Query_Execution_Error
102076	OG_Sql_Execution_Error
102077	OG_Invalid_Data_File
102078	OG_Invalid_Sylk_Format
102079	OG_Invalid_Prn_Format
102080	OG_Invalid_Wks_Format
102081	OG_Row_Retrieval_Failure
102082	OG_Invalid_Image_Format
102083	OG_Image_Creation_Failure
102084	OG_Invalid_Sound_Format
102085	OG_Login_Failure
102086	OG_Logoff_Failure
102087	OG_Image_Export_Failure
102088	OG_Sound_Export_Failure
102089	OG_Invalid_Drawing_Format
102091	OG_Drawing_Export_Failure
102092	OG_Template_Export_Failure
102093	OG_Image_Import_Failure
102094	OG_Sound_Import_Failure
102095	OG_Drawing_Import_Failure
102096	OG_Template_Import_Failure
102097	OG_Colors_Not_Writable
102098	OG_Font_Not_Found
102099	OG_Invalid_Column_Index
102100	OG_Logon_Disallowed
102101	OG_Logoff_Disallowed
102102	OG_Env_Var_Error
102103	OG_Env_Var_Notfound
102104	OG_Save_Display_Failure
102105	OG_Generate_Display_Failure
102106	OG_Duplicate_Display_Name
102107	OG_Invalid_Query_Source
102108	OG_Invalid_Date_Format
102109	OG_Invalid_Query_Type
102110	OG_Null_Module_Name
102111	OG_Print_Failure
102112	OG_Invalid_Timer_Procedure
102113	OG_Invalid_Timer_Interval
102114	OG_No_Chart_Data
102115	OG_Display_Closed
102116	OG_Invalid_Child_Object
102117	OG_No_Sound_Output_Device
102118	OG_No_Sound_Input_Device
102119	OG_Too_Many_Data_Rows
102120	OG_Sound_Conversion_Failure
102121	OG_Invalid_Compression_Type
102122	OG_Invalid_Axis_Handle
102123	OG_Invalid_Refline_Handle
102124	OG_Invalid_Ftemp_Index
102125	OG_Invalid_Ftemp_Del_Total
102126	OG_Invalid_Template_Type
102127	OG_Invalid_Refline_Index
102128	OG_Invalid_Refline_Del_Total
102129	OG_Invalid_Invalid_Depthsize
102130	OG_Invalid_Shadowsize
102131	OG_Invalid_Shadowdir
102132	OG_Invalid_Baselinetype
102133	OG_Invalid_Datevalue
102134	OG_Invalid_Axis_Mapping
102135	OG_Invalid_Catwidth
102136	OG_Invalid_Pie_Usage
102137	OG_Invalid_Pie_Usagevalue
102138	OG_Invalid_Number_Format
102139	OG_Invalid_Min_Max
102140	OG_Invalid_Axistype
102141	OG_Incompatible_Pos_Dir
102142	OG_Invalid_Position
102143	OG_Invalid_Direction
102144	OG_Invalid_Tickpos
102145	OG_Invalid_Step
102146	OG_Invalid_Scale
102147	OG_Invalid_Pct_Of
102148	OG_Invalid_Pct_By
102149	OG_Invalid_Month
102150	OG_Invalid_Labelrot
102151	OG_Invalid_Plotpos
102152	OG_Invalid_Overlap
102153	OG_Invalid_Baseline_Value
102154	OG_Invalid_Minimum
102155	OG_Invalid_Gridct
102156	OG_Duplicate_Ftemp_Name
102157	OG_Duplicate_Template_Name
102158	OG_Invalid_Curvefit
102159	OG_Invalid_Linestyle
102160	OG_Get_Printer_Failure
102161	OG_Set_Printer_Failure
102162	OG_Set_Object_Prop_Failure
102163	OG_Get_Object_Prop_Failure
102164	OG_Delete_Object_Prop_Failure
102165	OG_No_Schema
102166	OG_Get_Append_Failure
102167	OG_Column_Not_Settable
102168	OG_Insert_Column_Failure
102169	OG_Delete_Column_Failure
102170	OG_Invalid_Cachetype
102171	OG_Duplicate_Query_Name
102172	OG_Duplicate_Column_Name
102173	OG_No_Query_Name
102174	OG_Set_Param_Error
102175	OG_Get_Param_Error
102176	OG_Delete_Param_Error
102178	OG_Undefined_Param
102179	OG_Get_Property_Error
102180	OG_Set_Property_Error
102181	OG_Delete_Property_Error
102182	OG_Undefined_Property
102183	OG_Not_Supported_In_Designer
102184	OG_Not_Chart_Element
102185	OG_Recursive_Chart_Update
102186	OG_No_Independent_Fields
102187	OG_Null_Chart_Element
104500	Tool_Int.Internal_Tools_Error
104501	Tool_Int.Invalid_Parameter_Type
104502	Tool_Int.Invalid_Product
104503	Tool_Int.Invalid_Location
104504	Tool_Int.Duplicate_Parameter_List_Name
104505	Tool_Int.Invalid_Parameter_List_Name
104506	Tool_Int.Invalid_Parameter_List_Handle
104507	Tool_Int.Invalid_Parameter_Key
104508	Tool_Int.Duplicate_Parameter_Key
104509	Tool_Int.Run_Product_Failure
104510	Tool_Int.Invalid_Execution_Mode
104511	Tool_Int.Invalid_Communication_Mode


Exceptions by name

  Related Topics

Syntax

Exceptions By Name EXCEPTION;


OG_Active_Layer_Del

  Related Topics

Description	This exception is raised when the currently active layer is used as an argument to OG_Destroy.

Syntax

OG_Active_Layer_Del EXCEPTION;

Error Code	 102034


 OG_Append_Failure

  Related Topics

Description	This exception is raised when an error occurs while trying to append data to a custom query.

Syntax

OG_Append_Failure EXCEPTION;

Error Code	 102166


  OG_Column_Not_Settable

  Related Topics

Description	This exception is raised when you attempt to modify the schema of a query column, but the query is not a custom query.

Syntax

OG_Column_Not_Settable EXCEPTION;

Error Code	 102167


OG_Colors_Not_Writable

  Related Topics

Description	This exception is raised when you set call OG_Import_Image and set the use_colors argument to TRUE, but the display's color palette is not editable.

Syntax

OG_Colors_Not_Writable EXCEPTION;

Error Code	 102097


OG_Column_Type_Mismatch

  Related Topics

Description	This exception is raised when the data returned by OG_Get_Charcell, OG_Get_Datecell, or OG_Get_Numcell is not of the type that is expected by that function.

Syntax

OG_Column_Type_Mismatch EXCEPTION;

Error Code	 102043


OG_Date_Overflow

  Related Topics

Description	This exception is raised when you call OG_Update_Chart and the chart contains a date axis, but the range of the data is too big.  For example, if the data spans many years, and the axis step size is seconds, this exception is raised.

Syntax

OG_Date_Overflow EXCEPTION;

Error Code	 102074


OG_Delete_Column_Failure

  Related Topics

Description	This exception is raised when you attempt to delete a column from a query.  You can delete columns only from custom queries.

Syntax

OG_Delete_Column_Failure EXCEPTION;

Error Code	 102169


OG_Delete_Object_Prop_Failure

  Related Topics

Description	This exception is raised when you attempt to delete a property from an object.

Syntax

OG_Delete_Object_Prop_Failure EXCEPTION;

Error Code	 102164


OG_Delete_Param_Error

  Related Topics

Description	This exception is raised when you attempt to delete a parameter.

Syntax

OG_Delete_Param_Error EXCEPTION;

Error Code	 102176


OG_Delete_Property_Error

  Related Topics

Description	This exception is raised when you attempt to delete a property from an object.

Syntax

OG_Delete_Property_Error EXCEPTION;

Error Code	 102181


OG_Display_Closed

  Related Topics

Description	This exception is raised when you attempt to perform an operation on a display after it has been closed via a call to OG_Close_Display.

Syntax

OG_Display_Closed EXCEPTION;

Error Code	 102115


OG_Drawing_Export_Failure

  Related Topics

Description	This exception is raised when OG_Export_Drawing encounters an error while attempting to export a drawing.

Syntax

OG_Drawing_Export_Failure EXCEPTION;

Error Code	 102091


OG_Drawing_Import_Failure

  Related Topics

Description	This exception is raised when OG_Import_Drawing encounters an error while attempting to import a drawing.

Syntax

OG_Drawing_Import_Failure EXCEPTION;

Error Code	 102095


OG_Duplicate_Column_Name

  Related Topics

Description	This exception is raised when you define a column in a custom query, but the column name is already used by another column.

Syntax

OG_Duplicate_Column_Name EXCEPTION;

Error Code	 102172


OG_Duplicate_Display_Name

  Related Topics

Description	This exception is raised when you call OG_Save_Display and set the name argument to be the same as that of another display that is open.

Syntax

OG_Duplicate_Display_Name EXCEPTION;

Error Code	 102106


OG_Duplicate_Ftemp_Name

  Related Topics

Description	This exception is raised when you create a field template, but another field template with that name already exists.

Syntax

OG_Duplicate_Ftemp_Name EXCEPTION;

Error Code	 102156


OG_Duplicate_Query_Name

  Related Topics

Description	This exception is raised when you create a query, but another query with that name already exists.

Syntax

OG_Duplicate_Query_Name EXCEPTION;

Error Code	 102171


OG_Duplicate_Template_Name

  Related Topics

Description	This exception is raised when you create a chart template, but another chart template with that name already exists.

Syntax

OG_Duplicate_Template_Name EXCEPTION;

Error Code	 102157


OG_Env_Var_Error

  Related Topics

Description	This exception is raised when OG_Translate_Envvar encounters an error while attempting to evaluate an environment variable.

Syntax

OG_Env_Var_Error EXCEPTION;

Error Code	 102102


OG_Env_Var_Notfound

  Related Topics

Description	This exception is raised when OG_Translate_Envvar tries to translate an environment variable, but that variable has not been defined for your system.

Syntax

OG_Env_Var_Notfound EXCEPTION;

Error Code	 102103


OG_Font_Not_Found

  Related Topics

Description	This exception is raised when you try to set a font using a font name that cannot be found on your system.

Syntax

OG_Font_Not_Found EXCEPTION;

Error Code	 102098


OG_Generate_Display_Failure

  Related Topics

Description	This exception is raised when OG_Generate_Display encounters an error while attempting to generate a display.

Syntax

OG_Generate_Display_Failure EXCEPTION;

Error Code	 102105


OG_Get_Object_Prop_Failure

  Related Topics

Description	This exception is raised when an error occurs while attempting to get an object property value.

Syntax

OG_Get_Object_Prop_Failure EXCEPTION;

Error Code	 102163


OG_Get_Param_Error

  Related Topics

Description	This exception is raised when an error occurs while attempting to get a parameter value.

Syntax

OG_Get_Param_Error EXCEPTION;

Error Code	 102175


OG_Get_Printer_Failure

  Related Topics

Description	This exception is raised when a you try to print, but Graphics Builder could not find the printer.

Syntax

OG_Get_Printer_Failure EXCEPTION;

Error Code	 102160


OG_Get_Property_Error

  Related Topics

Description	This exception is raised when an error occurs while attempting to get an object property value.

Syntax

OG_Get_Property_Error EXCEPTION;

Error Code	 102179


OG_Hide_Active_Layer

  Related Topics

Description	This exception is raised when the currently active layer is used as the argument for OG_Hide_Layer.  To deactivate a layer, make another layer active by using OG_Activate_Layer.

Syntax

OG_Hide_Active_Layer EXCEPTION;

Error Code	 102013


OG_Host_Failure_Error

  Related Topics

Description	This exception is raised when the built-in procedure OG_Host encounters an error while trying to execute a command on the host system.

Syntax

OG_Host_Failure_Error EXCEPTION;

Error Code	 102059


OG_Image_Creation_Failure

  Related Topics

Description	This exception is raised when you encounter an error while trying to create an image.

Syntax

OG_Image_Creation_Failure EXCEPTION;

Error Code	 102083


OG_Image_Export_Failure

  Related Topics

Description	This exception is raised when OG_Export_Image encounters an error while attempting to export an image.

Syntax

OG_Image_Export_Failure EXCEPTION;

Error Code	 102087


OG_Image_Import_Failure

  Related Topics

Description	This exception is raised when OG_Import_Image encounters an error while attempting to import an image.

Syntax

OG_Image_Import_Failure EXCEPTION;

Error Code	 102093


OG_Incompatible_Pos_Dir

  Related Topics

Description	This exception is raised when you specify an invalid axis direction or position.

Syntax

OG_Incompatible_Pos_Dir EXCEPTION;

Error Code	 102141


OG_Insert_Column_Failure

  Related Topics

Description	This exception is raised when you attempt to insert a column into a query.  You can insert columns only into custom queries.

Syntax

OG_Insert_Column_Failure EXCEPTION;

Error Code	 102168


OG_Internal_OG_Error

  Related Topics

Description	This exception is raised when a serious internal error occurs.  Contact your Oracle support representative.

Syntax

OG_Internal_OG_Error EXCEPTION;

Error Code	 102000


OG_Internal_Tk_Error

  Related Topics

Description	This exception is raised when a serious internal error occurs.  Contact your Oracle support representative.

Syntax

OG_Internal_Tk_Error EXCEPTION;

Error Code	 102001


OG_Invalid_Arc_Fill

  Related Topics

Description	This exception is raised when you use an invalid value when setting the fill style of an arc.

Syntax

OG_Invalid_Arc_Fill EXCEPTION;

Error Code	 102066


OG_Invalid_Arrowstyle

  Related Topics

Description	This exception is raised when you use an invalid value when setting the arrow style of a line.

Syntax

OG_Invalid_Arrowstyle EXCEPTION;

Error Code	 102022


OG_Invalid_Axis

  Related Topics

Description	This exception is raised when you specify an invalid axis value.  Valid values are OG_X_Axis, OG_Y1_Axis, and OG_Y2_Axis only.

Syntax

OG_Invalid_Axis EXCEPTION;

Error Code	 102140


OG_Invalid_Axis_Handle

  Related Topics

Description	This exception is raised when you attempt to reference an invalid axis handle.

Syntax

OG_Invalid_Axis_Handle EXCEPTION;

Error Code	 102122


OG_Invalid_Axis_Mapping

  Related Topics

Description	This exception is raised when you attempt to update a chart with an invalid axis mapping.

Syntax

OG_Invalid_Axis_Mapping EXCEPTION;

Error Code	 102134


OG_Invalid_Baselinetype

  Related Topics

Description	This exception is raised when you specify an invalid baseline type.

Syntax

OG_Invalid_Baselinetype EXCEPTION;

Error Code	 102132


OG_Invalid_Baseline_Value

  Related Topics

Description	This exception is raised when you specify an invalid baseline value.

Syntax

OG_Invalid_Baseline_Value EXCEPTION;

Error Code	 102153


OG_Invalid_Bbox

  Related Topics

Description	This exception is raised when you use an invalid value for the which_bbox argument in the built-in procedure OG_Update_Bbox.

Syntax

OG_Invalid_Bbox EXCEPTION;

Error Code	 102060


OG_Invalid_Buttonproc_Handle

  Related Topics

Description	This exception is raised when an attribute record used as an argument for a procedure contains an invalid value for the button procedure attribute.

Syntax

OG_Invalid_Buttonproc_Handle EXCEPTION;

Error Code	 102006


OG_Invalid_Cachetype

  Related Topics

Description	This exception is raised when you specify an invalid cachetype.  Valid values are OG_Append_Cachetype, OG_Copy_Cachetype, and OG_None_Cachetype only.

Syntax

OG_Invalid_Cachetype EXCEPTION;

Error Code	 102170


OG_Invalid_Cap_Style

  Related Topics

Description	This exception is raised when you specify an invalid value for the cap style.

Syntax

OG_Invalid_Cap_Style EXCEPTION;

Error Code	 102018


OG_Invalid_Catwidth

  Related Topics

Description	This exception is raised when you specify an invalid category width.

Syntax

OG_Invalid_Catwidth EXCEPTION;

Error Code	 102135


OG_Invalid_Chart_Creation_Attr

  Related Topics

Description	This exception is raised when a chart combined attribute record used as an argument for OG_Make contains a chart attribute record whose attributes are not valid.  When a chart is first created, you must specify both a template and a query to be attached to the chart.

Syntax

OG_Invalid_Chart_Creation_Attr EXCEPTION;

Error Code	 102054


OG_Invalid_Chart_Update_Mask

  Related Topics

Description	This exception is raised when the mask value used as an argument for OG_Update_Chart is invalid.

Syntax

OG_Invalid_Chart_Update_Mask EXCEPTION;

Error Code	 102052


OG_Invalid_Child_Del_Total

  Related Topics

Description	This exception is raised when the value used as an argument for OG_Delete_Child that specifies the total number of children to be deleted is greater than the number of children that actually exist in the group after (and including) the specified first child to be deleted.

Syntax

OG_Invalid_Child_Del_Total EXCEPTION;

Error Code	 102032


OG_Invalid_Child_Index

  Related Topics

Description	This exception is raised when the index value used as an argument for OG_Delete_Child, OG_Get_Child, or OG_Insert_Child is greater than the number of children in the group minus one.

Syntax

OG_Invalid_Child_Index EXCEPTION;

Error Code	 102031


OG_Invalid_Child_Object

  Related Topics

Description	This exception is raised when you call OG_Insert_Child and set the child_hdl argument to be an object that cannot be inserted into a group.

Syntax

OG_Invalid_Child_Object EXCEPTION;

Error Code	 102116


OG_Invalid_Cmptext_Del_Total

  Related Topics

Description	This exception is raised when the value used as an argument for OG_Delete_Cmptext that specifies the total number of compound text elements to be deleted is greater than the number of compound text elements that actually exist in the text object after (and including) the specified first element to be deleted.

Syntax

OG_Invalid_Cmptext_Del_Total EXCEPTION;

Error Code	 102037


OG_Invalid_Cmptext_Index

  Related Topics

Description	This exception is raised when you specify a compound text index that is greater than the number of compound text elements in the text object minus one.

Syntax

OG_Invalid_Cmptext_Index EXCEPTION;

Error Code	 102036


OG_Invalid_Color_Name

  Related Topics

Description	This exception is raised when you specify an invalid value for one of the color properties.

Syntax

OG_Invalid_Color_Name EXCEPTION;

Error Code	 102015


OG_Invalid_Column_Index

  Related Topics

Description	This exception is raised when you use an invalid value for the col_num argument in the built-in function OG_Get_Schema.

Syntax

OG_Invalid_Column_Index EXCEPTION;

Error Code	 102099


OG_Invalid_Column_Name

  Related Topics

Description	This exception is raised when:

•	a field record containing an invalid column name has been inserted into a chart (using OG_Insert_Field), and then the chart is updated by a call to OG_Update_Chart

•	an invalid column name is used as an argument for OG_Set_Attr (when setting the attributes of one of the elements of a chart), and then the chart is updated by a call to OG_Update_Chart

•	an invalid column name is used as an argument for OG_Get_Charcell, OG_Get_Datecell, or OG_Get_Numcell

 Syntax

OG_Invalid_Column_Name EXCEPTION;

Error Code	 102044


OG_Invalid_Compression_Type

  Related Topics

Description	This exception is raised when you specify an invalid image compression constant.

Syntax

OG_Invalid_Compression_Type EXCEPTION;

Error Code	 102121


OG_Invalid_Cursor_Offset

  Related Topics

Description	This exception is raised when the offset value used as an argument for OG_Start_From is greater than the number of rows that exist for the specified query minus one.

Syntax

OG_Invalid_Cursor_Offset EXCEPTION;

Error Code	 102047


OG_Invalid_Curvefit

  Related Topics

Description	This exception is raised when you specify an invalid curvefit.

Syntax

OG_Invalid_Curvefit EXCEPTION;

Error Code	 102158


OG_Invalid_Dash_Style

  Related Topics

Description	This exception is raised when an attribute record used as an argument for OG_Make or OG_Set_Attr contains an invalid value for the dash style attribute.

Syntax

OG_Invalid_Dash_Style EXCEPTION;

Error Code	 102019


OG_Invalid_Data_File

  Related Topics

Description	This exception is raised when Graphics Builder encounters an error while attempting to open or read from a PRN, SYLK, or WKS file.

Syntax

OG_Invalid_Data_File EXCEPTION;

Error Code	 102077


OG_Invalid_Data_Flag

  Related Topics

Description	This exception is raised when you specify an invalid data flag.  Valid values are the built-in constants OG_Newdata and OG_Olddata only.

Syntax

OG_Invalid_Data_Flag EXCEPTION;

Error Code	 102042


OG_Invalid_Data_Value

  Related Topics

Description	This exception is raised when you call OG_Update_Chart, and the query on which the chart is based contains data that is invalid for that chart type (e.g., if the chart type is pie and the query contains negative data).

Syntax

OG_Invalid_Data_Value EXCEPTION;

Error Code	 102070


OG_Invalid_Date_Format

  Related Topics

Description	This exception is raised when you specify an invalid date format.

Syntax

OG_Invalid_Date_Format EXCEPTION;

Error Code	 102108


OG_Invalid_Datevalue

  Related Topics

Description	This exception is raised when you specify an invalid date value.

Syntax

OG_Invalid_Datevalue EXCEPTION;

Error Code	 102133


OG_Invalid_Depthsize

  Related Topics

Description	This exception is raised when you specify an invalid depthsize.

Syntax

OG_Invalid_Depthsize EXCEPTION;

Error Code	 102129


OG_Invalid_Direction

  Related Topics

Description	This exception is raised when you specify an invalid axis direction.

Syntax

OG_Invalid_Direction EXCEPTION;

Error Code	 102143


OG_Invalid_Display_Handle

  Related Topics

Description	This exception is raised when an invalid display handle is used as an argument for OG_Close_Display.

Syntax

OG_Invalid_Display_Handle EXCEPTION;

Error Code	 102011


OG_Invalid_Drawing_Format

  Related Topics

Description	This exception is raised when you use an invalid value for the format argument in the built-in procedures OG_Export_Drawing or OG_Import_Drawing.

Syntax

OG_Invalid_Drawing_Format EXCEPTION;

Error Code	 102089


OG_Invalid_External_Location

  Related Topics

Description	This exception is raised when you specify an invalid location.  Valid values are the built-in constants OG_Db and OG_Filesystem only.

Syntax

OG_Invalid_External_Location EXCEPTION;

Error Code	 102056


OG_Invalid_Event_Mask

  Related Topics

Description	This exception is raised when you attempt to specify an invalid value for the events property.

Syntax

OG_Invalid_Event_Mask EXCEPTION;

Error Code	 102058


OG_Invalid_Field_Datatype

  Related Topics

Description	This exception is raised when you call OG_Update_Chart, and the query on which the chart is based contains data whose type is invalid for that chart.  For example, the dependent fields of a pie chart cannot be of type CHAR.  If they are, this exception is raised.

Syntax

OG_Invalid_Field_Datatype EXCEPTION;

Error Code	 102069


OG_Invalid_Field_Del_Total

  Related Topics

Description	This exception is raised when the value used as an argument for OG_Delete_Field that specifies the total number of fields to be deleted from a chart is greater than the number of fields that actually exist in the chart after (and including) the specified first field to be deleted.

Syntax

OG_Invalid_Field_Del_Total EXCEPTION;

Error Code	 102041


OG_Invalid_Field_Index

  Related Topics

Description	This exception is raised when the index value used as an argument for OG_Delete_Field, OG_Get_Field, or OG_Insert_Field is greater than the number of fields in the chart minus one.

Syntax

OG_Invalid_Field_Index EXCEPTION;

Error Code	 102040


OG_Invalid_Field_Template

  Related Topics

Description	This exception is raised when you specify an invalid field template name.

Syntax

OG_Invalid_Field_Template EXCEPTION;

Error Code	 102067


OG_Invalid_Field_Type

  Related Topics

Description	This exception is raised when a field record containing an invalid field type value has been inserted into a chart (using OG_Insert_Field), and then the chart is updated by a call to OG_Update_Chart.  Valid field type values include the built-in constants OG_Dependent and OG_Independent.

Syntax

OG_Invalid_Field_Type EXCEPTION;

Error Code	 102045


OG_Invalid_Ftemp_Del_Total

  Related Topics

Description	This exception is raised when you attempt to delete more field templates than exist in a chart template.

Syntax

OG_Invalid_Ftemp_Del_Total EXCEPTION;

Error Code	 102125


OG_Invalid_Ftemp_Index

  Related Topics

Description	This exception is raised when you specify an invalid field template to delete from a chart template.

Syntax

OG_Invalid_Ftemp_Index EXCEPTION;

Error Code	 102124


OG_Invalid_Gridct

  Related Topics

Description	This exception is raised when you specify an invalid grid count.

Syntax

OG_Invalid_Gridct EXCEPTION;

Error Code	 102155


OG_Invalid_Image_Format

  Related Topics

Description	This exception is raised when you use an invalid value for the format argument in the built-in procedures OG_Export_Image or OG_Import_Image.

Syntax

OG_Invalid_Image_Format EXCEPTION;

Error Code	 102082


OG_Invalid_Join_Style

  Related Topics

Description	This exception is raised when you specify an invalid join style.

Syntax

OG_Invalid_Join_Style EXCEPTION;

Error Code	 102017


OG_Invalid_Labelrot

  Related Topics

Description	This exception is raised when you specify an invalid label rotation.

Syntax

OG_Invalid_Labelrot EXCEPTION;

Error Code	 102150


OG_Invalid_Layer_Handle

  Related Topics

Description	This exception is raised when an invalid layer handle is used as an argument for OG_Activate_Layer, OG_Hide_Layer, or OG_Show_Layer.

Syntax

OG_Invalid_Layer_Handle EXCEPTION;

Error Code	 102009


OG_Invalid_Linestyle

  Related Topics

Description	This exception is raised when you specify an invalid linestyle.

Syntax

OG_Invalid_Linestyle EXCEPTION;

Error Code	 102159


OG_Invalid_Min_Max

  Related Topics

Description	This exception is raised when you specify an invalid axis minimum or maximum.

Syntax

OG_Invalid_Min_Max EXCEPTION;

Error Code	 102139


OG_Invalid_Minimum

  Related Topics

Description	This exception is raised when you specify an invalid axis minimum.

Syntax

OG_Invalid_Minimum EXCEPTION;

Error Code	 102154


OG_Invalid_Month

  Related Topics

Description	This exception is raised when you specify an invalid month.

Syntax

OG_Invalid_Month EXCEPTION;

Error Code	 102149


OG_Invalid_Number_Format

  Related Topics

Description	This exception is raised when you specify an invalid number format.

Syntax

OG_Invalid_Number_Format EXCEPTION;

Error Code	 102138


OG_Invalid_Object_Handle

  Related Topics

Description	This exception is raised when you use an invalid object handle as an argument to a subprogram.

Syntax

OG_Invalid_Object_Handle EXCEPTION;

Error Code	 102003


OG_Invalid_Object_Type

  Related Topics

Description	This exception is raised when an attribute record used as an argument for OG_Make or OG_Set_Attr contains an invalid value for the object type attribute.

Syntax

OG_Invalid_Object_Type EXCEPTION;

Error Code	 102020


OG_Invalid_Overlap

  Related Topics

Description	This exception is raised when you specify an invalid overlap value.

Syntax

OG_Invalid_Overlap EXCEPTION;

Error Code	 102152


OG_Invalid_Pattern_Name

  Related Topics

Description	This exception is raised when you specify an invalid pattern name.

Syntax

OG_Invalid_Pattern_Name EXCEPTION;

Error Code	 102016


OG_Invalid_Pct_By

  Related Topics

Description	This exception is raised when you specify an invalid percent by value.

Syntax

OG_Invalid_Pct_By EXCEPTION;

Error Code	 102148


OG_Invalid_Pct_Of

  Related Topics

Description	This exception is raised when you specify an invalid percent of value.

Syntax

OG_Invalid_Pct_Of EXCEPTION;

Error Code	 102147


OG_Invalid_Pie_Usage

  Related Topics

Description	This exception is raised when you specify an invalid percent of value.

Syntax

OG_Invalid_Pie_Usage EXCEPTION;

Error Code	 102136


OG_Invalid_Pie_Usagevalue

  Related Topics

Description	This exception is raised when you specify an invalid usage value.

Syntax

OG_Invalid_Pie_Usagevalue EXCEPTION;

Error Code	 102137


OG_Invalid_Plotpos

  Related Topics

Description	This exception is raised when you specify an invalid plot position.

Syntax

OG_Invalid_Plotpos EXCEPTION;

Error Code	 102151


OG_Invalid_Point_Del_Total

  Related Topics

Description	This exception is raised when the value used as an argument for OG_Delete_Point that specifies the total number of points to be deleted is greater than the number of points that actually exist in the object after (and including) the specified first point to be deleted.

Syntax

OG_Invalid_Point_Del_Total EXCEPTION;

Error Code	 102035


OG_Invalid_Point_Index

  Related Topics

Description	This exception is raised when the index value used as an argument for OG_Delete_Point, OG_Get_Point, or OG_Insert_Point is greater than the number of points in the object minus one.

Syntax

OG_Invalid_Point_Index EXCEPTION;

Error Code	 102033


OG_Invalid_Position

  Related Topics

Description	This exception is raised when you specify an invalid axis position.

Syntax

OG_Invalid_Position EXCEPTION;

Error Code	 102142


OG_Invalid_Prn_Format

  Related Topics

Description	This exception is raised when you execute a query that references a PRN file, but the file is not a valid PRN format.

Syntax

OG_Invalid_Prn_Format EXCEPTION;

Error Code	 102079


OG_Invalid_Query_Handle

  Related Topics

Description	This exception is raised when you specify an invalid query handle.

Syntax

OG_Invalid_Query_Handle EXCEPTION;

Error Code	 102004


OG_Invalid_Query_Source

  Related Topics

Description	This exception is raised when you specify an invalid SQL statement or filename for a query.

Syntax

OG_Invalid_Query_Source EXCEPTION;

Error Code	 102107


OG_Invalid_Query_Type

  Related Topics

Description	This exception is raised when you specify an invalid query type.

Syntax

OG_Invalid_Query_Type EXCEPTION;

Error Code	 102109


OG_Invalid_Refline_Del_Total

  Related Topics

Description	This exception is raised when you attempt to delete more reference lines than exist in a chart template.

Syntax

OG_Invalid_Refline_Del_Total EXCEPTION;

Error Code	 102128


OG_Invalid_Refline_Index

  Related Topics

Description	This exception is raised when you specify an invalid reference line to delete.

Syntax

OG_Invalid_Refline_Index EXCEPTION;

Error Code	 102127


OG_Invalid_Refline_Handle

  Related Topics

Description	This exception is raised when you reference an invalid reference line handle.

Syntax

OG_Invalid_Refline_Handle EXCEPTION;

Error Code	 102123


OG_Invalid_Row_Number

  Related Topics

Description	This exception is raised when an invalid row number is used as an argument for OG_Set_Attr (when setting the attributes of one of the elements of a chart), and then the chart is updated by a call to OG_Update_Chart.

Syntax

OG_Invalid_Row_Number EXCEPTION;

Error Code	 102053


OG_Invalid_Scale

  Related Topics

Description	This exception is raised when you specify an invalid scale value.

Syntax

OG_Invalid_Scale EXCEPTION;

Error Code	 102146


OG_Invalid_Shadowdir

  Related Topics

Description	This exception is raised when you specify an invalid shadow direction.

Syntax

OG_Invalid_Shadowdir EXCEPTION;

Error Code	 102131


OG_Invalid_Shadowsize

  Related Topics

Description	This exception is raised when you specify an invalid shadow size.

Syntax

OG_Invalid_Shadowsize EXCEPTION;

Error Code	 102130


OG_Invalid_Smptext_Del_Total

  Related Topics

Description	This exception is raised when the value used as an argument for OG_Delete_Smptext that specifies the total number of simple text elements to be deleted is greater than the number of simple text elements that actually exist in the compound text element after (and including) the specified first element to be deleted.

Syntax

OG_Invalid_Smptext_Del_Total EXCEPTION;

Error Code	 102039


OG_Invalid_Smptext_Index

  Related Topics

Description	This exception is raised when the index value used as an argument for OG_Delete_Smptext, OG_Get_Smptext, or OG_Insert_Smptext is greater than the number of simple text elements in the compound text element minus one.

Syntax

OG_Invalid_Smptext_Index EXCEPTION;

Error Code	 102038


OG_Invalid_Sound_Format

  Related Topics

Description	This exception is raised when you specify an invalid sound format.

Syntax

OG_Invalid_Sound_Format EXCEPTION;

Error Code	 102084


OG_Invalid_Sound_Handle

  Related Topics

Description	This exception is raised when an invalid sound handle is used as an argument for OG_Play_Sound.

Syntax

OG_Invalid_Sound_Handle EXCEPTION;

Error Code	 102007


OG_Invalid_Step

  Related Topics

Description	This exception is raised when you specify an invalid step value.

Syntax

OG_Invalid_Step EXCEPTION;

Error Code	 102145


OG_Invalid_Sylk_Format

  Related Topics

Description	This exception is raised when you execute a query that references a SYLK file, but the file is not a valid SYLK format.

Syntax

OG_Invalid_Sylk_Format EXCEPTION;

Error Code	 102078


OG_Invalid_Symbol_Index

  Related Topics

Description	This exception is raised when you specify an invalid symbol index.

Syntax

OG_Invalid_Symbol_Index EXCEPTION;

Error Code	 102023


OG_Invalid_Symbol_Size

  Related Topics

Description	This exception is raised when you specify an invalid symbol size.

Syntax

OG_Invalid_Symbol_Size EXCEPTION;

Error Code	 102024


OG_Invalid_Template_Handle

  Related Topics

Description	This exception is raised when you attempt to use an invalid template handle.

Syntax

OG_Invalid_Template_Handle EXCEPTION;

Error Code	 102005


OG_Invalid_Template_Type

  Related Topics

Description	This exception is raised when you specify an invalid template type.

Syntax

OG_Invalid_Template_Type EXCEPTION;

Error Code	 102126


OG_Invalid_Text_Horalign

  Related Topics

Description	This exception is raised when you specify an invalid alignment value.

Syntax

OG_Invalid_Text_Horalign EXCEPTION;

Error Code	 102026


OG_Invalid_Text_Horjust

  Related Topics

Description	This exception is raised when you specify an invalid justification value.

Syntax

OG_Invalid_Text_Horjust EXCEPTION;

Error Code	 102027


OG_Invalid_Text_Spacing

  Related Topics

Description	This exception is raised when you specify an invalid spacing value.

Syntax

OG_Invalid_Text_Spacing EXCEPTION;

Error Code	 102025


OG_Invalid_Text_Vertalign

  Related Topics

Description	This exception is raised when you specify an invalid alignment value.

Syntax

OG_Invalid_Text_Vertalign EXCEPTION;

Error Code	 102028


OG_Invalid_Text_Vertjust

  Related Topics

Description	This exception is raised when you specify an invalid justification value.

Syntax

OG_Invalid_Text_Vertjust EXCEPTION;

Error Code	 102029


OG_Invalid_Tickpos

  Related Topics

Description	This exception is raised when you specify an invalid tick position.

Syntax

OG_Invalid_Tickpos EXCEPTION;

Error Code	 102144


OG_Invalid_Timer_Handle

  Related Topics

Description	This exception is raised when you specify an invalid timer handle.

Syntax

OG_Invalid_Timer_Handle EXCEPTION;

Error Code	 102010


OG_Invalid_Timer_Procedure

  Related Topics

Description	This exception is raised when you specify an invalid trigger procedure.

Syntax

OG_Invalid_Timer_Procedure EXCEPTION;

Error Code	 102112


OG_Invalid_Timer_Interval

  Related Topics

Description	This exception is raised when you specify an invalid time interval.

Syntax

OG_Invalid_Timer_Interval EXCEPTION;

Error Code	 102113


OG_Invalid_Transfer_Mode

  Related Topics

Description	This exception is raised when you set an invalid transfer mode.

Syntax

OG_Invalid_Transfer_Mode EXCEPTION;

Error Code	 102057


OG_Invalid_Userexit_Invocation

  Related Topics

Description	This exception is raised when Graphics Builder cannot invoke a specified user exit.

Syntax

OG_Invalid_Userexit_Invocation EXCEPTION;

Error Code	 102048


OG_Invalid_Window_Dimensions

  Related Topics

Description	This exception is raised when you specify invalid window dimensions.

Syntax

OG_Invalid_Window_Dimensions EXCEPTION;

Error Code	 102002


OG_Invalid_Window_Handle

  Related Topics

Description	This exception is raised when an invalid window handle is used as an argument for a subprogram.

Syntax

OG_Invalid_Window_Handle EXCEPTION;

Error Code	 102008


OG_Invalid_Wks_Format

  Related Topics

Description	This exception is raised when you execute a query that references a WKS file, but the file is not a valid WKS format.

Syntax

OG_Invalid_Wks_Format EXCEPTION;

Error Code	 102080


OG_Layer_Not_Child_Of_Root

  Related Topics

Description	This exception is raised when an attribute record used as an argument for OG_Make contains an invalid value for the parent attribute.

Syntax

OG_Layer_Not_Child_Of_Root EXCEPTION;

Error Code	 102012


OG_Login_Failure

  Related Topics

Description	This exception is raised when you attempt to connect to a database, using OG_Connect or OG_Logon, but the connection failed.

Syntax

OG_Login_Failure EXCEPTION;

Error Code	 102085


OG_Logoff_Disallowed

  Related Topics

Description	This exception is raised when you call OG_Logoff, but Graphics Builder cannot close the database connection because your display contains open SQL cursors.

Syntax

OG_Logoff_Disallowed EXCEPTION;

Error Code	 102101


OG_Logon_Disallowed

  Related Topics

Description	This exception is raised when you call OG_Logon, but Graphics Builder cannot close the previous database connection because your display contains open SQL cursors.

Syntax

OG_Logon_Disallowed EXCEPTION;

Error Code	 102100


OG_Logoff_Failure

  Related Topics

Description	This exception is raised when OG_Logoff encounters an error while trying to close the database connection.

Syntax

OG_Logoff_Failure EXCEPTION;

Error Code	 102086


OG_Main_Window_Destruction

  Related Topics

Description	This exception is raised when the main display window is used as the argument for OG_Destroy.  To close the main window without destroying it, use OG_Hide_Window.

Syntax

OG_Main_Window_Destruction EXCEPTION;

Error Code	 102046


OG_Missing_Chart_Field

  Related Topics

Description	This exception is raised when you call OG_Update_Chart, but the query on which the chart is based does not contain one or more fields that the chart is expecting.  For example, if you create a chart to plot values for ENAME, SAL, and COMM, but the query returns only ENAME and SAL, this exception is raised.

Syntax

OG_Missing_Chart_Field EXCEPTION;

Error Code	 102068


OG_No_Chart_Data

  Related Topics

Description	This exception is raised when you call OG_Update_Chart, but the query associated with the chart has not yet been executed.

Syntax

OG_No_Chart_Data EXCEPTION;

Error Code	 102114


OG_No_Database_Connection

  Related Topics

Description	This exception is raised when an attempt is made to access a database that has not yet been successfully connected.  It may be raised by OG_Execute_Query or OG_Open_Display.

Syntax

OG_No_Database_Connection EXCEPTION;

Error Code	 102055


OG_No_Dependent_Fields

  Related Topics

Description	This exception is raised when you try to update a chart that does not contain any dependent fields.

Syntax

OG_No_Dependent_Fields EXCEPTION;

Error Code	 102072


OG_No_Independent_Fields

  Related Topics

Description	This exception is raised when you try to update a chart that does not contain any independent fields.

Syntax

OG_No_Independent_Fields EXCEPTION;

Error Code	 102186


OG_No_Query_Name

  Related Topics

Description	This exception is raised when you specify an invalid query name.

Syntax

OG_No_Query_Name EXCEPTION;

Error Code	 102173


OG_No_Schema

  Related Topics

Description	This exception is raised when you attempt to execute a custom query that has no schema.

Syntax

OG_No_Schema EXCEPTION;

Error Code	 102165


OG_Not_Chart_Element

  Related Topics

Description	This exception is raised when you attempt to treat an object as a chart element, but it is not.

Syntax

OG_Not_Chart_Element EXCEPTION;

Error Code	 102184


OG_Not_Supported_In_Designer

  Related Topics

Description	This exception is raised when you attempt to execute a PL/SQL statement that is not applicable to the Graphics Builder designer.  Most likely, you should execute the statement at runtime only.

Syntax

OG_Not_Supported_In_Designer EXCEPTION;

Error Code	 102183


OG_Sound_Conversion_Failure

  Related Topics

Description	This exception is raised when you import a sound, but Graphics Builder could not convert from the sound's original sampling rate or encoding scheme.  Usually, this means the sound is too large.

Syntax

OG_Sound_Conversion_Failure EXCEPTION;

Error Code	 102120


OG_No_Sound_Input_Device

  Related Topics

Description	This exception is raised when you use OG_Play_Sound to play a sound, but there is no sound output device throughwhich to play it.

Syntax

OG_No_Sound_Input_Device EXCEPTION;

Error Code	 102118


OG_No_Sound_Output_Device

  Related Topics

Description	This exception is raised when you use OG_Record_Sound to record a sound, but there is not sound input device through which to record it.

Syntax

OG_No_Sound_Output_Device EXCEPTION;

Error Code	 102117


OG_Not_Chart_Object

  Related Topics

Description	This exception is raised when you call a built-in subprogram that operates on a chart, but the argument you pass it is not a valid handle to a chart object.

Syntax

OG_Not_Chart_Object EXCEPTION;

Error Code	 102061


OG_Not_Group_Object

  Related Topics

Description	This exception is raised when you call a built-in subprogram that operates on a group, but the argument you pass it is not a valid handle to a group object.

Syntax

OG_Not_Group_Object EXCEPTION;

Error Code	 102062


OG_Not_Image_Object

  Related Topics

Description	This exception is raised when you call a built-in subprogram that operates on an image, but the argument you pass it is not a valid handle to a image object.

Syntax

OG_Not_Image_Object EXCEPTION;

Error Code	 102064


OG_Not_Polygon_Object

  Related Topics

Description	This exception is raised when you call a built-in subprogram that operates on a polyline or polygon, but the argument you pass it is not a valid handle to a polyline or polygon object.

Syntax

OG_Not_Polygon_Object EXCEPTION;

Error Code	 102063


OG_Not_Text_Object

  Related Topics

Description	This exception is raised when you call a built-in subprogram that operates on text object, but the argument you pass it is not a valid handle to a text object.

Syntax

OG_Not_Text_Object EXCEPTION;

Error Code	 102065


OG_Null_Chart_Element

  Related Topics

Description	This exception is raised when you call OG_Get_Chart_Element and the chart element is NULL.

Syntax

OG_Null_Chart_Element EXCEPTION;

Error Code	 102187


OG_Null_Module_Name

  Related Topics

Description	This exception is raised when you specify a NULL module name as an argument to a built-in subprogram that exports, imports, or opens a module from the filesystem or database.

Syntax

OG_Null_Module_Name EXCEPTION;

Error Code	 102110


OG_Open_Display_Failure

  Related Topics

Description	This exception is raised when OG_Open_Display encounters an error while attempting to open a display.

Syntax

OG_Open_Display_Failure EXCEPTION;

Error Code	 102030


OG_Parent_Not_Group

  Related Topics

Description	This exception is raised when the parent attribute in an attribute record used as an argument for OG_Make does not contain a valid handle to a group object.

Syntax

OG_Parent_Not_Group EXCEPTION;

Error Code	 102014


OG_Pctchart_Zero

  Related Topics

Description	This exception is raised when you specify an invalid Percent of value for a chart.

Syntax

OG_Pctchart_Zero EXCEPTION;

Error Code	 102071


OG_Piechart_Sum_Overflow

  Related Topics

Description	This exception is raised when you update a pie chart for which you specified a Total Value (in the Pie Frame property sheet) that is less than the actual sum of data returned by the query.

Syntax

OG_Piechart_Sum_Overflow EXCEPTION;

Error Code	 102073


OG_Print_Failure

  Related Topics

Description	This exception is raised when Graphics Builder encounters an error while trying to print the display.

Syntax

OG_Print_Failure EXCEPTION;

Error Code	 102111


OG_Query_Execution_Error

  Related Topics

Description	This exception is raised when Graphics Builder encounters an error while trying to execute a query.

Syntax

OG_Query_Execution_Error EXCEPTION;

Error Code	 102075


OG_Recursive_Chart_Update

  Related Topics

Description	This exception is raised when a process that updates a chart invokes a trigger that explicitly updates the same chart.

Syntax

OG_Recursive_Chart_Update EXCEPTION;

Error Code	 102185


OG_Root_Object_Destruction

  Related Topics

Description	This exception is raised when the object used as an argument to OG_Destroy is the root object in the layout group tree.

Syntax

OG_Root_Object_Destruction EXCEPTION;

Error Code	 102021


OG_Row_Retrieval_Failure

  Related Topics

Description	This exception is raised when OG_Get_Charcell, OG_Get_Datecell, or OG_Get_Numcell fails to find the current row of data.

Syntax

OG_Row_Retrieval_Failure EXCEPTION;

Error Code	 102081


OG_Save_Display_Failure

  Related Topics

Description	This exception is raised when OG_Save_Display encounters an error while attempting to save a display.

Syntax

OG_Save_Display_Failure EXCEPTION;

Error Code	 102104


OG_Set_Object_Prop_Failure

  Related Topics

Description	This exception is raised when an error occurs while setting an object property.

Syntax

OG_Set_Object_Prop_Failure EXCEPTION;

Error Code	 102162


OG_Set_Param_Error

  Related Topics

Description	This exception is raised when an error occurs while setting a parameter.

Syntax

OG_Set_Param_Error EXCEPTION;

Error Code	 102174


OG_Set_Printer_Failure

  Related Topics

Description	This exception is raised when an error occurs while setting the printer name.

Syntax

OG_Set_Printer_Failure EXCEPTION;

Error Code	 102161


OG_Set_Property_Error

  Related Topics

Description	This exception is raised when an error occurs while setting an object property.

Syntax

OG_Set_Property_Error EXCEPTION;

Error Code	 102180


OG_Sound_Export_Failure

  Related Topics

Description	This exception is raised when OG_Export_Sound encounters an error while attempting to export a sound.

Syntax

OG_Sound_Export_Failure EXCEPTION;

Error Code	 102088


OG_Sound_Import_Failure

  Related Topics

Description	This exception is raised when OG_Import_Sound encounters an error while attempting to import a sound.

Syntax

OG_Sound_Import_Failure EXCEPTION;

Error Code	 102094


OG_Sql_Execution_Error

  Related Topics

Description	This exception is raised when Graphics Builder encounters an error while attempting to execute a query based on a SQL statement.

Syntax

OG_Sql_Execution_Error EXCEPTION;

Error Code	 102076


OG_Template_Export_Failure

  Related Topics

Description	This exception is raised when OG_Export_Template encounters an error while attempting to export a template.

Syntax

OG_Template_Export_Failure EXCEPTION;

Error Code	 102092


OG_Template_Import_Failure

  Related Topics

Description	This exception is raised when OG_Import_Template encounters an error while attempting to import a template.

Syntax

OG_Template_Import_Failure EXCEPTION;

Error Code	 102096


OG_Too_Many_Data_Rows

  Related Topics

Description	This exception is raised when you execute a query that returns more rows of data than Graphics Builder can process on your system.

Syntax

OG_Too_Many_Data_Rows EXCEPTION;

Error Code	 102119


OG_Undefined_Param

  Related Topics

Description	This exception is raised when you attempt to reference a parameter that is undefined.

Syntax

OG_Undefined_Param EXCEPTION;

Error Code	 102178


OG_Undefined_Property

  Related Topics

Description	This exception is raised when you attempt to reference an object property that is undefined.

Syntax

OG_Undefined_Property EXCEPTION;

Error Code	 102182


OG_Userexit_Failure_Error

  Related Topics

Description	This exception is raised when a user exit returns its corresponding error code to Graphics Builder.

Syntax

OG_Userexit_Failure_Error EXCEPTION;

Error Code	 102049


OG_Userexit_Fatal_Error

  Related Topics

Description	This exception is raised when a user exit returns its corresponding error code to Graphics Builder.

Syntax

OG_Userexit_Fatal_Error EXCEPTION;

Error Code	 102050


OG_Userexit_Unknown_Error

  Related Topics

Description	This exception is raised when a user exit returns an unrecognized error code to Graphics Builder.

Syntax

OG_Userexit_Unknown_Error EXCEPTION;

Error Code	 102051


Tool_Int.Duplicate_Parameter_Key

  Related Topics

Description	This exception is raised when you attempt to add a parameter to a parameter list, but a parameter with that name is already defined.

Syntax

Tool_Int.Duplicate_Parameter_Key EXCEPTION;

Error Code	 104508


Tool_Int.Duplicate_Parameter_List_Name

  Related Topics

Description	This exception is raised when you attempt to create a parameter list with a name that is already being used by another parameter list.

Syntax

Tool_Int.Duplicate_Parameter_List_Name EXCEPTION;

Error Code	 104504


Tool_Int.Internal_Tools_Error

  Related Topics

Description	This exception is raised when a serious internal error occurs.  Contact your Oracle support representative.

Syntax

Tool_Int.Internal_Tools_Error EXCEPTION;

Error Code	 104500


Tool_Int.Invalid_Communication_Mode

  Related Topics

Description	This exception is raised when you attempt to call Tool_Int.Run_Product using an invalid communication mode.  Valid values are the package constants Tool_Int.Synchronous and Tool_Int.Asynchronous only.

Syntax

Tool_Int.Invalid_Communication_Mode EXCEPTION;

Error Code	 104511


Tool_Int.Invalid_Execution_Mode

  Related Topics

Description	This exception is raised when you attempt to call Tool_Int.Run_Product using an invalid execution mode.  Valid values are the package constants Tool_Int.Batch and Tool_Int.Runtime only.

Syntax

Tool_Int.Invalid_Execution_Mode EXCEPTION;

Error Code	 1045010


Tool_Int.Invalid_Location

  Related Topics

Description	This exception is raised when you attempt to call Tool_Int.Run_Product using an invalid location for the specified module.  Valid values are the package constants Tool_Int.Db and Tool_Int.Filesystem only.

Syntax

Tool_Int.Invalid_Location EXCEPTION;

Error Code	 104503


Tool_Int.Invalid_Parameter_List_Handle

  Related Topics

Description	This exception is raised when you attempt to reference an invalid parameter list handle.

Syntax

Tool_Int.Invalid_Parameter_List_Handle EXCEPTION;

Error Code	 104506


Tool_Int.Invalid_Parameter_Key

  Related Topics

Description	This exception is raised when you attempt to reference a parameter using an invalid name.

Syntax

Tool_Int.Invalid_Parameter_Key EXCEPTION;

Error Code	 104507


Tool_Int.Invalid_Parameter_List_Name

  Related Topics

Description	This exception is raised when you attempt to reference a parameter list using an invalid name.

Syntax

Tool_Int.Invalid_Parameter_List_Name EXCEPTION;

Error Code	 104505


Tool_Int.Invalid_Parameter_Type

  Related Topics

Description	This exception is raised when you set a parameter type to anything other than CHAR, DATE, or NUMBER.

Syntax

Tool_Int.Invalid_Parameter_Type EXCEPTION;

Error Code	 104501


Tool_Int.Invalid_Product

  Related Topics

Description	This exception is raised when you attempt to call Tool_Int.Run_Product using an invalid product.  Valid values are the package constants Tool_Int.Book, Tool_Int.Forms, and Tool_Int.Reports only.

Syntax

Tool_Int.Invalid_Product EXCEPTION;

Error Code	 104502


Tool_Int..Run_Product_Failure
Tool_Int.run_product_failure

  Related Topics

Description	This exception is raised when Graphics Builder cannot run the product specified by a call to Tool_Int.Run_Product.  For information about preparing another product for use with Graphics Builder, see the Graphics Builder documentation for your operating system, or your product documentation.

Syntax

Tool_Int..Run_Product_Failure EXCEPTION;

Error Code	 104509


About error messages

Each component has a unique error message prefix:

Prefix	Component
FRM	Form Builder
OG	Graphics Builder
PDE	Procedure Builder
REP	Report Builder
BRW	Query Builder
BRS	Schema Builder
NX, XBD	Translation Builder
Note:  On UNIX, Report Builder sets the value of the $status variable that appears in some messages to be 0 (successful completion) or 1 (unsuccessful completion).

In addition to the Forms Developer or Reports Developer error messages, you may encounter error messages from other sources:

Prefix	Source	Help
ORA	Oracle Server	Oracle8 Error Messages manual
PLS	PL/SQL	Oracle8 Error Messages manual
NET	SQL*Net	Oracle Network Products Messages manual
The Oracle8 Error Messages manual contains error message codes and descriptions for all database utilities such as SQL*DBA, SQL*Loader,SQL*Module,Export, Import, and the Oracle Precompilers.

System-specific error messages are documented in your operating system documentation.


Calling Oracle Support Services

Some errors (that is, internal errors) will require that you call Oracle Support Services to report the error.  When you call Support Services, please have the following information at hand:

1	Your name, company, and Oracle Support ID number.

2	The hardware, operating system, and release number of the operating system you are using.

3	The complete version number of the component you were using when you encountered the error, including revision number and port release number, if any.  (If you are unsure of the component's version number, choose Help [image] About.)

4	All other products (and version numbers) in use when you encountered the error (for example, Oracle 8.0.4).

5	If you encountered one or more error messages, the exact message numbers and descriptions, in the order they appeared.

6	A description of the problem, including any unusual conditions.

7	The problem severity, according to the following codes:

•	1:  Program not usable.  Critical impact on operations.

•	2:  Program usable.  Operations severely restricted.

•	3:  Program usable with limited functions.  Not critical to overall operations.

•	4:  Problem circumvented by customer.  Minimal effect, if any, on operations.


Abnormal conditions

Sometimes you may encounter an error that is known as an abnormal condition, which may arise from one of the following causes:

•	Someone has done something that prevented your application from completing the requested task.  For example, if someone bypassed the user interface and changed data in a database table, they might have typed an invalid value.

•	A software bug prevented the requested task from completing.

Action   First contact your system administrator to determine if the message was caused by something other than Forms Developer or Reports Developer.  If you determine that the message was not the result of user error or a system problem, then contact Oracle Support Services.


Glossary

A

    action
    active window/view
    ActiveX
    Ada
    aggregation
    alert
    alignment
    alias
    All tool
    ancestor
    ancestor group
    anchor
    anchor point
    anonymous block
    antecedent
    applet
    application
    argument
    ASCII
    attached library
    attribute
    attribute columns
    attribute mask
    Attribute tool
    attribute value
    axis chart

 B

    background element
    background process
    baseline value
    Batch
    batch compile
    bind reference
    bind variable
    block
    body
    boilerplate
    border
    bounding box
    break chart
    break column
    break group
    break report
    break trigger
    breakpoint
    builder
    built-in datatype
    built-ins
    built-in macro
    buffer
    button
    button procedure

C

    cache (memory)
    call interface
    call stack
    canvas
    canvas view
    cartridge
    cascading style sheet
    category
    category axis
    cell
    CGI
    CGM
    CHAR datatype
    chart element
    chart item
    chart template
    check box
    checksum
    child
    child query
    classification
    clause
    client
    client/server architecture
    Clipboard
    CMDFILE
    collection type
    color palette
    column
    column object
    command line
    comment
    commit
    comparison operators
    compile
    component
    concurrency
    condition
    confine mode
    connect
    connect string
    constraint
    construct
    context area
    continuous axis
    control point
    coordinate plane
    coordinate system
    coordinates (x, y)
    copy
    correlated subquery
    cross product
    crosstab
    cursor
    custom measure
    cut

D

    damage
    data dictionary
    data link
    data model
    data structure node
    database
    database trigger
    datasource
    datatype
    DATE
    date axis
    debug
    debug action
    debug trigger
    Debugger
    deconstructed object
    default
    deliver
    dependency tree
    dependency view
    dependent data
    descendant
    designer
    Designer (Oracle)
    detail query
    dialog box
    DIANA
    dimension
    dimension hierarchy
    dimension value
    disabled
    discrete axis
    display
    display item
    downward-growing
    drag
    drill
    duplicate
    dynamic saved selection

E

    EBCDIC
    edge
    Edge/Fill/Text Display
    editor
    element
    element type
    Ellipsis button
    enabled
    enclosing object
    encryption
    environment
    exception
    Exception tool
    executable argument
    execute
    export
    export file
    expression
    external PL/SQL library
    external query

F

    family
    Family tool
    field
    field template
    file node
    fill area
    filter
    firewall
    flattened object
    flex mode
    focus
    foreground element
    foreign key
    form layout
    form letter layout
    format mask
    format trigger
    formula
    formula column
    frame
    function

G

    generate
    Generate
    Global Registry
    global variable
    grant
    gridlines
    group
    group filter
    group tree
    GUI

H

    handle
    header
    heading node
    hidden
    hierarchy
    HTML
    HTTP
    hyperlink
    hypertext

I

    ICD
    icon
    image
    implied item
    import
    independent data
    index
    inherit
    inner bounding box
    input item
    insert mode
    internet
    Interpreter script
    intranet
    IP (Internet Protocol) Address
    item
    item node

J

    JAR
    Java
    join
    justification

K

    keyword

L

    label
    Launcher
    level
    Level tool
    layout
    layout unit
    lexical reference
    library
    link
    link file
    list box
    list item
    list of values
    List tool
    local database
    local registry
    local variable
    logical operators
    logical page
    loop

M

    macro
    mailing label layout
    margin
    master/detail layout
    Match tool
    matrix cell
    matrix layout
    matrix report
    measure
    megabyte (Mb)
    message box
    method
    modal window
    modeless window
    module
    multi-line field

N

    NA value
    nested matrix
    NOCACHE
    node
    non-caching column
    NULL value
    numeric operators

O

    object
    object column
    object group
    object handle
    Object Navigator
    object table
    object type
    ODBC
    OLE
    OLE container
    OLE Server
    Oracle datatype
    Oracle Designer
    ORACLE_HOME
    organization node
    origin
    outer bounding box
    overflow

P

    packaged function
    package
    package body
    package specification
    page
    page break
    palette
    pane
    panel
    parameter
    parameter list
    parent
    paste
    pattern
    Pcode
    PDF
    physical page
    placeholder username
    plot type
    PL/SQL
    pld file
    pll file
    pls file
    plx file
    pop-up list
    port
    pre-defined action
    pre-defined type
    preference
    preview
    Previewer
    primary key
    primitive
    printer control code
    prt file
    procedure
    program unit
    project
    project file
    project item
    Project Navigator
    project node
    project registry
    project view
    Project Wizard
    property
    property class
    protocol

Q

    qualifying dimension
    query
    query filter function
    quit

R

    radio button
    radio group
    Range tool
    RC4
    RDBMS
    rdf file
    rep file
    read consistency
    record
    record group
    REF column
    reference line
    refresh
    register
    registry
    relational operator
    remote database
    repeating frame
    replace mode
    report-level objects
    Reports Background Engine (RWRBE60)
    Reports Queue Manager (RWRQM60)
    Reports Server (RWMTS60)
    Reports Web Cartridge
    Reports Web CGI (RWCGI60)
    rex file
    RGB
    root
    root node
    row
    row object
    RTF
    run
    runfile
    Runtime
    Runtime Parameter Form

S

    saved selection
    Saved Selection tool
    schema
    scope
    script
    section
    SELECT statement
    selection
    selection script
    Selector
    Selector tool
    session
    sibling
    socket
    Sort tool
    source
    specification
    split bar
    SQL
    sql file
    SQL script
    SQL statement
    stack
    statement
    static saved selection
    stored program unit
    stored subprogram
    style sheet
    subprogram
    subproject
    subproject node
    summary column
    SYLK
    syntax
    system variable

T

    table
    table type
    tabular
    target
    target node
    TCP
    tear-off menu
    text item
    title bar
    title page
    toggle
    tool
    toolbar
    tool palette
    Top/Bottom tool
    trailer
    transaction
    trigger
    type

U

    update
    URL
    user exit
    user-defined action
    user-defined type
    user-defined macro
    user registry

V

    valid XML
    value axis
    value construct
    variable
    varying array type
    VBX
    VBX control
    view
    virtual directory
    virtual file system
    visual attribute

W

    Web
    Web browser
    Web cartridge
    Web link
    Web server
    well-formed XML
    wildcard
    window
    WKS
    WRB
    WWW

X

    XML

Y

Z

    zoom


In Project Builder, a command string supplied either by Project Builder or by the user that applies to files of a given type.  An action is not restricted to a single file type; for example, if the action "Compile" is defined for both forms and C source files, selecting "Compile Project" will compile all .fmb and .c files using the appropriate tools.  See also:  pre-defined action, user-defined action.


A high-level programming language developed by the U.S. Department of Defense for use in embedded computer systems.


A window or view that can receive user input.


(Oracle Express) The consolidation of data for several dimension values into a single value, such as the total units sold for all the cities, or into a smaller set of values, such as the average units sold for cities in each region. Data is often collected at the lowest level of detail and is aggregated into higher level totals for analysis.


A modal window that notifies you of a condition that occurred because of your last action.  You must respond to an alert.


The way in which data is positioned in a field.  It may be positioned to the left, right, center, flush/left, flush/right, or flush/center of the defined width of a field.


A secondary name used in a SQL statement to reference a table, view, or column.


(Oracle Express) A Selector dialog box tool that allows you to select all of the values in a dimension, or all of the values in a dimension for a specific hierarchy.


(Oracle Express) A dimension value at any level above a particular value in a hierarchy. The ancestor value is the aggregated total of the values of its descendants.  The following example shows the dimension value "Europe" as the ancestor of "France," "Lyon," and "Paris" in the GEOGRAPHY dimension.


A group that owns another group, either directly or indirectly.


A layout object used to fix a spot on one object to a spot on another object, ensuring the position of the first object in relation to the second object.


(Oracle Express) A specific dimension value that is used when selecting dimension values based on their family relationship or when navigating through a hierarchy.


A PL/SQL program unit that has no name and does not require the explicit presence of the BEGIN and END keywords to enclose the executable statements.  Since they are unnamed, anonymous blocks cannot be referenced by other program units.


An object that appears in another object's group tree at any position above that other object.  Every object is an antecedent of its descendants.


A Java term for small programs that can be dynamically imported into Web pages or applications as needed.


One or more program modules used to achieve a specific result.  Applications can be nested within other applications.  For example, an application to control a company's inventory could consist of various Form Builder applications for input of data, and various Graphics Builder applications to display the data visually.


1. An optional expression passed to a program unit for the program unit to operate on.
2. Clauses containing keywords and their specified values.


Acronym for American National Standard Code for Information Interchange.


A read only collection of PL/SQL subprograms, usually provided with an application to supply necessary PL/SQL source.  Program units in an attached library are implicitly loaded when they are first called by another program unit at compile-time or runtime.  They remain loaded for quick reuse, which reduces runtime memory requirements and improves the performance of an application.  See also:  library .


1. See property.
2.  A part or component of an Oracle8 object type definition.  Each attribute has a name and an Oracle8 datatype.  When an object table is created based on the object type, the columns in the table correspond to the attributes in the object type definition.  When a column object in a relational table is created based on the object type, the column object contains the equivalent of sub-columns, each of which corresponds to an attribute in the object type definition.  Each Oracle8 object attribute in a table is treated as a separate data item, as if it were a separate column.  This is true for both object tables and column objects in relational tables.
3. (Oracle Express) A descriptive characteristic that is shared by dimension values. Attributes represent logical groupings that allow users to select data based on like characteristics. For example, in a database representing footwear, you can use a shoe color attribute to select all boots, sneakers, and slippers that share the same color.


The columns that compose a column object (Oracle8).


In Graphics Builder, the first element in an attribute descriptor.  It is a 32-bit mask that informs the toolkit of the attributes that will be set or retrieved by a subsequent function call.  Only those elements that have their corresponding bits set in the attribute mask are set or retrieved.


(Oracle Express) A Selector dialog box tool that allows you to select dimension values based on attributes and attribute values. For example, in a database representing soft drinks, you might select all products whose size is 1 liter. In this example, Size is an attribute and 1 liter is an attribute value.


(Oracle Express) The values in the database that make up an attribute. For example, in a database representing ice cream products, the following attribute values might belong to a flavor attribute in a Product dimension: vanilla, chocolate, and strawberry. Dimension values at various levels in the Product dimension -- brand, form, and size, for instance -- might share the same value for flavor.


A type of chart in which the data is plotted according to where it lies along the chart's edges, called axes.  An axis chart may contain two or three axes, each of which may be one of the following types:  discrete, continuous, or date.


The white part of a pattern.  You apply color to the background element using the Fill Color palette.


A non-interactive process that runs in an operating system environment and performs some service or action.  Certain Oracle products use background processes for different tasks, such as performing and coordinating tasks on behalf of concurrent users of the database, processing and delivering electronic messages, and managing printing services.


The value used as the starting point for plotting fields on the continuous axis of a chart.


The executable that executes an application in batch mode, without using a windowing system.


To translate, at once, several PL/SQL program units into a machine executable form.


A reference to a parameter used to replace a single literal value (e.g., a character string, number, or date) appearing anywhere in a PL/SQL construct or a SQL SELECT statement.  For a bind reference, you must precede the parameter name with a colon (:).


A global variable you can create and use outside of a PL/SQL package.


1. The basic program unit in PL/SQL, defined by the keywords DECLARE, BEGIN, EXCEPTION, and END.
2. In Form Builder, a logical container that relates to a database table or view.


1. Contains the same information as the program unit specification, and also includes the actual implementation of the subprogram (i.e., its sequence of actions).  In most cases, only a body must be defined for a subprogram.
2. In Report Builder, a region that contains the bulk of the report layout (text, graphics, data, and computations).  The report body appears between the report header and trailer pages.


Text and/or graphics that appear in a report every time it is run.  In some products this is called "constant" text or graphics.


A user-defined outline around a layout object, usually used to highlight its contents.  Borders are drawn such that half the width of the border lies outside the edge of the object, and half inside the edge.


See inner bounding box, outer bounding box.


An axis chart that displays two categories of data along one axis.


A query column assigned to a break group.


A group used to break or categorize report data.  All data in query columns assigned to a break group appear above the data in columns belonging to other groups.  Each record fetched for a break group appears only once, while multiple related records in other groups can be displayed.


A report that contains categories that break the report data into sets.


A PL/SQL block that executes each time a breakpoint is reached.  See also:  breakpoint.


A debug action you can place at any executable source line in a PL/SQL subprogram.  A breakpoint interrupts execution of the program unit and passes control to the PL/SQL Interpreter.  Breakpoints allow you to incrementally execute a subprogram and search for runtime errors.  See also:  break trigger.


Refers to a component used to create a specific type of document. For example, Form Builder is used to create forms, while Report Builder is used to create reports.


A datatype defined and supported by the Oracle Server.


A collection of extensions to the PL/SQL language that are designed to be used with the software.  Built-ins include datatypes, procedures, functions, exceptions, and constants.


In Project Builder, macro shipped with Project Builder.  See also:  macro.


A temporary storage area for data during the transfer of that data between the computer and a peripheral, or between parts of a computer.  A buffer prevents loss of information due to differences in the speed or timing of the transfer and speeds up certain functions.


1. An interface element used to select an action item, display a dialog box, or acknowledge the current condition.
2. An object in an application that has a PL/SQL procedure associated with it.  The procedure is generally executed upon a user mouse event.


A PL/SQL procedure associated with an application object, that is executed when a specific mouse event occurs on the item at runtime (e.g. clicking the button).  It does this by establishing a hierarchy for the fetched data containing a break group.


A temporary storage place for database data that is currently being accessed or changed by users, or for data that Oracle Server requires to support users. The terms are often used interchangeably.


An interface that enables you to invoke Forms Developer or Reports Developer component executables from other Oracle products, or a 3GL program.


A chain of subprogram calls, from the initial entry point down to the currently executing subprogram.  Each subprogram call is represented by a frame on the downward-growing call stack, in which newly entered subprograms are added to the bottom of the stack.


  See editor.


In Form Builder, the background object on which you place the interface objects that users will interact with in the runtime application.  A canvas view is usually associated with a window.


Manageable objects that plug in to the client, application server, or database through an open API.


See style sheet.


A label component that allows differentiation between information on the basis of non-hierarchical delineation or compartments rather than sensitivity levels.  With classification, they are used as a means of restricting access to information.


See discrete axis.


An instance of data in a spreadsheet (e.g., Microsoft Excel).


Acronym for Common Gateway Interface. The industry-standard technique for running applications on a Web server.  Whereas standard HTML documents retrieved from a Web server are static (the exact same text is retrieved every time) CGI enables a program running on the Web server to communicate with another computer to generate "dynamic" HTML documents in response to user-entered information.


Acronym for Computer Graphics Metafile.  A file format recognized internationally and used to store and transport object-oriented graphics from one system or program to another.


An Oracle datatype provided for ANSI/ISO compatibility.  A CHAR column is a fixed-length column and can contain any printable characters, such as A, 3, &, or blanks, and can have from 1 to 255 characters or can be null.


A bar, line, symbol, or other graphical object that represents a single value for a field.


A bordered rectangle of any size used to embed Graphics Builder charts in a form or report.


A collection of attributes and properties that defines the format of a chart.


A interface element, appearing as a small square, that a user can toggle on or off.


An error-checking algorithm.


1. An object that is a member of a group, and is immediately below that group object in its group tree.  The objects that compose a group object are children of that group.  Every object is a child of its parent.
2. (Oracle Express) A dimension value at the level immediately below a particular value in a hierarchy. Values of children are included in the calculation that produces the aggregated total for a parent.  A dimension value may be a child for more than one parent if the dimension has more than one hierarchy.  The following example shows the dimension values "Lyon" and "Paris" as the children of "France" in the GEOGRAPHY dimension.


See detail query.


A hierarchical level that denotes the sensitivity of the information that is labeled.  Classifications are used as a means of restricting access to information.


A part of a SQL statement that does not constitute the full statement; for example, a "WHERE clause."


A user, software application, or computer that requests the services, data, or processing of another application or computer (the "server").  In a two-task environment, the client is the user process.  In a network environment, the client is the local user process and the server may be local or remote.


Separation of processing between two CPUs, one acting as the server that provides services in a transaction and the other as the client in the transaction, requesting and receiving services.  All responsibilities of shared data management can be processed by the computer running the database management system while the workstations running the database application concentrate on the interpretation and display of data.


A memory buffer.  An object remains on the Clipboard until you cut or copy another object, or until you quit the application.


A user-defined datatype that describes a data unit made up of an indefinite number of elements, all of the same datatype.  Varying array types and table types are collection types.  (Oracle8)


An argument that allows you to specify a file that contains a set of command line arguments for Forms Developer executables.


Contains all the colors available to the windowing system, the drawing surface, or a window and its views.


1. A vertical space in a database table that represents a particular domain of data.  A column has a column name (e.g., ENAME) and a specific datatype (e.g., CHAR).  For example, in a table of employee information, all of the employees' names would constitute one column.  A record group column represents a database column.
2. In Report Builder, a data model object created automatically for each column expression in a query's SELECT list, or created manually to perform summaries, formulas, or act as a placeholder.


In an Oracle8 relational table or object table, a column whose definition is based on an object type.  The column is a composite, the parts of which correspond to the attributes of the object type.


An operating-system command line.  Most Oracle products can be invoked from a command line using a number of executable arguments.


A language construct for the inclusion of explanatory text in a program, the execution of which remains unaffected.


To make changes to data in the database permanent.  Before changes are stored, both the old and new data exist so that changes can be stored or the data can be restored to its prior state.


(Oracle Express)

>	Greater than

<	Less than

=	Equal to

<=	Less than or equal to

>=	Greater than or equal to

<>	Not equal to

For numbers, the operands are widened to the least common type (Integer is preferred over Long, which is preferred over Single, which is preferred over Double). For Strings, the comparison is case-sensitive and is based on the collating sequence used by the language specified in the Windows Control Panel. The result is 0 for FALSE and -1 for TRUE.


To translate a source program into a binary, executable format.  PL/SQL program units must be compiled before they can be executed.


A specific target object that is a part of a larger application; e.g. a form in an order entry system, or a library that is shared among many other elements.  See also:  target.


The simultaneous access of the same data by multiple users executing different database applications or the same application.  In database software concurrency requires additional logic to ensure that all users see consistent data and that all changes are made in the proper order.


An expression whose value is either true or false, such as X> 100.  For example, you can set a condition in a query when you want the query to display only those rows that evaluate as true in your expression.


Layout editor mode that prevents child objects from being moved or resized on or outside their parent objects.


To log on to a database.  You must connect if you want to create or modify queries or access an application stored in a database.


The set of parameters, including a protocol, that SQL*Net uses to connect to a specific Oracle instance on the network.


A rule or restriction concerning a piece of data (such as a NOT NULL restriction on a column) that is enforced at the database level, rather than the object or application level.


A PL/SQL code structure.  There are two types of constructs: non-value constructs do not return a value; value constructs return a value.


A work area in which Oracle Server stores the current SQL statement, and if the statement is a query, the result's column headings and one row of the result.  Also referred to as cursor.


An axis that plots values that begin with one value and continue until they reach another value.  Thus, these values are mathematically related.  Dependent data is usually plotted along this axis, also called the value axis.


The four corner points of the virtual rectangle that constitutes an object's ideal shape.  When you select an object on the layout, its control points appear.  Depending on the object selected, you may be able to modify it by dragging a control point.


The two-dimensional grid on which drawing takes place.


The type of x, y units used to place and size objects in the Layout Editor view.  The coordinate systems available are 1) character, which uses the platform's native character cell size, and 2) real, which can be in units of pixels, centimeters, inches, or points.


The location points for objects appearing in the layout.  x and y coordinates determine the horizontal (x) and vertical (y) placement of objects.


To store a replica of a selected object on the Clipboard, so that it may be pasted elsewhere in an editor if desired.


A subquery based on the same tables as the parent query (i.e., references columns in the tables included in its parent query).


Group that owns two or more other groups and performs a mathematical cross product (i.e., correlates values between them).


See matrix cell.


1. A small icon representing the position of the mouse.  The shape of the cursor varies, depending on the selected tool.
2. An internal pointer to data retrieved by a query.  A cursor points only to one row of data at a time; however, you can use built-in subprograms to move the cursor to any row in the data set.


(Oracle Express) A formula created by a user, which allows fine-tuning of data analysis. You create custom measures using base measures in the database. For example, if the database contains the existing measure Volume Share, you can use this measure to create a custom measure named Volume Share Year Ago. This custom measure would allow you to look at a product's absolute share from the previous year.


To delete one or more objects and store them in the Clipboard, so that they may be pasted elsewhere in an editor, if desired.


A view is damaged when it is totally or partially occluded by another view.


A set of tables and views owned by the database administrator.  It is a central source of information for Oracle Server and other relational databases.


A data model object used to define a master/detail (parent-child) relationship between a group and a query.


A relational model that defines what data should be fetched from the database, what values should be computed, and how data should be ordered in a report.  Report Builder objects that define the data model are queries, groups, columns, parameters, and links.


A source for data returned by a query, including database objects such as tables, views, synonyms, snapshots, and queries stored as views.


In Project Builder, a node in the Project Navigator denoting a project item that governs the structure of an open project.  For example, the Global Registry node denotes the Global Registry, which contains a list of local registries and a list of global type definitions.


A set of dictionary tables and user tables that are treated as a unit.


A stored PL/SQL block that is implicitly executed when a triggering INSERT, UPDATE, or DELETE statement is issued against the associated table in the database.  See also:  debug trigger.


A standard form of data.  Some common Oracle datatypes are CHAR, VARCHAR2, DATE, NUMBER, LONG, RAW, and LONG RAW.


An Oracle Server datatype.  A date column may contain a date and time between January 1, 9999 BC and December 31, 9999 AD.


An axis that plots date values that begin at one date and continue until they reach another date.


To detect, diagnose, and eliminate runtime errors in programs.


A user-specified event placed in a PL/SQL subprogram, usually for the purpose of troubleshooting runtime errors.


A conditional debug action you can place at any executable source line in a PL/SQL subprogram.  If the specified condition is met, the specified action is taken before execution of the subprogram resumes.  See also:  database trigger.


The Procedure Builder functionality within the software component used for testing and debugging.


In Oracle8, object types and objects are composites, built of parts or attributes.  Forms Developer or Reports Developer treats each part/attribute as an independent, individually-selectable data item.  This treatment results in a deconstructed object (sometimes also known as a flattened object).  The object is not an homogeneous entity within the Developer environment.


A piece of data that depends on other data for its value.  For example, an employee's  years of service may have the value 10, which is dependent upon the value of the employee's name.  Also called value data.


A value supplied by the system when a user does not specify a required command parameter or attribute.


To prepare and provide a completed application for distribution and deployment.


In Project Builder, the mechanism used by Project Builder to determine how to compile files that are referenced in projects.  Items toward the top left of the tree depend on items toward the lower right; so, for example, if a header file is either out of date or more recent than the executable file it is used to build, then the Project Builder will rebuild the executable file, given a Build command.  Dependencies also extend to subprojects.  For example, if a subproject consisting of a function library has been rebuilt, the Project Builder "knows" the dependent project will need to be rebuilt in order to use the updated library functions.  See also:  dependency view.


In Project Builder, shows files in the Project Navigator in the order in which they depend on each other, with project nodes at the highest point in the hierarchy, followed by target nodes, which are followed by buildable components of those targets.  For example, an executable form depends on and will be followed by an .fmb file, which may depend on and be followed by a library used for a USEREXIT procedure, and so on.  See also: project view, target.


1. An object that appears in another object's group tree at any position below that other object.  Every object is a descendant of its antecedents.
2. (Oracle Express) A dimension value at any level below a particular value in a hierarchy. Values of descendants are included in the calculation that produces the aggregated total for an ancestor.  The following example shows the dimension values "France," "Lyon," and "Paris" as descendants of "Europe" in the GEOGRAPHY dimension.


The interface used to design different components of a Forms Developer or Reports Developer application.


See Oracle Designer.


An application modeling, design and generation toolset.  Using Oracle Designer, you can generate forms and menus from module definitions recorded in the Oracle Repository.


When defining a master/detail report, the detail query retrieves all related records for each record retrieved by the master, or parent, query.


A partial screen or window that prompts you to enter information necessary to complete an operation.


An intermediate representation of a program unit, generated by the compiler.  The DIANA includes all of the syntactic and semantic information for a compiled program unit.  In order to compile a reference to a program unit, the compiler must have access to the referenced program unit's DIANA.  For example, if program unit A calls program unit B, the DIANA for B must be available before A can be compiled.


(Oracle Express) A type of database object that is a list of values that provide categories for data. A dimension acts as an index for identifying values of a variable. For example, if you have sales data with a separate sales figure for each month, then the data has a MONTH dimension; that is, the data is organized by month. A dimension is similar to a key in a relational database.

Any item of data within a multidimensional variable can be uniquely and completely selected by specifying one member from each of the variable's dimensions. For example, if a sales variable is dimensioned by MONTH, PRODUCT, and MARKET, specifying "January" for the MONTH dimension, "Stereos" for the PRODUCT dimension, and "Eastern Region" for the MARKET dimension uniquely specifies a single cell in the variable. Thus, dimensions offer a concise and intuitive way of organizing and selecting data for retrieval, updating, and performing calculations.

A dimension can be simple, with values that are single text or integer values, or it can be conjoint, with values that are combinations of values in other dimensions. A composite is not a dimension, but it is a conjoint-like internal object that Express treats like a dimension for the purpose of handling sparse data.


(Oracle Express) One element in the list that makes up a dimension. For example, a computer company might have dimension values in the PRODUCT dimension called "LAPPC" and "DESKPC." Values in the GEOGRAPHY dimension might include "Boston" and "Paris." Values in the TIME dimension might include "MAY96" and "JAN97."


An interface element state that means a menu item, button, etc., cannot be used in the current context; i.e., it does not respond to keyboard or mouse input.


An axis that plots distinct values at fixed intervals.  These values are not mathematically related.  Independent data is usually plotted along this axis, also called the category axis.


A Graphics Builder document containing any combination of charts, images, text objects and shapes.


In Form Builder, an item that stores or displays information that must be fetched or assigned programmatically with PL/SQL.


As it pertains to the call stack, in which newly entered subprograms are added to the bottom of the stack.  The earliest frame, corresponding to the initial program entry point, is at the top of the stack, while the latest frame, associated with the most deeply nested subprogram call, is at the bottom of the stack.


Press and hold down a mouse button while you slide the mouse pointer to a particular location in a window.


(Oracle Express) To navigate up and down through the levels of aggregation in a dimension that has a hierarchy. When selecting dimension values or viewing data, you can expand or collapse a dimension hierarchy by drilling down or up in it. Drilling down expands the view to include child values that are associated with parent values in the dimension hierarchy. Drilling up collapses the list of descendant values associated with a parent value in the dimension hierarchy.

You can click on a plus icon ( [image]) to drill down on (expand) the hierarchy or on a minus icon ( [image]) to drill up on (collapse) the hierarchy.

In the Selector, you can click on the drill icon ( [image]) to display the Drill dialog box so you can select a level of detail for the entire dimension.


An option that allows you to copy objects directly on the layout without affecting the contents of the Clipboard.


(Oracle Express) A saved selection that can have different dimension values each time it is evaluated. The selected dimension values might differ from use to use. In contrast, a static saved selection is an unchanging list of dimension values. A dynamic saved selection script might include "Select the last three Months", while the script for a static saved selection might have "Select February 1996, March 1996, and April 1996".


Acronym for Extended Binary-Coded Decimal Interchange Code.


The boundary of an object.


A display box on the Layout Editor tool palette that shows the current settings for the edge, fill, and text patterns and colors.


A work area in which you perform a specific set of tasks, such as creating a program unit or designing an application.


A thing of significance about which you may need to record information.  Elements are described by attributes and associations to other elements.


Any element held in the dictionary is classified as being of a particular type.  Examples of element type are entity, attribute, program module, table, diagram, text, softbox.  Occurrences or instances of these are called elements.


(Oracle Express) Displays a dialog box related to the task you are performing, usually so you can select one or more values that you need.


An interface element state that means that a menu item, button, etc., can be used in the current context, that is, it responds to keyboard or cursor/mouse input.


An object that contains another object.  An object is considered to be enclosed by another object only if all of the following are true:  both objects belong to the same region (Body, Margin, Header, or Trailer);  the outermost of the two objects is a frame or repeating frame;  the outermost of the two objects is behind the other object;  the innermost of the two objects lies entirely within the borders of the other object.


The practice of scrambling (encrypting) data in such a way that only an intended recipient can unscramble (decrypt) and read the data.


The user's computer-based workplace, including the tools typically used and their configurations. For Project Builder, this refers to the subset of tools that are used to complete various tasks related to developing Forms Developer applications.


A warming or error condition generated from a PL/SQL subprogram.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values associated with data that meets cutoff terms that the user specifies. For example, the user can select all products whose dollar sales were greater than $10,000 for the week ending December 23, 1995 in the Boston market.


An argument you can pass to a product executable, such as 'OPENFILE=my_disp' and 'PRINT=YES'.  These arguments usually are specified when the executable is invoked from a command line.


See run.


To store a copy of an object, module, selected text or image to a file or database.  In Project Builder, the process of writing out a file containing project, type, action, and/or macro definitions in a portable format for distribution to others who may work on heterogeneous platforms.  See also:  export file, import.


In Project Builder, the shareable, portable file created by exporting a project.


1. A PL/SQL construct combining variables, constants, literals, and operations on their values.
2. (Oracle Express) One or more data values that are specified in an Express language program. For example, you can specify expressions as arguments to programs or functions. An expression can be any of the following:

•	A single, literal value (for example, 10)

•	A variable or formula that contains one or more values

•	A function that returns one or more values

•	A calculation that combines values, such as variables, formulas, or functions, with arithmetic or Boolean operators


See library.


An ANSI-standard SQL SELECT statement that can be referenced by other Oracle products.


(Oracle Express) A group of related dimension values that correspond to the levels of the dimension hierarchy. Dimension values within a family can relate to each other as ancestor, parent, child, and descendant.  The following example shows family relationships for the dimension value "France" in the GEOGRAPHY dimension.


(Oracle Express) A Selector dialog box tool that allows the user to select a family of dimension values for a particular hierarchy. A family includes a parent and all of its descendant dimension values. For example, the user can select all of the family members below the Chicago market level in the Geography dimension.


1. An interface element in which you enter, edit, or delete data.  2. In Graphics Builder or Report Builder, a layout object that define how the data for a specific query column appears.


In Graphics Builder, a collection of attributes and properties that determines how dependent data (values) are represented as chart fields, such as bars or lines.


In Project Builder, a node in the Project Navigator denoting a file stored in the file system.  For example, the global and local registry nodes correspond to global and local registry files.


The area within an object to which a fill (color or pattern) should be applied.


A PL/SQL function or anonymous function that restricts the data displayed by a group.


A computer that regulates access to computers on a local area network from outside, and regulates access to outside computers from within the local area network.


See deconstructed object.


Layout Editor mode that automatically resizes or shrinks parent objects when child objects are moved or resized, and adjusts the positions of other layout objects that might otherwise be affected by the repositioning or resizing of the objects.


The state of an entity that is able to respond to input from the user or the client.  If an entity has the keyboard focus, it can receive events when the user presses a key.  If a drawn view has the drawing focus, it can respond to client routines that affect drawing.


The black part of a pattern.  You apply color to the foreground element using the Edge Color palette.


A value or column in one table that refers to a primary key in another table.


In Report Builder, a default layout style in which labels appear to the left of fields, and each record prints on a separate logical page.


In Report Builder, a default layout style that intermixes boilerplate and fields, wrapping lines at "word" breaks.


(Field Properties)  A setting that defines the appearance of the value of a field.  For example, a format mask is used to specify the display of currency amounts and dates.


A PL/SQL function that allows you to dynamically change the formatting attributes of an object.


(Oracle Express) A type of database object that represents a stored calculation, expression, or procedure that produces a value. A formula provides a way to define and save complex or frequently used relationships within the data without resaving the data itself. Each time you use a formula, Express performs the calculation or procedure that is required to produce the value.


A user-created column that gets its data from a PL/SQL function or expression, a user exit, a SQL statement, or any combination of these.


In Graphics Builder, the part of a chart template that defines the basic structure of a chart, but does not determine the way the data is plotted.
2. In Report Builder, a layout object used to enclose other layout objects and control the formatting, frequency, and positioning of several objects simultaneously.


A PL/SQL subprogram that performs a specified sequence of actions, and then returns a value.  Can reside and execute on the client and the database server.


To save an application to a file or database in a binary format that can be executed by Runtime and Batch executables.


The Form Builder executable used to save an application to a file or database in a binary format.


A Project Builder registry that stores information common to an entire Forms Developer or Reports Developer installation.  This information is restricted to type definitions, and their associated actions and pre-defined or user-defined properties.  The use of the Global Registry is optional; its functions can be performed by individual user registries.  See also: registry, user registry.


A logical container that exists across an application.  When an application uses a global variable, the application maintains the variable until the application is exited, or until another object explicitly removes it.


To give a user access to a module.  Only a module's creator can grant its access to other users.


In Graphics Builder, the lines that separate rows and columns in the Layout Editor.


1. An object that is composed of several other objects.
2. In Report Builder, a data model object that is created automatically to contain all the columns selected by a query, or created by the user to modify the hierarchy of the data appearing in a report;  it is used primarily for creating breaks in a report, as well as for resetting computations.
3. In Project Builder, collections of related items available via submenus off the Launcher.  Groups allow users to set up the Launcher much like the Windows 95 Start menu, with arbitrary "groups" as entries that pop up to reveal other items and/or groups.  For example, a user could define a group named "Project Docs", containing a project schedule, to-do list, component specifications, etc.; some files may be .TXT files, other .DOC files.


A PL/SQL function that restricts the data fetched by a group.


A hierarchical model-similar to a "family tree"-that describes the relationships between group objects and the objects that compose them.


Acronym for graphical user interface. The use of pictures rather than just words to represent the input and output of a program.  Programs with GUIs run under a windowing system (such as  X Windows, Microsoft Windows, Apple Macintosh, and so on).  GUI programs display icons, buttons, and so on, in windows on the screen;  users control the GUI programs mainly by moving a pointer on the screen (typically controlled by a mouse).  Also known as a bitmapped interface.


An internal pointer to an application object.  In order to reference an object in a PL/SQL program unit, you must pass its handle as an argument to the appropriate subprogram.


An optional report region that can contain introductory material for the report, including text, graphics, data, and computations.  The report header appears first, before the body and trailer.


A node in the Object Navigator denoting a type of object which can be contained within or associated with a report.  Selecting a heading node does not select an object in the report.


(Field Properties)  A property that specifies whether Report Builder will suppress the indicated field at its location in the layout.  If Hidden is specified, the field's value will appear only where referenced in text objects (using &fieldname).


(Oracle Express) A means of organizing and structuring data. A hierarchy exists when values within a dimension are arranged in levels, with each level representing the aggregated total of the data from the level below. Some dimensions have multiple hierarchies based on them.

The following example shows a hierarchy based on the GEOGRAPHY dimension, in which dimension values are arranged in five levels. Data at the Customers level is aggregated into the Cities level, which, in turn, is aggregated into the Countries/Areas, Continents/Regions, and Global levels.


Acronym for Hypertext Markup Language.  A tag-based ASCII language used to specify the content and links to other documents on Web servers on the Internet.  End users with Web browsers view HTML documents and follow links to display other documents.


Acronym for Hypertext Transfer Protocol. The protocol used to carry WWW traffic between a WWW browser computer and the WWW server being accessed.


A reference (link) from some point in one document to (some point in) another document or another place in the same document.  A Web browser usually displays a hyperlink in some distinguishing way (in a different color, font or style).  When users activate hyperlinks (by clicking on them with a mouse) the browser displays the target of the link.


A collection of documents containing cross-references which, with the aid of a Web browser, allow readers to move easily from one document to another.


Cross-references which, with the aid of a Web browser, allow readers to move easily from one document to another.


Acronym for interface C definition-a PL/SQL application programming interface to functionality implemented in C.


A graphic representation of a window or tool.


A bitmapped object that can be stored and loaded into an application.  The client cannot modify an imported image.


In Project Builder, a project item, usually the result of automatic generation, that Project Builder recognizes and for which it automatically creates entries in the Project Navigator.  For example, Project Builder can recognize .OBJ files, generated as an intermediate step during the compilation of C source files, and create entries for them in the Project Navigator.  Although resetting the properties of an implied item is of limited use (the next compilation will destroy changes) such items can be useful, as they can be examined via actions such as Edit, View, and Print.  See also: item, action.


1. To read a module from the file system or database, and incorporate it into an application.
2. To read in a file containing project information.


A piece of data that does not depend on other data for its value.  For example, an employee's name may have the value Jones, which is independent of the values of other employee's names or associated data.  Also called category data.


An optional structure associated with a table that is used by Oracle Server to locate rows of the table quickly, and (optionally) to guarantee that every row is unique.


In Project Builder, to obtain information for an action, type, macro, or property definition from an ancestor node in the dependency tree.  If related attributes exist in an ancestor node, they may be inherited.  Thus, filesystem items like forms and documents may inherit action definitions from subprojects, projects, the user registry, or the Global Registry; projects may inherit type definitions from the local or the Global Registry; and so on.


The virtual rectangle that constitutes an object's ideal shape and connects its four control points, regardless of edge thickness or other attribute settings.


The file used to build a target: for instance, an .FMB is the input for an .FMX.  Also called source.


A mode in which each character you enter is inserted at the cursor, pushing the following characters to the right.  The opposite of replace mode.


A worldwide TCP/IP-based network of computers.


A file containing any mixture of PL/SQL source, Procedure Builder commands, and SQL statements.


An internal TCP/IP network, access to which is restricted (via a firewall) to individuals inside the company or organization.  An intranet provides similar services within an organization to those provided by the Internet, but is not necessarily connected to the Internet.  A common example of an intranet is when a company sets up one or more Web servers on an internal network for distribution of information or applications within the company.


A four-part number with no more than three digits in each part that uniquely identifies a computer on the Internet.


In Project Builder, an object in the file system associated with the project, such as a form or a document, pointed to or represented by a node in the Project Navigator.


In Project Builder, an entry in the Project Navigator window, consisting of an icon and a descriptive title.  Nodes point to actual items in the filesystem, such as Form Builder files and documents.  See also: node, item.


Acronym for Java ARchive.  A file used for aggregating many files (Java class files, images, and so on)  into one file.


A computer language that supports programming for the Internet in the form of platform-independent "applets".


Combining data from two (or more) tables in a single SELECT statement.


  See alignment.


1. Part of a command line syntax that must be supplied with a corresponding argument.  2. A required part of a PL/SQL construct.


Text identifying the values or meaning of an application's visual objects.


(Oracle Express) A position in a dimension hierarchy. Each level above the base level represents the aggregated total of the data from the level below. For example, the TIME dimension might have ascending levels such as Month, Quarter, and Year. Within a dimension hierarchy, a dimension value at one level has a family relationship with the dimension values at the levels above and below that level.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values based on their level in a particular hierarchy. For example, the user can select all of the dimension values at the Key Account level in the Geography dimension.


The area of an editor in which you can create, modify, position, or delete objects.


A unit of measurement for ensuring a consistent measurement system across different display devices.  Used to specify a position on the layout, or the dimensions of an object.


A reference to a parameter used to represent a string of text in a SQL SELECT statement.  For a lexical reference, you must precede the parameter name with an ampersand (&).


A collection of one or more PL/SQL program units that are stored together in a file on the client file system or in the database.  Program units stored in a library can be referenced by several applications at once.  Unlike stored program units, which reside and execute in the database, program units in libraries always load and execute within the PL/SQL engine on the client side.  To reference program units that are stored in a library, you must first attach the library.  See also:  attached library.


A data model object used to define a master/detail (parent-child) relationship between a group and a query.


The name of a file to which a boilerplate object is associated.  At runtime, Report Builder imports the file's contents into your report layout.


A list of items within a dialog box.  Usually, the list box offers choices for selection, and it is scrollable.


In Form Builder, an item that displays a list of choices.


Also called LOV. A scrollable popup window that provides the user with a single or multi-column selection list.


(Oracle Express) A Selector dialog box tool that allows you to select dimension values from a list of the currently selected values in the dimension.


1. The database on the computer running the application.  2. The database to which an application is connected.  This database parses and executes all SQL statements generated by the application.


See user registry.


A PL/SQL variable declared only within the scope of the current program unit.


(Oracle Express)

Not	Unary Not -- Operand can be integer or long. The operation is performed bitwise (one's complement).

And	And -- Operands can be integer or long. The operation is performed bitwise.

Or	Inclusive Or -- Operands can be integer or long. The operation is performed bitwise.

Xor	Exclusive Or -- Operands can be integer or long. The operation is performed bitwise.

Eqv	Equivalence -- Operands can be integer or long. The operation is performed bitwise. (A Eqv B) is the same as (Not (A Xor B)).

Imp	Implication -- Operands can be integer or long. The operation is performed bitwise. (A Imp B) is the same as ((Not A) OR B).


One page of your actual report (it may be displayed on one or more physical pages).


In a PL/SQL subprogram, a conditional statement that is repeated until the condition is no longer met.


In Project Builder, a type-specific variable that may be used to customize and extend actions.  A macro may be either a constant or a simple expression (which, in turn, may contain other constants and/or expressions).  The use of macros adds great flexibility in issuing command options, and in allowing the user to modify sets of commands by changing one property definition.


A default layout that displays records in one or more columns on the page.  Fields appear directly beneath each other in a single repeating frame.


An optional report region that appears at the top and bottom of each logical page in the body region.  The margin may include any layout object, but typically contains boilerplate and fields (for page numbers, page totals, grand totals, and current date and time).


A default layout in which the detail records appear below the master records.  Master records appear in form layout style, while detail records appear in tabular layout style.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values by matching characters in dimension value names to characters that the user specifies. For example, the user can select all dimension values in the Product dimension at the Brand level that contain the characters "new."


A repeat direction that displays each record of a repeating frame as a cell of a matrix.


A default layout, resembling a grid, that formats the four sets of data necessary for a matrix report; one set of data displays as a row of labels, one as a column of labels, one set creates the grid, and one set fills the cells of the grid.


A cross-tabulation of four sets of data:  one set of data displays across the page; one set of data displays down the page; one set of data is the cross-product, determining all possible locations in which the across and down data relate and placing a cell in those locations; and one set of data displays as the "filler" of the cells.


(Oracle Express) Data that can be examined and analyzed, such as sales or cost data. You can select and display the data in a measure. Measures can be stored as variables or relations, or measures can be calculated by means of formulas.


A unit of memory equal to 1,048,576 bytes (1024 x 1024). Often rounded to one million bytes.


A modal window that notifies you of a condition that occurred because of your last action.  You must respond to a message box.


Executable code attached to an Oracle8 object through its object type definition.


A window that elicits a response from the operator before the application can continue.


An unrestricted window that can have as much functionality as the runtime window manager can support.


1. An object that can be shared by multiple applications.  External queries and PL/SQL libraries are examples of modules.  2. In Form Builder, a major component of an application (i.e., a menu module).


A field in a window or dialog that extends for several lines, allowing you to scroll vertically through the information.


(Oracle Express) A special data value that indicates that data is "not available" (NA). NA is the value of any cell to which a specific data value has not been assigned or for which data cannot be calculated.


Matrix report in which either the across and/or down dimension contains one or more master/detail relationships.  There is no limit to the amount of nesting allowed.


A datatype indicating that the data will be fetched when the page on which it appears is formatted (instead of fetched and cached until formatted).


1.  A specific location in the Object Navigator object hierarchy.  Nodes can be expanded to reveal information about an object, such as cross references to other objects.  2.  In Project Builder, an entry in the Project Navigator.  See also:  item, item node, organization node.


A report column that references a database column of datatype NOCACHE.


The absence of a value.


(Oracle Express)

^	Exponentiation,

-,+	Unary minus and plus,

*, /	Numeric multiplication or division. For division, the result is a double.

\	Integer division. The operands can be integer or long.

Mod	Modulus or Remainder. The operands can be integer or long,

-, +	Numeric addition and subtraction. The + operator can also be used for string concatenation.


1.  An item that can be placed on the layout.  The following are examples of objects:  rectangle, line, ellipse, arc, polygon, polyline, rounded rectangle, freehand, chart, text, symbol, and text field.  2.  In Oracle8, an instance of an object type.  An object can be a row in an object table, or the portion of a row contained in a column object in a relational table.


See column object.


A container for a group of objects, used to provide the ability to copy or reference related objects.


See handle.


The window containing a hierarchical list of objects for the current session.  The list appears in outline form, and enables the user to accomplish several tasks such as creating, editing, renaming, and deleting objects.


In Oracle8, a table whose definition is based on an object type.  Each attribute in the object type becomes a column in the object table.  Each row in the table is an individual Oracle8 object.


In Oracle8, a user-supplied definition or template, upon which objects can be built.  An object type is a composite, whose parts are attributes.  Each attribute has a name and a datatype, and the object type as a whole has a name.  An object type may also include one or more methods.


Acronym for Open Database Connectivity.  A standard for accessing different database systems.  An application can submit statements to ODBC using the ODBC flavor of SQL.  ODBC then translates these to whatever flavor the database understands.  Using the Oracle Open Client Adapter (OCA), an application can access different database management systems in one consistent manner.  This allows an application developer to develop, compile, and ship an application without targeting a specific DBMS.


Object Linking and Embedding.


An application that can store and display OLE objects.


An application that creates OLE objects.


See built-in datatype.


An environment variable that indicates the root directory of Oracle products.


An entry in the Project Navigator, such as "Types", "Projects", "Form Files", etc., used to help organize the Navigator and indicate the filetypes of child items.  It may also correspond to a data structure within certain types of filesystem objects.


Represented in x and y coordinates.  The origin of a view indicates the location of the view on its parent's canvas.  The origin of a canvas indicates the position of drawing on a drawn view.


The smallest virtual rectangle that completely surrounds an object.


When an object's contents cannot fit on the current logical page.  In the event of overflow, some of the contents are moved to the next logical page.


A PL/SQL function provided with the software that can be referenced anywhere within a program unit.


A method of encapsulating and storing related procedures, functions, variables, and other package constructs together as a unit in the database or on the client.  While packages provide the database administrator or application developer organizational benefits, they also offer increased functionality and database performance.  The software provides several built-in packages which contain PL/SQL constructs that can be referenced by client-side program units (e.g., TEXT_IO package).  Several packages are also supplied with the Oracle database server for referencing by stored program units (e.g., DBMS_OUTPUT package).


Includes the actual implementation of the package, which may include private subprograms and datatypes.  The body is optional if the package consists only of declarations.


Declares the public interface to the package-that is, the datatypes and subprograms that can be referenced by other program units.


(Oracle Express) 1. A slice of data included in a report. Additional pages display additional slices of data.

The following figure shows three pages of data.

2. In Express, a page can also refer to a unit of storage in an Express database.


(Oracle Express) A representation of how data selected for a query will appear in your spreadsheet. The page layout shows three edges -- Across, Down, and Page. The edges indicate how the multi-dimensional datacube defined by the query will appear in the two-dimensional spreadsheet. Dimension tiles display the names and positions of the dimensions. A dimension tile on the Across edge indicates that this dimension will appear as a column. A dimension tile on the Down edge indicates that this dimension will appear as a row. A dimension on the Page edge indicates that this dimension will appear in a page box at the top of the results.


A setting that controls whether to move the current object and its children to the next logical page.  You can set page breaks to occur before or after the current object appears in the report output.


An interface element that displays tools, colors, or patterns available in an editor.


A distinct portion of an editor where work is performed, usually resizeable.


The number of physical pages needed to print one logical page.


1. A PL/SQL construct used to pass information to a subprogram.  For example, in the subprogram call MYPROC (x),x is a parameter.  2. In Forms Developer, parameters are used to pass information between components such as Form Builder and Graphics Builder.  3. A variable you can change at runtime.


A group of parameter names and associated values used to pass information between Forms Developer components.


1. An object that is immediately above another object in its group tree.  A group object is the parent to each of the objects that compose it.  Every object is the parent of its children.
2. (Oracle Express) A dimension value at the level immediately above a particular value in a hierarchy. The parent value is the aggregated total of the values of its children.  The following example shows the dimension value "France" as the parent of "Lyon" and "Paris" in the GEOGRAPHY dimension.


To place the contents of the Clipboard (cut or copied objects) at the current cursor location.


A graphical property you can apply to the edge or fill of most objects.


The machine code or instruction list for a compiled program unit.


Acronym for Portable Document Format.  A file format (native for Adobe Acrobat) for representing documents in a manner that is independent of the original application software, hardware, and operating system used to create the documents.  A PDF file can describe documents containing any combination of text, graphics, and images in a device-independent and resolution independent format.


The size of a page that is output by your printer.


The type of element used to plot a field on a chart, such as bar, line, or symbol.


Oracle's proprietary extension to the SQL language.  Adds procedural and other constructs to SQL that make it suitable for writing applications.


A Procedure Builder Interpreter script file.


A PL/SQL library file that contains source code and compiled code. The file can be opened in Procedure Builder for editing.


A text file that contains the PL/SQL source of a single program unit.


A runtime PL/SQL library file that contains executable code only.  The file cannot be opened in Procedure Builder for editing.


A list that pops up when the user performs a particular action.


A number that TCP uses to route transmitted data to and from a particular program.


An action shipped with Project Builder and automatically available to the user via a menu item and/or a toolbar button.  Pre-defined actions include Build, Deliver, and several source control options.  When a pre-defined action is defined for a supported file type, the action is invoked for any selected item of that type when the user calls the action from Project Builder.  See also:  action, user-defined action.


See built-in datatype.


A setting that affects the behavior of the application's interface.


(Oracle Express) View the script that would be generated if you accept the current criteria. In the dialog box for any Selector tool you can preview your selection by choosing the Preview button.


The interface with which you view and scroll through report output online.


A column in a database table whose members consist of unique values that can be used to identify a row in a table.


See built-in datatype.


In a printer definition file, an escape sequence to which you assign a printer code that can be referenced in a report.


A file that contains a printer definition in text (e.g., ASCII or EBCDIC) format.


A PL/SQL subprogram that performs a specified sequence of actions. .  Can reside and execute on the client and the database server.


A PL/SQL code structure that can be independently recognized and processed by the PL/SQL compiler.  Anonymous blocks, subprogram specifications and bodies (procedures and functions), and package specifications and bodies are types of program units.  Program units can reside and execute on the client and the database server.  See also:  stored program unit.


The basic data structure created by Project Builder.  Projects are collections of pointers to all the files you consider part of your application, or otherwise want to group together conceptually.  You can define the editors, compilers, and other tools you use to work with the items contained within a project.  All project information is stored within a project registry.  See also:  project item, project file, export.


In Project Builder, project files are all the files associated with an application.  Project files can be of any type, including forms, reports, displays, 3GL modules, documentation, and test scripts. See also:  project, project item.


In Project Builder, anything for which properties may be defined, including all entities stored under the Projects node, types, actions, and macros. See also: project, project file.


The window containing a hierarchical list of project items for the current session.  The list appears in outline form, and enables the user to accomplish several tasks such as creating, editing, renaming, and deleting objects.  Although only one is visible at any time, the user can choose from two different schema by which to organize the objects.


The top-level node for a project.  It represents or points to the project file.  See also: project, project file.


In Project Builder, the file that stores all the information associated with a project:  files belonging to the project, types, actions, and macros defined for the project, and so on.


The project view shows objects organized by their type, and by their project/subproject relationships.  The projects are organized alphabetically by project file, then alphabetically by category.  See also:  dependency view, project, project file, view.


A dialog that assists the user in accomplishing the steps necessary to create a new project or sub project.


A characteristic of an object that determines the behavior or appearance of that object.


A named object that contains a list of properties and their settings used to globally control the appearance and functionality of objects based on that class.


A string you can enter when connecting to a database or server that allows you to connect to a remote database or server.


(Oracle Express) When you select values for one of the dimensions in a measure, the other dimensions that make up that measure are known as qualifying dimensions.

Suppose your Sales measure is dimensioned by Product, Month, and Geography. If you select the top ten cities based on Sales, you must also specify which product and month you want to consider when you compare Sales values. In this case, Product and Month are the qualifying dimensions.


A SQL SELECT statement that specifies the data you wish to retrieve from one or more tables or views of a database.


A PL/SQL function that, when executed, filters data retrieved by a query.  Only the data that meet the conditions in the function are charted.


An option that terminates the current session and returns the user to the operating system.  On some systems, Quit is Exit.


A control (similar to a check box), appearing in sets of two or more, only one of which may be either "on" or "off" at any given time.


A set of two or more radio buttons, only one of which may be either "on" or "off" at any given time.


(Oracle Express) A Selector dialog box tool that allows the user to select consecutive time periods as dimension values. These time periods can be based on any of the following:

•	A specific number of the most recent time periods

•	A beginning time period and a most recent time period

•	A beginning and ending time period

For example, the user can select dimension values for the range from the week ending November 25, 1996 through the week ending December 30, 1996.


A cipher designed by RSA Data Security, Inc. which can accept keys of arbitrary length, and is essentially a pseudo random number generator with the output of the generator being XORed with the data stream to produce the encrypted data.  For this reason, it is very important that the same RC4 key never be used to encrypt two different data streams.


Acronym for Relational Database Management System.  A database that allows the definition of data structures, storage and retrieval operations, and integrity constraints.  In such a database, data and relations between them are organized in tables.


A file that contains a single report definition in binary format.  .RDF files are used to both run and edit reports.


A file that contains a single report definition in binary format.  .rep files are used solely to run reports; you cannot edit a .rep file.


The ability to query the data throughout a database as of a single point in time.


One row fetched by a SQL SELECT statement.


An internal data structure object with a column/row framework, that belong to the form module in which they are defined.


A type of column that points to data in other column objects or object tables (Oracle8).


A line that appears at a specified value on a chart.


(Oracle Express) Fetch the most recent data from an Express database after query results are displayed in your report. When you open a saved Express query, the results are refreshed automatically.


To add the definition of a type or a new project to either the global or local registry.  Upon being registered, a new type can have actions defined for it, while a new project can have its referenced files identified as specific types, so that actions can be invoked against them.  See also:  registry.


A global and/or user-specific configuration file used to store project definitions and environment information.  See also:  Global Registry, user registry.


A symbol used in search criteria to indicate a comparison between two values, such as the equal sign in "WHERE DEPTNO = 10." Rows in which the comparison results in "true" are returned in the result (fetched), while rows in which the comparison returns "false" are rejected from the result.


A database on a computer other than the local database.  Usually a computer on the same network, but at a different node (i.e., a database that you use through a database link).


A layout object used to display rows of data that are fetched for a group.


A mode in which each character you type replaces the current character at the cursor.  The opposite of insert mode.


The objects that are used to define a report's data model and layout.  Report-level objects are assigned to a single report, and cannot be shared by other reports or other Oracle products. Objects include reports, queries, external queries, external PL/SQL libraries, groups, columns, parameters, links, frames, repeating frames, fields, boilerplate, and anchors.


Available on Windows NT and Windows 95 only, waits for any command lines to run a report, then places that report in its queue to run in the background on the local server.  Typically command lines are received from Form Builder or Graphics Builder via RUN_PRODUCT, or from another report via SRW.RUN_REPORT.  You can also use RWISV60 to submit a report to the Reports Background Engine.


Maintains timestamp and status information about reports managed by the Reports Server.


Available on Windows NT, Windows 95, and UNIX, enables running reports on a remote server.  Queues job requests and allows you to schedule when to run reports.  Use RWCLI60 to send a report to the Reports Server.


Provides an interface between your Web Server and Reports Runtime, enabling you to run reports dynamically from your Web browser.


Provides a connection between a Web Server and the Reports Server.


A file that contains a report definition stored in text (e.g., ASCII or EBCDIC) format.  .REX files are used to port reports from one platform to another. Note that .REX files are no longer required. They are available for backward compatibility.


Refers to the intensities of the red, green, and blue components of a color.


The group object to which all other objects in an application belong.


Top-level node for a project representing user's environment.  May correspond to the user registry or the Global Registry, depending on which registry has been chosen to set defaults.


1. One set of field values in a table; for example, the fields representing one employee in the example table EMP.  2.  To generate a runtime version of an application.


An object in an Oracle8 object table.  Each row in the table is an object.  However, in Forms Developer an object table is deconstructed into individual columns, so that the row object no longer exists as a single entity (only as its separate attributes).


To execute a runtime version of an application or program unit.


Acronym for Rich Text Format.  A non-platform-specific file format based on control words used to represent unformatted text and images in various applications and operating systems.  RTF uses the ANSI, PC-8, Macintosh, or IBM PC character set to control the representation and formatting of a document, both on the screen and in print.


See rep file.


The interface in which users view and interact with a runtime application.


A screen or window appearing optionally at runtime in which a user can modify print options and parameters prior to report execution.


(Oracle Express) A set of dimension values that has been saved either as a list of values or as a script. You can save selections that you build, or your database administrator can create saved selections and make them available to you.

Saved selections are a timesaving feature: each time that you need to re-use a selection, you can simply retrieve a saved selection without having to recreate it.


(Oracle Express) A Selector tool that allows you to retrieve a selection of dimension values that has been saved.


A collection of related database objects, usually grouped by database userid.  Schema objects includes tables, views, sequences, stored program units, synonyms, indexes, clusters, and database links.


The level at, or range in which, an object operates.  For Project Builder:  1.  Describes the range of files affected by Compile and Compile All commands invoked against compilable project items.  2:  Describes the range of files influenced by inheritable definitions.


See SQL script, Interpreter script.


In Report Builder, one of multiple layouts in the same report, each with a different target audience, output format, page layout, page size, or orientation.  For example, a single report can include an executive summary for senior management in one section and also a detailed breakdown for  individual managers in another section.


A SQL statement that specifies which rows and columns to fetch from one or more tables or views.


(Oracle Express) The set of dimension values currently chosen for a dimension, or the script that contains conditions or criteria to specify those values.


(Oracle Express) As shown on various dialog boxes in the Selector, a description of the choices that a user has made in selecting dimension values. It is a translation, in ordinary language, of the Express Language script.


(Oracle Express) A set of tools that you use to choose the dimension values to include, for instance, in a report, table, graph, or dimension list box. For example, you can use the Selector to choose the top 10 cities based on Sales or those cities whose Sales exceeded Quota by 15 percent. The Selector also allows you to sort dimension values and to create and retrieve saved selections.


(Oracle Express) A dialog box or group of dialog boxes that provides a particular way of selecting or sorting dimension values. Each Selector tool is part of the Selector. You can use Selector tools to select dimension values based on their level in the hierarchy, their attributes, the characters in the value name, and so on. You can also use Selector tools to sort the dimension values.


The period between invoking and quitting the executable.


One of two or more objects that have the same parent object in its group tree.  All objects that belong to one group object are siblings.


The combination of an IP address and a port number.


(Oracle Express) A Selector dialog box tool that allows you to rearrange the order of dimension values in a displayed selection. You can sort a selection in ascending or descending order by the following:

•	Alphabet

•	Order in the database

•	Data value

•	Order or level in the hierarchy

•	Time period

You can also sort a selection manually, by dragging and dropping dimension values.


In PL/SQL:  Statements provided in a subprogram or package.  You must have the source code for a program unit before you can compile it into executable form.  In Project Builder:  The input types required to build target types.


Defines only the names, parameters, and return type (applies to functions only) of the subprogram.


A small rectangle at the bottom of the vertical scrollbar and to the left of the horizontal scrollbar in an editor.  Dragging and releasing the mouse button creates a new pane, and divides the scroll bar into separate scroll bars for each pane.


A standard interface for storing and retrieving information in a relational database.  SQL is an acronym for Structured Query Language.


A that contains a query stored in text (e.g., ASCII or EBCDIC) format.


A file containing SQL statements that you can run to perform database administration quickly and easily.  Several SQL scripts are shipped with Oracle products.


A SQL instruction to Oracle.  A SELECT statement is one type of SQL statement.


See call stack.


A PL/SQL construct used for conditional, iterative, and sequential control, and for error handling.  A semi-colon (;) must terminate every PL/SQL statement.


(Oracle Express) A saved selection that contains the same dimension values every time it is evaluated. Static saved selections list the dimension values that are to be selected, rather than the selection criteria. For example, a static saved selection script might include "Select February 1996, March 1996, and April 1996", while the script for a dynamic saved selection might have "Select the last three Months".


A procedure, function, or package that resides and executes in the Oracle database server.


A procedure or function that resides and executes in the Oracle database server.


HTML extensions that provide powerful formatting flexibility in HTML documents.  To view an HTML document that takes advantage of style sheets, display it in a browser that supports style sheets.


A PL/SQL procedure or function.


In Project Builder, a project contained within another project file, rather than being stored in its own file.  See also:  project.


In Project Builder, a node denoting a subproject.  See also:  project, project node, subproject node.


A column, with a type of summary, which computes subtotals, grand totals, running totals, and other summaries of the data in a report, using one of the packaged summary functions provided by Report Builder.


The file format used by the Microsoft Excel program.


The orderly system by which commands, qualifiers, and parameters are combined to form valid command strings.


One of the variables that are provided with Reports Developer (e.g., &Logical Page, DESTYPE).


A named collection of related information, stored in a relational database or server, in a two-dimensional grid that is made up of rows and columns.


A collection type, which defines a data unit made up of an unordered set of elements, all of the same data type.  The corresponding data unit is a single column nested table, the column type of which is a built-in type or an object type.  (Oracle8)


A default layout displaying labels at the top of the page and rows of data underneath the labels.


In Project Builder, any item in the middle of the dependency tree; for example, an executable is a (compile) target for a library; while a library is a target for a group of objects; and an object is a target for a source file.


A node denoting a target.  See also: target.


Acronym for Transmission Control Protocol. The underlying communication protocol for exchanging HTTP requests between clients and Web servers.


A submenu that the user can remove from its source using a mouse or other pointing device and drag to another part of the display screen.


In Form Builder, an item that displays a character string value.


The horizontal area at the top of a window that displays the name of the application or interface element in that window.


See header.


To turn a setting alternately on or off.  For example, you can hide or show the Object Navigator.


An iconic button used to create and manipulate objects in an application.


Collection of iconic buttons that perform product commands.  Usually aligned horizontally along the top, or vertically down the side of a window.


A collection of tools.


(Oracle Express) A Selector dialog box tool that allows the user to select dimension values based on the top x, bottom y, or top x and bottom y data values. For example, the user can produce a dimension selection that contains products whose Volume Sales were among the top 10 percent of products in the Total U.S. for the four-week time period ending December 30, 1995.


A optional report region that can contain closing material for the report, including text, graphics, data, and computations.  The report trailer appears last, following the header and body.


A sequence of SQL statements treated as a single unit.


A PL/SQL procedure that is executed, or "fired," upon a specific event.


A description of a file type, such as a form, a document, etc., containing such information as type name and description. Each description applies to a single file type.  In addition, there are four meta-types: "updtext", which applies to all text files, “updproj” which applies to all project files, “updlink”, which applies to all project links, and "all" which applies to any file type.  Types are the foundation for defining actions and macros.


To change the values for table data, in particular, by altering data values using the SQL command UPDATE, but also by deleting values using the SQL command DELETE or by inserting values using the command INSERT.


Acronym for Uniform Resource Locator. The "address" used to specify a WWW server and home page.  For example:
http://www.acme.com/
which indicates that the host's address is www.acme.com. An URL most often is a filename (possibly with a long path to it and usually with an extension of .HTML, or .HTM (for PC-DOS filenames).


A way in which to pass control (and possibly arguments) from Forms Developer to another Oracle product or 3GL, and then return control (and possibly arguments) back to Forms Developer.


A custom action defined by a Project Builder user.  Such actions may apply to any single file type, or to all file types.  See also:  action, pre-defined action.


See object type.


A custom macro defined by a Project Builder user.  Such macros may be used to modify both built-in actions and user-defined actions.  See also:: macro, built-in macro, action, pre-defined action.


A project file storing configuration information on a per-user basis.  This enables users to customize their individual development environments.  The user registry inherits type information from the Global Registry, and may define new types as well as override aspects of type definitions stored in the Global Registry.  It also stores environment and preference information, such as the user's preferred connection string, UI settings such as "Display Toolbar" and certain general project information such as "Author."  See also:  registry, Global Registry.


See continuous axis.


A PL/SQL code structure that returns a value.  Value constructs include functions and expressions.


A named object that can be assigned a value and whose assigned value may change over time.


A collection type, which defines a data unit made up of an ordered set of elements, all of the same datatype.  The corresponding data unit is a varying array or VARRAY.  The number of elements in a VARRAY (size) is variable.  However, you must specify a maximum size when you declare a varying array type.


Visual Basic extension.  Used as the file extension for special dynamic link libraries distributed on files that contain predefined VBX controls.


A widget, built with the Microsoft Visual Basic language, used to enhance the user interface, obtain user input, and display output  (e.g. sliders, grids, and control knobs).


A virtual table whose rows do not actually exist in the database, but which is based on a table that is physically stored in the database.


A directory mnemonic (essentially a shortcut or synonym) that the virtual file system uses to map files stored in the file system on the host machine.


A mapping that associates the pathnames used in URL to the file system maintained by the host machine's operating system.


The font, color, and pattern properties that you set for objects that appear in your application interface.


See WWW.


A program that end users utilize to read HTML documents and programs stored on a computer (serviced by a Web server).


A program executed on a Web server via the Web Request Broker.


A server process (HTTP daemon) running at a Web site which sends out Web pages in response to HTTP requests from remote Web browsers.


A character used to mean 'any one character' or 'a contiguous set of characters' within a word or phase.


1. A rectangular area of the desktop that contains an application.  Each window has an area where you can interact with the application.  Windows can be opened, resized, moved, reduced to an icon, or enlarged to fill the entire desktop.  2. In Form Builder, an object type you can associate with a canvas view.


The file format used by some spreadsheet programs, such as SQL*Calc, or by Lotus 1-2-3 programs.


Acronym for Oracle Web Request Broker.  Provides a powerful distributed runtime environment for developing and deploying applications for the Web.  The WRB runtime platform enables application developers to write applications that are independent of, and work with a number of, Web servers.


Acronym for World Wide Web.  The network of servers on the Internet, each of which has one or more home pages, which provide information and links to other documents on that and (usually) other servers.


To expand an object to allow more room for editing the contents of the field.


The secondary toolbar docked (by default) to the left of the Project Navigator.  It provides simple organization and application launching abilities.


 the latest version of OLE controls (OCX)


XML output complying with general XML principles such as proper tagging, nesting, and the inclusion of an XML declaration, e.g. <?xml version="1.0" encoding="UTF-8"?>.


A placeholder username enables users to log on to the database using their personal username rather than the Oracle database username (e.g., $user_name@database) when running reports from a Web browser.


Extensible Markup Language -- a metalanguage using SGML to define and structure data. Report Builder supports XML output to enable Web publishing as well as electronic data exchange with third-party applications. You can also use XML to build report definitions that can be merged with other report definitions at runtime or run separately


XML output with structure and element content conforming to a document type definition (DTD). Valid XML is also well-formed.


Using the online help

The following guidelines will help you to make effective use of the online help system:

•	Familiarize yourself with the Contents tab to get an idea of the scope of the topics covered in the online help.

•	Click the Related Topics button directly below topic titles for a list of topics related to the current topic.

•	Click the Options button at the top of any topic to set Keep Help on Top, so that help topics remain on your screen as you develop applications.

•	Click the Glossary button at the top of any topic for definitions of unfamiliar terms.


Documentation roadmap

To get started and become proficient with building applications:

1	Review the Quick Tour for a brief overview of each component:

•	Choose Help [image] Quick Tour.

2	Step through the Cue Cards to learn how to perform the most common tasks:

•	Choose Help [image] Cue Cards.

3	Display the online manuals (also available in hardcopy form):

•	Choose Help [image] Manuals.

4	Access the online help system:

•	Choose Help [image] Help Topics.

•	For context-sensitive help, press [Help] (this is usually the F1 key on most platforms).


Oracle8 Server support

  Related Topics

The Oracle8 Server provides a number of new features.  In general, the features are in these categories:

•	Greater scalability.  For example, Oracle8 databases can contain tens of terabytes of data, and can support simultaneous access by up to 10000 users.  Tables themselves can now contain up to 1000 columns.  CHAR and VARCHAR2 datatypes can now be up to 2000 and 4000 bytes, respectively.

•	Greater performance and efficiency.  Use of these Oracle8 features is handled for you and requires no actions on your part.  You automatically receive the speed and reliability benefits of having your data on the Oracle8 Server.

•	Large objects (sometimes called LOBs)

•	User-defined objects.

Continued support for Oracle7

Oracle7 Server features are still supported (Release 7.3.4 and later).


Oracle8 datatypes supported

  Related Topics

This release continues to support the following Oracle8 datatypes:

Large objects (LOBs)

In Oracle8, programmers can define large objects, often called LOBs.  These can store such things as text, images, sound, or video.

This release supports the following Oracle8 large object datatypes:

•	BLOB, or binary large object

•	CLOB, or single-byte character large object

•	BFILE, or binary file (sometimes referred to as an external file).

User-defined objects

In Oracle8, programmers can define object types (also called user-defined types), which are composites based on the existing single-element datatypes supported by Oracle8.  Using these object definitions, programmers can then create various kinds of tables.

Currently supported Oracle8 objects include:

•	An object table, where the entire table is based on a single object type.

•	A column object in a relational table, where that column is based on an object type.

•	A REF column in either an object or relational table, where that column's values are pointers to rows in another object table.

New scalar datatypes

This release supports the new Oracle8 FLOAT datatype.  It maps this datatype to its own NUMBER datatype.


About Oracle8 large objects (LOBs)

You can access the Oracle8 large object datatypes: binary large objects (BLOBs), character large objects (CLOBs), and binary files (BFILEs).

On an Oracle8 server, these datatypes can store objects of up to 4 gigabytes in size.  They are similar in purpose to the familiar Oracle7 LONG and LONG RAW datatypes, but offer a number of additional advantages.

Comparison of LOBs with LONGs

LOBs	LONGs
Up to 4 gigabytes	Up to 2 gigabytes
Multiple LOB columns allowed in a single table	Only one LONG column allowed per table
Replication supported	No replication
Random data access supported	Only sequential access supported
Better table space management (only LOB locator is stored)	Less efficient (data is stored directly in table)
Allowed in user-defined object types	Not allowed
Easily passed to procedures and external calls	Not easily passed
LOBs in detail:

BLOBs are used to store large objects in binary format.  CLOBs are used to store character data.  These two types are also known as internal LOBs, because their data is stored within the server.  The data participates in transactions and integrity control, including commits and rollbacks.

BFILEs, in contrast, are stored outside of the server. The server stores only the operating system address of the file.  As a consequence, BFILEs can not participate in database transactions.

Compatibility

Because of the various advantages offered by LOBs (see the table above), you should used LOBs instead of LONGs in any new application.

However, for backward compatibility, LONGs are still fully supported.

Forms Types

Within a form, the LOB would usually be given a control type of Text, Image, or Sound, depending on its nature and usage.

Restrictions

•	BFILEs are read-only.

•	Although Forms will attempt to load the entire BFILE or BLOB when it is read at runtime, it is limited by the amount of runtime virtual memory available.

•	For CLOBs, Forms has a size limitation of 65534 bytes.


About Oracle8 user-defined objects

  Related Topics  [image]  Examples

In its support for the Oracle8 Server, this release provides you with access to Oracle8 user-defined objects.  These include object tables, column objects in relational tables, and the special kind of column object known as a REF column.

Object tables

In Oracle8, an object table is based on a user's object type definition.  This definition is itself a composite, each attribute or component of which is based on a familiar Oracle8 built-in datatype.  (An object type definition can be based on another object type definition, but ultimately the definitions rest on known Oracle8 built-in datatypes.)

Because of this, each column in an object table is treated as an individual data item, in a manner similar to the way it treats the columns of a relational table.

Column objects in relational tables

A database programmer can also base a column in a relational table on an object type definition.  This has the effect of embedding a composite object in the relational table.

The embedded column object is expanded into its composite parts, and each part is treated as a column in itself.

For example, if the Oracle8 Server held a 3-column relational table, and one of those columns was a column object, and that column object was based on an object definition having four parts or attributes, then the table would be treated as a 6-column table (the 2 relational columns plus the 4 columns that comprise the object).

In the event one of the individual attributes of the column object's definition was based on yet another object type, then that part is further expanded and treated as a set of individual columns.

REF columns

A column in either an object or relational table can be defined as having a type of REF.  A REF column does not hold data directly, but rather has pointers (references) to another object table that holds the actual data.

The reference can be resolved at runtime, so that the user sees the actual referenced data.


Oracle8 user-defined objects: examples

  Related Topics

To create objects in the Oracle8 Server, a database programmer first defines an object type, and then creates a specific object based on that type definition.  The resulting object can be either an object table or a column object in a relational table.

Examples

Consider the following definitions.  The first creates an object type.  The second creates a table of that type.

         CREATE TYPE  emp_type  AS OBJECT

                      (name     CHAR(30),

                       title    CHAR(20),

                       idnum    NUMBER);

         CREATE TABLE  emp  OF emp_type;

In the above example, we create an object table named emp.  It has three columns, and those columns have the names and datatypes that are established in the attributes of the emp_type object type definition.

The following is an example of a column object in a relational table:

         CREATE TYPE  address_type  AS OBJECT

                      (street    VARCHAR2(40),

                       city      VARCHAR2(25),

                       state     VARCHAR2(2)

                       zip       NUMBER);

         CREATE TABLE  customers

                       (cust_id  NUMBER,

                        name     VARCHAR(40),

                        address  address_type);

In this example, we create a relational table named customers.  The table has three columns.  The first two columns (cust_id and name) are the usual relational columns.  The third column (named address) is a column object.  It is built on the object type definition named address_type.  This address column has the structure and datatypes established by that object definition.  The address column can be thought of as having four parts or components (street, city, state, and zip).  Each of these components is of the datatype that was established in the address_type object type definition.  (In this case, all are of VARCHAR2 except for zip, which is of datatype NUMBER).

In the following illustration, the third column of a three-column relational table is based on an object type that itself has three parts or components.

Note that an Oracle8 object is a composite, built from parts or components.  Each of its parts has a name and is of a known Oracle8 datatype.  If the object is a table (actually, a row in an object table), it has as many columns or parts as there are attributes in the object type definition.  If a column in a relational table is based on an object, then each of the object's parts can be thought of an additional column in that table.  Because each of these parts is based on an attribute in the object type definition, these parts are sometimes called attribute columns.

How Developer treats objects

An object table is treated very much like a relational table.  Each column is individually selectable.  Although all columns may be selected, each is treated as a separate item within the application.  The table itself does not have any particular identity as an object within the environment.

Similarly, a column object in a relational table is not treated as a single, homogeneous entity.  Instead, it treats each of the column object's components as an individual, independent data item.  Each component of the column object is selectable.  Once selected, each is treated as an independent data item.  Even if all of the column object's components are selected, the column object itself does not have any particular identity as an object within the development environment.

Data items selected from an object are given the default name ColumnObjectName_ItemName.  Thus, if we select the component named zip from the column object named address in the above example, the data item will have the name address_zip within the application.


About Oracle8 REFs

  Related Topics

REF is a new datatype in Oracle8.  It establishes a column object as a pointer to data in another object table.  The REF column itself does not hold the data.

For example:

           CREATE TYPE  dept_type  AS OBJECT

                        (deptname     VARCHAR2(24),

                         deptnumber   NUMBER);

           CREATE TABLE  dept_table OF dept_type;

           CREATE TABLE  emp

                         (empname    VARCHAR2(50),

                          empnumber  NUMBER,

                          empdept    REF  dept_type);

In the relational table named emp, the column empdept is a REF column.  It points to an object of type dept_type.

Types versus tables

When a REF column is defined, it identifies an object type -- not a particular object table.  It is possible for a database to contain more than one object table based on a single object type definition.  Thus, the REF column definition itself does not identify the target table(s).

Pointer resolution

When the table holding the REF column is initialized, the values placed in the REF column will be pointers to rows in the specific table or tables that have the desired data.  Later at runtime, when users look at the REF column, they will see the pointed-to data (not the pointers).

How Developer displays REFs at design time

At design time, when you ask to see a table that contains a REF column, the REF column displays in its expanded form.  That is, it shows the attributes in the object type pointed to by the original REF definition.

In the above example, the empdept REF column would show as holding two components or attribute columns:  deptname and deptnumber.  These were the two attributes in the object type (dept_type) identified in the REF definition.

Just as with a regular column object, you can select any or all of the referred-to components/attribute columns to become data items in the application.  However, in contrast to regular column objects, you can also select the REF name itself to become a manipulatable item within your application.  That is, you can use the REF in your PL/SQL coding.  By default, the REF becomes part of the null canvas.

How you can display REF data to your users

As an application designer, you have a choice in how the runtime user will see the referenced data (the resolved REF):

•	data displayed in the data block in which the REF exists (sometimes called the look-up method)

•	data displayed in the data block pointed to by the REF (the master-detail method)

The first choice (displaying the data as part of the data block in which the REF exists) is the simplest.  You select the desired REF components as items into your data block, and at runtime Developer and Oracle8 will resolve the references and place the actual referred-to data in the display items.  The user need see only the one block.

The other choice (displaying the data in the pointed-to data block) requires setting up a master-detail link.  This is very similar to setting up a master-detail link for two blocks having a primary-key foreign-key relationship.  In this case, the REF creates the link between the two blocks.  The user will see both blocks, but will  see the REF data only in the referred-to block.

The Form Builder Data Block Wizard can be used to set up this master-detail relationship.


Icons for Oracle8 objects

The object navigator and wizards use icons to help you see what type of Oracle8 data you are accessing.   These icons, and their meanings, are as follows:

             normal table

             object type

             object view

             object table

             nested object

             nested table

             referenced object

             varying array

             method

             unknown type

             server-side stack mode

             server-side program unit

             file

             datatype of Date

             datatype of Number

             datatype of Character

             datatype of Raw

             datatype of BLOB

             datatype of BFILE

             datatype of CLOB

             rowid

             MLS label


Scalability and performance with Oracle8

Oracle8 Server gives you a number of scalability and performance improvements.  For the most part, you obtain these advantages automatically.

For example, you can access Oracle8's:

•	Larger sizes.  The database itself, the number of concurrent users, and its table column limits (now up to 1000 columns) have all increased.

•	Table and index partitioning

•	Client-side object caching

You can also make direct use of several other Oracle8 functions that provide it with improved performance:

•	Prefetch.  Forms uses this Oracle8 feature (along with the existing Array Size mechanism) to reduce both database round-trips and memory usage.  This is done automatically, without any need for user involvement.

•	Returning values clause.  Forms uses this new DML feature when doing inserts and updates.  The Returning clause eliminates the need for a second database query (to obtain any server-side trigger changes to the data), thus speeding up processing.  Users can control it with the DML Returning Value property.

•	INSTEAD-OF trigger for updating views.  This server-side trigger provides a mechanism for updating both relational and object views that would not otherwise be updatable.


Support for PL/SQL 8

  Related topics

This release uses PL/SQL 8 on the client and the server.  Client-side program units currently cannot support Oracle8 object-related functionality.  However, stored program units can use all the new PL/SQL 8 features.

Appendix A in the PL/SQL User's Guide and Reference Release 8 manual describes the new PL/SQL 8 features.  This manual is available online.  Choose Help -> Manuals, and navigate to Reference Manuals under Online Manuals.


Compatibility with earlier releases of PL/SQL

If you have client-side program units written in PL/SQL 1 or PL/SQL 2, you must convert the code to the new level.  The PL/SQL 1 conversion utility is provided to help automate the upgrading process.

Stored program units created with previous releases will run against the PL/SQL 8 engine on the database server, but may compile with errors.  These errors arise in some situations where there is syntax incompatibility between PL/SQL 8 and PL/SQL 2.  A compatibility flag in PL/SQL 8 allows you to choose a PL/SQL 2 compatibility mode, so that the PL/SQL 8 engine does not issue such errors when it compiles PL/SQL 2 code in the server.  Chapter 6 in the Oracle8 Server Migration manual describes the situations that are covered by this compatibility flag.


Oracle8 features not yet supported

  Related Topics

Not all Oracle8 features are currently supported across this release.  The major unsupported features are:

•	Collection types (nested tables and varying arrays, or varrays)

•	Stored procedures that return object values

•	Scalar datatypes NCHAR and NVARCHAR2.

You should also be aware that, although this release does support PL/SQL 8, client-side PL/SQL 8 does not yet fully support all the features in the Oracle8 Server.  (Server-side PL/SQL 8 support is complete.)


Oracle8 objects examples

  Related Topics 	   All Examples

Object Type

Table Type

Varying Array Type

Column Object

Object Table

Object View


Oracle8 Object Support in the Object Navigator

Oracle8 functionality in the Object Navigator provides access to object datatypes, enabling you to program against Oracle8 data more easily. The added Oracle8 object support allows you to view user-defined datatypes in a hierarchical format, and to find and display tables, views, columns, triggers, attributes and methods associated with the user-defined datatypes.

The Database Objects node contains the schemas and their objects that you can access in the currently connected database. When connected to an Oracle8 database, the Object Navigator displays available user-defined datatypes (with their attributes and methods) in the Types node within each schema. Tables, views, columns and triggers associated with the user-defined datatypes are displayed in the Tables and Views nodes.

Specifically, Oracle8 functionality in the Object Navigator enables you to display and find:

•	object tables and column objects in the Tables node

•	object views in the Views node

•	Instead Of triggers for views in the Views node

•	object types, table types and varying array types in the Types node

•	attributes and methods of object types in the Types node

Icons are used to differentiate relational objects and Oracle8 objects in the Object Navigator. For example, separate icons are used to represent normal, relational tables and object tables, and normal views and object views.

For information about Oracle8 user-defined datatypes, see your Oracle8 documentation.

Learn more about

Object Type nodes

Table Type nodes

Varying Array Type nodes

Column Object nodes

Object Table nodes

Object View nodes

Expanding All

Oracle8 objects icons


Object Type nodes

  Example	  Related Topics

Object types appear within the Types node in the Object Navigator. An object type node represents a type created by the SQL statement, CREATE TYPE AS OBJECT. The object type is displayed in the Object Navigator as:

object-type-name ( Object Type [ * ] & Body [ * ] )

The Object Type label appears when a CREATE TYPE AS OBJECT statement has been issued to the database. An asterisk ( * ) appears when the type specification is invalid or if the type is incomplete. An incomplete type is a placeholder for defining types recursively.

The Object Body label appears when a type body has been created using the CREATE TYPE BODY statement. An asterisk ( * ) appears when the type body is invalid.

When both object type and object body have been successfully created, then the label appears as Object Type & Body.

Object type nodes are composite nodes; they have two subnodes, Attributes and Methods. An object type node can be expanded only if a valid type specification exists.

The attributes of an object type are represented as nodes under the Attributes subnode.

The methods of an object type are represented as nodes under the Methods subnode. The methods appear as procedures and functions. The method labels are displayed in the Object Navigator as:

method-name (Procedure)

and

method-name (Function)

If a map method or order method is specified for an object type, then the method label is displayed as:

method-name (Map Function)

or

method-name (Order Function)

Note:  The argument list of a method is not displayed.


Object Type node example

  Related Topics 	   All Examples

The following SQL statement creates the object type emp_typ.

CREATE TYPE emp_typ AS OBJECT
  (ename VARCHAR2(30), esalary NUMBER(5,2),
  MEMBER PROCEDURE raise(amount NUMBER),
  MEMBER FUNCTION get_salary RETURN NUMBER,
  MAP MEMBER FUNCTION compare RETURN NUMBER);

The subtree for emp_typ is:


Table Type nodes

  Example	  Related Topics

Table types appear within the Types node in the Object Navigator. A table type node represents a type created by the SQL statement, CREATE TYPE AS TABLE. The table type is displayed in the Object Navigator as:

table-type-name (TABLE OF table-subtype-name)

The table type node is not expandable if the subtype is a built-in type. If the subtype is an object type or REF object, the attributes of the object appear as subnodes.


Table Type node example

  Related Topics 	   All Examples

The following SQL statements create the object type emp_typ and the table type emp_tbl.

CREATE TYPE emp_typ AS OBJECT
  (ename VARCHAR2(30), esalary NUMBER(5,2),
  MEMBER PROCEDURE raise(amount NUMBER),
  MEMBER FUNCTION get_salary RETURN NUMBER,
  MAP MEMBER FUNCTION compare RETURN NUMBER);

CREATE TYPE emp_tbl AS TABLE OF emp_typ;

The subtree for emp_tbl is:


Varying Array Type nodes

  Example	  Related Topics

Varying array types appear within the Types node in the Object Navigator. A varying array type node represents a type created by the SQL statement CREATE TYPE AS VARYING ARRAY. The varying array type is displayed in the Object Navigator as:

varying-array-type-name (VARRAY (size) varying-array-subtype-name)

The varying array type node is not expandable if the subtype is a built-in type. If the subtype is an object type or REF object, the attributes of the object appear as subnodes.


Varying Array Type node example

  Related Topics 	   All Examples

The following SQL statements create the object type emp_typ and the varying array type emp_ary.

CREATE TYPE emp_typ AS OBJECT
  (ename VARCHAR2(30), esalary NUMBER(5,2),
  MEMBER PROCEDURE raise(amount NUMBER),
  MEMBER FUNCTION get_salary RETURN NUMBER,
  MAP MEMBER FUNCTION compare RETURN NUMBER);

CREATE TYPE emp_ary AS VARRAY(7) OF emp_typ;

The subtree for emp_ary is:


Column Object nodes

  Examples	  Related Topics

Column objects appear as nodes within the Columns node. Each object is labeled with a name and its type in parentheses. Column object nodes are composite nodes, with the attributes of the type appearing as subnodes.

There can be four subtypes of column objects-nested object type, table type, varying array type and REF object type. Column objects are labeled in the Object Navigator as follows:

column-name (nested-object-type)

column-name (table-type-name:TABLE OF table-subtype-name)

column-name (varying-array-type-name: VARRAY(size) OF varying-array-subtype-name)

column-name (REF reference-type-name)


Column Object node examples

  Related Topics 	   All Examples

In the following example, the emp_col column of table emp_tab is a nested object of type emp_typ.

CREATE TYPE emp_typ AS OBJECT (ename VARCHAR2(30), esalary NUMBER(5,2));
CREATE TABLE emp_tab (emp_col emp_typ, dept VARCHAR2(2));

The subtree for emp_tab is:

In the next example, the emps column of table dept_tab is a nested table with subtype emp_tbl. The nested table contains rows of type emp_typ.

CREATE TYPE emp_typ AS OBJECT (ename VARCHAR2(30), esalary NUMBER(5,2));
CREATE TYPE emp_tbl AS TABLE OF emp_typ;
CREATE TABLE dept_tab (dname VARCHAR2(20), emps emp_tbl)
  NESTED TABLE emps STORE AS emps_tab;

The subtree for dept_tab is:

In the following example, the emps column of table dept_tab_ary is a varying array with subtype emp_ary. The varying array contains rows of type emp_typ.

CREATE TYPE emp_typ AS OBJECT (ename VARCHAR2(30), esalary NUMBER(5,2));
CREATE TYPE emp_ary AS VARRAY(7) OF emp_typ;
CREATE TABLE dept_tab_ary (dname VARCHAR2(20), emps emp_ary);

The subtree for dept_tab_ary is:

In the next example, the manager column of table dept_ref is a referenced object with type emp_typ.

CREATE TYPE emp_typ AS OBJECT (ename VARCHAR2(30), esalary NUMBER(5,2));
CREATE TABLE dept_ref (dname VARCHAR2(20), manager REF emp_typ);

The subtree for dept_ref is:


Object Table nodes

  Example	  Related Topics

Object tables appear within the Tables node in the Object Navigator. An object table node represents a table created by the SQL statement CREATE TABLE OF. Object table nodes are labeled in the Object Navigator as:

object-table-name (object-type-name)

Each object table node has two subnodes, Triggers and Columns. The Triggers subnode contains all triggers associated with the object table. These triggers are displayed in the same manner as triggers associated with normal, relational tables. The Columns node contains all relational columns and column objects associated with a given object table. Each column is labeled with a name and its type in parentheses.


Object Table node example

  Related Topics 	   All Examples

The following SQL statements create the object type person_typ and the object table person_tab.

CREATE TYPE person_typ AS OBJECT
  (name VARCHAR2(30), address VARCHAR2(60));

CREATE TABLE person_tab OF person_typ;

The subtree for person_tab is:


Object View nodes

  Example	  Related Topics

Object views appear within the Views node in the Object Navigator. An object view node represents a view created by using the OF object_type clause. Object view nodes are labeled with a name and its type in parentheses. The attributes of the object are not displayed.

Each object view node has two subnodes, Triggers and Columns. The Triggers subnode contains all triggers associated with the object view, including Instead Of triggers. When an Instead Of trigger is associated with a view, the label is displayed as:

trigger-name (INSTEAD OF trigger-statements)


Object View node example

  Related Topics 	   All Examples

The following SQL statements create an object view.

CREATE TYPE emps_typ AS OBJECT (ename VARCHAR2(30), esalary number(5,2), deptno NUMBER(2));
CREATE TABLE emps (ename VARCHAR2(30), esalary number(5,2), deptno NUMBER(2));
CREATE VIEW dev_emps OF emps_typ
  WITH OBJECT OID (ename)
  AS SELECT ename, esalary, deptno FROM emps WHERE deptno = 10;

The subtree for the object view dev_emps is:


Expanding all Oracle8 object nodes

  Related Topics

The Expand All operation in the Object Navigator does not expand Oracle8 datatype and attribute nodes recursively.

For example, if an attribute called manager with type emp_typ appears as a descendent from another type emp_typ, then the manager attribute would not be expanded by Expand All.