Skip Headers
HS_EXTERNAL_OBJECTS contains information about all of the distributed external objects accessible from the Oracle server.
HS_EXTERNAL_OBJECTS
FDS_CLASS_NAME
VARCHAR2(30)
NOT NULL
Name of the FDS Class
FDS_INST_NAME
Name of the FDS instance
OWNER
VARCHAR(30)
Name of the user who created the object
OBJECT_NAME
Name of the object; unique for each instance
OBJECT_TYPE
VARCHAR2(13)
Type of object: FUNCTION, PROCEDURE, PACKAGE, or LIBRARY
FUNCTION
PROCEDURE
PACKAGE
LIBRARY
OBJECT_TEXT
LONG
SQL text used to create the object