OraFAQ Forum: Spatial » ORA-13193: failed to allocate space for geometry

Home » Server Options » Spatial » ORA-13193: failed to allocate space for geometry

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

ORA-13193: failed to allocate space for geometry [message #172679]

Wed, 17 May 2006 10:57

ykevanranden
Messages: 4
Registered: July 2005
Location: Wageningen

Junior Member

ORA-13193: failed to allocate space for geometry Embarassed

ORA-06512: at "MDSYS.SDO_3GL", line 439
ORA-06512: at "MDSYS.SDO_GEOM", line 3034
ORA-06512: at "MDSYS.SDO_GEOM", line 3050

I get this error using a certain query in which i select a geometry object an create a buffer using a value from a column.

SO

select sdo_geom.sdo_buffer(point, 5,1) from table works fine

however if i use

select sdo_geom.sdo_buffer(point, avg_signal,1) from table

i get the above error.

I validated all the geometries in the table and they al validate as true. It work fine this afternoon and on a certain moment it simply ditd not work any more. I restarted my database, my machine however none solves the problem.

Report message to a moderator

Re: ORA-13193: failed to allocate space for geometry [message #172689 is a reply to message #172679]

Wed, 17 May 2006 11:51

ykevanranden
Messages: 4
Registered: July 2005
Location: Wageningen

Junior Member

I found the problem.

Adding a buffer with radius 0 was the problem.

Report message to a moderator

Previous Topic:	Getting Errors
Next Topic:	ORA-00939: too many arguments for function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 17:37:10 CST 2025