OraFAQ Forum: Spatial » something is wrong when i use "sdo

Home » Server Options » Spatial » something is wrong when i use "sdo_geor.subset"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!!

Report message to a moderator

Previous Topic:	copying geom data from one table to another
Next Topic:	Does Oracle Spatial support floating point coordinates?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 02:18:44 CST 2024