Type Wizard: Finish Page
The last page of the Type Wizard displays the SQL statement
that will generate the Oracle type you have just defined. This page is read
only; you cannot edit the SQL statement.
When you click Finish, the Type Wizard does the following:
- For collection types-issues
the CREATE TYPE AS TABLE or CREATE
TYPE AS VARYING ARRAY SQL statement to the database.
- For object types-issues the CREATE
TYPE AS OBJECT SQL statement to the database. If the type specification
is invalid or incomplete, an asterisk (*) appears after the Object Type label
in the Object Navigator.
- For object types with methods-creates an initial
object body and displays it in the Stored Program Unit editor. Fill in the
methods and click Save. The CREATE
TYPE BODY SQL statement is issued to the database. If the object body
is invalid, error messages appear in the Compilation Messages pane. An asterisk
(*) appears after the Object Body label in the Object Navigator.
Note: The Type Wizard stores the object type or collection
type in the currently connected Oracle Database Server.
Related topic
About the Type Wizard