Removing Java Stored Procedures

To drop a stored procedure:

1. Select View | Connection Navigator .
2. Expand Database and select a database connection.
3. Expand the connection and select a schema.
4. Expand the schema and locate the object you wish to remove. Depending on how Java stored procedures were published, they appear in one of these folders:
• Packages includes call specs for Java stored procedures deployed in packages.
• Functions includes call specs for Java stored procedures deployed as functions (that return a value).
• Procedures includes call specs for Java stored procedures deployed as procedures (that do not return a value).
5. Select the object and right-click to display the context menu.
6. In the context menu choose Drop.

Related topics

Using Java Stored Procedures

Copyright © 1997, 2004, Oracle. All rights reserved.