PS. Forgot to mention that this is 9i. I have not yet had the time to
look at the 10G's improvments (if any) in this regard.. nor if some
nasty bugs have been fixed. Even so, I like the OR features in Oracle,
especially in the PL/SQL side. Pity that not many seem to be using it.
Wrapping DBMS_SQL into a TCursor class for dynamic SQL.. creating a
TDevice class (with subclassing) to handle various types of outputs
(HTML, UTL_FILE, XML, CSV, etc.) and then piping the output of one into
the others.. simply freakingly neat code. Easy to maintain. Easy to
use. Easy to extend.
--
Billy
Received on Fri Jun 24 2005 - 01:12:16 CDT
