HP Neoview Release 2.5 Software - Manual (Page 169)

Type
Parameter Type
or Class
“short” primitive
“short[]”
“int”
“int[]”
“long”
“long[]”
“float”
“float[]”
“double”
“double[]”
“java.sql.ResultSet[]” result sets
For more information, see the Neoview Guide to Stored Procedures in Java.
Drop a Procedure
To drop a procedure, you must own the procedure, have SUPER.SUPER privileges, or have the
necessary DDL privileges to drop the procedure. The schema owner can grant such privileges
to other users or roles. For example, if the schema owner granted your role privileges to drop
all objects, members of your role could drop procedures. For more information about the GRANT
SCHEMA statement, see the Neoview SQL Reference Manual.
To drop a procedure:
1. Under the navigation tree pane, click the Database area.
2. Under My Systems, expand the tree for the Neoview platform containing the procedure
until you can see the schema folder and the Procedures folder underneath it.
3. Expand the Procedures folder.
4. Right-click the name of the procedure that you want to drop, and select Drop Procedure.
HPDM asks you to confirm the operation.
5. Click [ Yes ] to continue or [ No ] to quit the operation.
Drop a Procedure 169