Manage Database Objects (Stored Procedures, Functions, Trigger, etc.)
SQL4X Manager J includes a special assistant to manage database objects, display the object source code , change the objects. This feature is supported for Oracle, MS SQL Server and Sybase.
To access the Object Manager use Database Navigator, select your database connection and the catalog/schema your objects are in. Now open the corner menu form the Objects list (see snapshot on the left side) and select "Object Manager..." to open the Object Manager window.
To display your objects select the object type (Function, Java Source, Package, Package Body, Procedure, Trigger, Type or Type Body) from the Type selection and click Reload. All objects of the selected type available in the current schema are displayed in the list.
Display and Edit Object Source Code
To display the object's source code select the object in the list. The source code is displayed on the right side. You can modify the source code and click "Update Object" to save the changes back to your database server.
Renaming Objects
If you change the object name in the source code view and click "Update Object" a new copy of this object is created with the new name. The original object is not modified by this action. To rename a object you need to delete the original after creating a copy.
Adding new Objects
Click the + sign on the right side of the object list to create a new object. The Create Database Object sheet is displayed. Enter the new object's name and type in the sheet and click create. You can now enter the source code for your object in the source code view. Click "Update Object" to actually create the object.
Removing Objects
Select the object you want to delete in the object list and click the - sign on the right side of the object list to drop the selected object.
More Info