Thanks for your reply, David. I can get the same data to work fine in
postgres, but when using oracle I see the error:
msDrawMap(): Image handling error. Failed to draw layer named
'Hurricanes'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
ORA-01861: literal does not match format string
. Query statement: SELECT OBJECTID, SHAPE FROM HYDRO.HURRICANES_TSQP
WHERE (hurr_date >= '2004-01-01' AND hurr_date <=
'2004-12-31') AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003,
8307,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,90)
),'querytype=window') = 'TRUE' . Check your data statement.
Seems to be an oracle-specific time formatting problem.
-- john
David William Bitner wrote:
John --
I have not used WMS-T with Oracle, but have you seen the docs for
using WMS-T with postgis?
http://mapserver.gis.umn.edu/docs/howto/wms_time_support/#example-of-wms-t-with-postgis-tile-index-for-raster-imagery
David
On 5/29/07, *John Cartwright * <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hello All,
I've having trouble getting the time requests passed to Oracle in
a way
that it understands. Has anyone done this successfully?
Thanks!
-- john
--
************************************
David William Bitner
