To move a program unit from the client to the database server:
In the Object Navigator, double-click the Database Objects node. If this node is disabled, the Connect dialog displays so you can establish a database connection.
Expand the subnode that corresponds to the database user name you used to log in to the database to show the PL/SQL Stored Program Units node.
In the Reports section of the Object Navigator, expand the Program Units node.
Click the program unit you want to store in the database, and drag it from the Program Units node to the Stored Program Units subnode.
Release the mouse button to insert a copy of the program unit on the server.
To move a program unit from the database server to the client:
In the Object Navigator, double-click the Database Objects node. If this node is disabled, the Connect dialog box displays so you can establish a database connection.
Expand the subnode that corresponds to the database user name you used to log in to the database.
Expand the Stored Program Units node.
Click the stored program unit you wish to move to the client and drag it from the Stored Program Units node to the Program Units node in the Reports section of the Object Navigator.
Release the mouse button to insert a copy of the program unit on the client.
Copyright © 1984, 2005, Oracle. All rights reserved.