Tuesday, September 27, 2005
SQL, XML and state-of-the-art programming...
The more things change the more they stay the same.
Just this week I created a utility SQL procedure to dump an Oracle database record as XML into a file:
http://drrw.net/downloads/XML/go-file.sql
Much to my horror this state of the art programming is using routines that Oracle implemented way back when in V1.6 over 15 years ago when I was working on UNIX and Windows 3.1 environments with their original product release. This includes such gems as 255 byte limits on line print statements that allowed their code to run on 8086 machines.
Hands-up anyone out there running Oracle 10g on a 8086 machine? I did not think so!
About time Oracle upgraded these antiquated and archiac parts of their product to 2005+ standards and to provide XML DOM compatible API routines for their dbms_xmlgen library and also output options to web service and email interfacing not just file locations inside the server. It's not like these things are shocking radical wide-eyed notions here!
Latest version of full debugged and tested SQL XML dump utility - nicely procedurized - just plug in your own SQL statements and run.
Just this week I created a utility SQL procedure to dump an Oracle database record as XML into a file:
http://drrw.net/downloads/XML/go-file.sql
Much to my horror this state of the art programming is using routines that Oracle implemented way back when in V1.6 over 15 years ago when I was working on UNIX and Windows 3.1 environments with their original product release. This includes such gems as 255 byte limits on line print statements that allowed their code to run on 8086 machines.
Hands-up anyone out there running Oracle 10g on a 8086 machine? I did not think so!
About time Oracle upgraded these antiquated and archiac parts of their product to 2005+ standards and to provide XML DOM compatible API routines for their dbms_xmlgen library and also output options to web service and email interfacing not just file locations inside the server. It's not like these things are shocking radical wide-eyed notions here!
Latest version of full debugged and tested SQL XML dump utility - nicely procedurized - just plug in your own SQL statements and run.
