Re: Spatial Data in WKT format

On Thu, 22 Sep 2005 15:50:14 +0200, Tim-Christoph Hagen interested us by writing:

> Hi!
> I would like to export spatial data in the well-known text format as
> proposed by OGC. What am I doing wrong?
> SQL> select astext(shape) from cola_markets;
> select astext(shape) from cola_markets
> *
> FEHLER in Zeile 1:
> ORA-06553: PLS-306: Falsche Anzahl oder Typen von Argumenten in Aufruf von
> 'OGC_ASTEXT'
>
> The error message would in English would read something like this: "Wrong
> number or types of arguments in call to OGC_ASTEXT". Thanks for any help!
>

<grumbling detail="about expectations of being a mind reader"> Insufficient information. (I assume you are on 10g Release 2 on some version of some operating system, although I am just guessing.) </grumbling>

It would also be useful to get some details of the geometry (such as confirmation that shaper is in fact of type sdo_geometry) and the SDO_GEOM_METADATA for the layer.

However, I suspect you really want to use Oracle's SDO_UTIL.TO_WKTGEOMETRY function as described (with example) in chapter 20 of the OracleŽ Spatial User's Guide and Reference 10g Release 2 (10.2). Further, I suspect that ASTEXT is simply an alias or synonym to this function, although I have not dug for enough yet to verify.

BTW - this utility was only introduced in 10Gr2 so I would not expect to find it on 8i, 9i or 10Gr1.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***