Dropping external procedures
Only a superuser can drop an external procedure.
Enterprise Mode only
Only a superuser can drop an external procedure. To drop the definition for an external procedure from OpenText™ Analytics Database, use the DROP PROCEDURE (external) statement. Only the reference to the procedure is removed. The external file remains in the <database>/procedures directory on each node in the database.
Note
The definition the database uses for a procedure cannot be altered; it can only be dropped.Example
=> DROP PROCEDURE helloplanet(arg1 varchar);