Category Archives: PL/SQL

Sorting and merging geometries in Oracle Spatial

Consider a requirement where an unsorted set of geometries needs to be merged into a single geometry. Take for instance the following set of geometries where: a Red dot indicates the startpoint The arrow indicates the drawing direction The label … Continue reading

Posted in G/Technology, Oracle, Oracle Spatial, PL/SQL | Tagged , , , , , | 4 Comments

Debugging Oracle PL/SQL from Visual Studio

I use TOAD for my day-to-day Oracle development, but I find it’s debugging experience very poor compared to Visual Studio. Using ODP.Net version 11 you can use Visual Studio to debug Oracle PL/SQL. Here’s how to do it. First you … Continue reading

Posted in Debugging, Oracle, PL/SQL, Visual Studio | Tagged , , | Leave a comment