   FUNCTION transform_or_null(geom MDSYS.SDO_GEOMETRY, srid NUMBER)
     RETURN MDSYS.SDO_GEOMETRY
   IS
-    BEGIN
-      IF geom IS NOT NULL
-      THEN
-        RETURN SDO_CS.TRANSFORM(geom, srid);
-      ELSE
-        RETURN NULL;
-      END IF;
-    END;
+  BEGIN
+    IF geom IS NOT NULL THEN
+      RETURN sdo_cs.transform(geom, srid);
+    ELSE
+      RETURN NULL;
+    END IF;
+  END;
 
   /*****************************************************************
   * is_coord_ref_sys_3d

AS
  FUNCTION transform_or_null(geom MDSYS.SDO_GEOMETRY, srid NUMBER)
    RETURN MDSYS.SDO_GEOMETRY;
  FUNCTION is_coord_ref_sys_3d(srid NUMBER)
    RETURN NUMBER;
  FUNCTION check_srid(srsno INTEGER DEFAULT 0)
    RETURN VARCHAR;

    transform           NUMBER := 0
  )
  IS
    unknown_srs_ex EXCEPTION;
  BEGIN
    IF citydb_srs.check_srid(schema_srid) <> 'SRID ok' THEN
      dbms_output.put_line('Your chosen SRID was not found in the MDSYS.CS_SRS table! Chosen SRID was ' || schema_srid);
    ELSE
      -- update entry in DATABASE_SRS table first
      UPDATE database_srs SET srid = schema_srid, gml_srs_name = schema_gml_srs_name;
      COMMIT;

      -- change srid of each spatially enabled table
      FOR rec IN (SELECT table_name AS t, column_name AS c, get_dim(table_name, column_name) AS dim FROM user_sdo_geom_metadata) 
	  LOOP
        change_column_srid(rec.t, rec.c, rec.dim, schema_srid, transform);
      END LOOP;
      dbms_output.put_line('Schema SRID sucessfully changed to ' || schema_srid);
    END IF;
  END;

END citydb_srs;
/