12.7.2.10 pyqScriptDrop Procedure (Autonomous Database)

This topic describes the pyqScriptDrop procedure in Oracle Autonomous Database. Use the pyqScriptDrop procedure to remove a user-defined Python function from the OML4Py script repository.

Syntax

sys.pyqScriptDrop (
    V_NAME          VARCHAR2    IN
    V_GLOBAL        BOOLEAN     IN     DEFAULT
    V_SILENT        BOOLEAN     IN     DEFAULT)

Parameter	Description
V_NAME	A name for the user-defined Python function in the OML4Py script repository.
V_GLOBAL	A BOOLEAN that specifies whether the user-defined Python function to drop is a global or a private user-defined Python function. The default value is FALSE, which indicates a private user-defined Python function. TRUE specifies that the user-defined Python function is public.
V_SILENT	A BOOLEAN that specifies whether to display an error message when sys.pyqScriptDrop encounters an error in dropping the specified user-defined Python function. The default value is FALSE.

Example 12-38 Using the sys.pyqScriptDrop Procedure

This example drops the private user-defined Python function pyqFun2 from the script repository.

BEGIN
  sys.pyqScriptDrop('pyqFun2');
 END;
 /

This example drops the global user-defined Python function pyqFun2 from the script repository.

BEGIN
  sys.pyqScriptDrop('pyqFun2', TRUE);
 END;
 /