1 PACKAGE rrs_elocation_pkg AS
2 /*$Header: RRSELOCS.pls 120.0 2006/01/19 07:51:35 swbhatna noship $*/
3
4 --------------------------------------
5 -- PUBLIC PROCEDURE rebuild_spatial_indexes
6 -- DESCRIPTION
7 -- Rebuilds the spatial index on RRS_SITE_TMP.GEOMETRY and RRS_TRADE_AREAS.GEOMETRY.
8 -- Rebuilding the spatial index is required so that the index performs adequately,
9 -- queries can accurately extract the spatial data and Spatial functions can be called
10 -- on these columns
11 -- ARGUMENTS
12 -- OUT:
13 -- errbuf Standard AOL concurrent program error buffer.
14 -- retcode Standard AOL concurrent program return code.
15 -- MODIFICATION HISTORY
16 -- 18/01/2006 swbhatna Created.
17 --------------------------------------
18 PROCEDURE rebuild_spatial_indexes (
19 errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE Update_Index_Metadata (
24 p_index_name IN VARCHAR2
25 );
26
27 PROCEDURE Create_Index (
28 p_index_name IN VARCHAR2
29 );
30
31 END rrs_elocation_pkg;