A script-enabled browser is required for this page to function properly.

Type Wizard: Define Object Type Methods Page

Methods are functions and procedures written in PL/SQL and stored in the database, or they could be written in C and stored externally. Methods characterize the behavior of the object type.

To add a method:

To edit a method:

Or,

To remove a method:

  1. On the Define Object Type Methods page, select a method and click Remove.
    A message box displays, prompting you to confirm the deletion.
  2. Click Yes to remove the highlighted method.

To change the restrictions for the methods of an object type:

The Default Restrictions dialog

The Default Restrictions dialog box allows you to specify the default pragma restrictions for the methods of an object type. The pragma restrictions apply to member functions called from SQL statements. The restrictions deny member functions read/write access to database tables, packaged variables, or both.

To specify the default pragma constraints for the methods of an object type:


About the Type Wizard

The Method dialog box

The Default Restrictions dialog box