Object Type Body
Object type body defines code for object methods. Procedures and functions implementation details are encapsulated in the object body and they are hidden from code outside the object.
Note
Sometimes object body is unnecessary.
Note
You are not allowed to declare attributes in the body, so all items in the object type specification are public (visible outside the object type).
Like package procedures and functions, object type methods can be overloaded. You can create several methods with the same name but with the different parameter set within the object. When calling object subprogram, PL/SQL distinguishes the correct method by comparing actual parameters with the formal ones.
Creating an Object type Body
- In the Database Explorer window, expand the User Types folder.
- Expand the Object Types folder.
- Select a required object, and then click Create Type Body on the shortcut menu.
- Fill in a template with statements.
- Save the object body.
Editing an Object type Body
- In the Database Explorer window, expand the User Types folder.
- Expand the Object Types folder.
- Right-click a required type, and then click Open Type on the shortcut menu.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?