As a part of my last article on tracking down and correcting ORA-13011 errors when using SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT() , I showed how to update the diminfo structure associated with a table’s geometry column in its USER_SDO_GEOM_METADATA entry. Here was the code in that article. Now, that code is pretty neat, but it has in it aRead More
I was sent a request for help the other day from some I know overseas: Do you know the true meaning and impact of ‘ORA-13011 value is out of range’? I have a dataset with a lot of very (almost impossible) precise data coming from Bentley microstation. And we have a ‘businessrule’ that the defaultRead More
I gave a talk last year entitled Automated Layer Management – Experiences At Mid Coast Water which was about mapping the area that would be affected by a mains pipe bursting in either a sewer or water network. (Yes it was a not very exciting title.) The mapping was all done in 2D as OracleRead More
Sometimes things are simple and prosaic rather than clever and complicated. Building solutions in TSQL requires one to build a prior collection of handy functions before one can be really productive. Here is a function I use called isGeo which if provided the name of a table/view and a column name returns 1 (true) ifRead More