11.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 11-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;
 /

Parent topic: Embedded Python Execution Functions (Autonomous Database)