I'm new to oracle spatial, and am Trying to copy data from from Arc FeatureClass to another.
I have tried the following, but am getting a 'PLS-306: wrong number or types of arguments in call to 'ST_GEOMETRY' ' error.
I'm sure it is something very small.
أكثر...
I have tried the following, but am getting a 'PLS-306: wrong number or types of arguments in call to 'ST_GEOMETRY' ' error.
I'm sure it is something very small.
insert into newFC (Image_date,Process_date,orbit_number,platform,beam_mode,image_cat_id,Analyst,state,shape) Select oldFC.BEGDATE,SYSDATE,oldFC.orbitnumber,oldFC.objtype,oldFC.beammode,:OBJID,:Analyst,'WP',sde.ST_geometry(oldFC.SHAPE,sde.st_srid(oldFC.SHAPE)) from oldFC WHERE oldFC.OBJECTID = :OBJID;
أكثر...