In this article I will explain the method I use when I need to process an indeterminate number of rows using PL/SQL. I became aware of this method after reading Bryn Llewellyn’s white paper Doing SQL From PL/SQL: Best and Worst Practises (My example is based on the code shown on page 31 of the white paper) […]
“It was working yesterday…” Working in any form of shared development environment you will sooner or later hit a problem when something that used to work has either stopped working or is doing something it wasn’t doing before. So how do you find out what have changed? With regards PL/SQL objects such as Packages, Triggers […]
In this article I will demonstrate several different methods you can use to perform XSLT from within PL/SQL. The examples were built using Oracle Database 11.2.0.1.0 and SQL Developer 3.2 The examples are based on this XML document…. and this XSLT document…. XMLTRANSFORM OK, so the first example is actually SQL rather than PL/SQL! XMTRANSFORM is a SQL Function […]
iancarpenter.dev 