Home » Server Options » Spatial » something is wrong when i use "sdo_geor.subset"
something is wrong when i use "sdo_geor.subset" [message #47265] Tue, 03 August 2004 00:13
oasis
Messages: 2
Registered: October 2003
Junior Member
I am working with oarcle 10g this days,and the main part is georaster which is a extend of spatial.

the description of sdo_geor.subset is as follows:
SDO_GEOR.subset(
inGeoraster IN SDO_GEORASTER,
cropArea IN SDO_GEOMETRY,
layerNumbers IN VARCHAR2,
storageParam IN VARCHAR2,
outGeoraster IN OUT SDO_GEORASTER);
or
SDO_GEOR.subset(
inGeoraster IN SDO_GEORASTER,
cropArea IN SDO_NUMBER_ARRAY,
bandNumbers IN VARCHAR2,
storageParam IN VARCHAR2,
outGeoraster IN OUT SDO_GEORASTER);

with the paramater "cropArea":
Crop area definition. If the data type is SDO_NUMBER_ARRAY, the parameter identifies the upper-left (row, column) and lower-right (row, column) coordinates of a rectangular window, and raster space is assumed. If the data type is SDO_GEOMETRY, the minimum bounding rectangle (MBR) of the geometry object is
used as the crop area; see also the Usage Notes for SDO_SRID requirements.
If cropArea is of type SDO_GEOMETRY, use the layerNumbers parameter to specify one or more layer numbers; if cropArea is of type SDO_NUMBER_ARRAY,use the bandNumbers parameter to specify one or more band numbers.
***********************************************
then I used it :

select sdo_geor.gettotalLayerNumber(geor) layernumbers from image_table where geoid=1;

layerNumbers
________________
3

sdo_geor.subset(geor,sdo_geometry(2003, NULL, NULL,
mdsys.sdo_elem_info_array(1, 1003, 3),
mdsys.sdo_ordinate_array(0,200,0,200) ),
'1','pyramid=false',geor_sub);

errors are given:
ORA-13418: null or invalid parameter(s) for set functions
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 1078
ORA-06512: at "MDSYS.SDO_GEOR", line 2421
ORA-06512: at line 53

And when I use the second method of sdo_geor.subset:

sdo_geor.subset(geor,sdo_number_array(0,200,0,455),
'1','blocksizi(255,255,1)',geor_sub);

errors are given:
ORA-13205: internal error while parsing spatial parameters
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 66
ORA-06512: at "MDSYS.SDO_GEOR", line 343
ORA-06512: at "MDSYS.SDO_GEOR", line 700
ORA-06512: at line 44

why?
How can I get it over?
thank you for advance!!
Previous Topic: copying geom data from one table to another
Next Topic: Does Oracle Spatial support floating point coordinates?
Goto Forum:
  


Current Time: Tue May 18 19:50:29 CDT 2021