Oracle Maestro online help
Prev | Return to chapter overview | Next |
Editing type options
Type Editor provides you with an ability to edit type properties. The Properties tab allows you to change the type name, the type owner, type definition, and other type properties. You can also find the OID there.
The Errors tab displays all the necessary information about object errors. If an error have occurred during the object compilation it appears in the list with some additional properties: Order (one after another), Line and Position (object definition location the error was found out), Error (corresponding PL/SQL exception).
Subitems tab allows to manage type fields and methods. Just open the corresponding grid and using popup menu add/edit/drop the necessary objects.
Name
Here you can change the type name.
Owner
The field contains the owner of the type.
Created
The field displays the date the object was created.
Last DDL time
Use the field to find the date when the last data definition language (DDL) operation was performed on the current object. The Last DDL time can help you to find if any changes to the object definitions have been made on or after a specific time.
Instantiable
Use the Instantiable clause to indicate whether any object instances of this type can be constructed. Check to set that object instances of this type can be constructed. Otherwise, no default or user-defined constructor exists for this object type. You must specify these keywords for any type with Noninstantiable methods and for any type that has no attributes, either inherited or specified in this statement.
Final
At the top level of the syntax, these clauses specify the inheritance attributes of the type. Use the Final clause to indicate whether any further subtypes can be created for this type. Check the option if no further subtypes can be created for this type.
Invoker rights
The option means whether the member functions and procedures of the object type execute with the privileges and in the schema of the user who owns the object type or with the privileges and in the schema of CURRENT_USER. This clause also determines how Oracle Database resolves external names in queries, DML operations, and dynamic SQL statements in the member functions and procedures of the type.
Type OID
The OID clause is useful for establishing type equivalence of identical objects in more than one database.
To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.
It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.
Prev | Return to chapter overview | Next |