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 this procedure must be the same as the database user for the current schema.

The user must have the CREATE TRIGGER privilege

Examples

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

SQL> SELECT SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

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

SQL> EXECUTE SDO_GEOR_ADMIN.enableGeoRaster;

PL/SQL procedure successfully completed.

SQL> SELECT SDO_GEOR_ADMIN.isGeoRasterEnabled FROM DUAL;

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

SQL>