8.4 SDO_GEOR_ADMIN.isGeoRasterEnabled

Format

SDO_GEOR_ADMIN.isGeoRasterEnabled() RETURN VARCHAR2;

Description

Returns the string TRUE if the GeoRaster feature is enabled for the current schema; returns the string FALSE if GeoRaster is not enabled for the current schema.

Parameters

None.

Usage Notes

The session user that calls SDO_GEOR_ADMIN.isGeoRasterEnabled() function must be same as the database user for the current schema.

The user must have the CREATE TRIGGER privilege.

When executing SDO_GEOR_ADMIN.isGeoRasterEnabled() function, avoid using Oracle result cache by adding the NO_RESULT_CACHE hint in the query.

Examples

The following example checks if GeoRaster is enabled for the current schema (before it is enables), then enables GeoRaster for the current schema, and then again checks if GeoRaster is enabled for the current schema.

SQL> SELECT /*+ NO_RESULT_CACHE */ SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

ISGEORASTERENABLED
-------------------------------------------------------------------------------
FALSE

SQL> EXECUTE SDO_GEOR_ADMIN.enableGeoRaster;

PL/SQL procedure successfully completed.

SQL> SELECT /*+ NO_RESULT_CACHE */ SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

ISGEORASTERENABLED
-------------------------------------------------------------------------------
TRUE