Actually, I did exactly this a few years ago. Only problem: NULLs show up as blanks ... Apart from that, it works like a charm!
-- Peter Vanroose. Op 23 jun. 2020 22:10, om 22:10, "Fennell, Brian" <fenne...@radial.com> schreef: >Another idea . . . > >You could also wrap Oracle SQLPlus in perl using qx > >How-to SQLPLUS and XML here: > >https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:3512822500346787661 > >That and a little perl text parsing could get you a long way - split , >grep, map, s and tr. > >This pure-perl module can parse the XML: >https://metacpan.org/pod/XML::SAX::PurePerl > >It would be great to have an Oracle DBD driver using pure-perl and >sqlplus only. No C complier needed, no buffer overflows to chase >down, no jvm and no "other" languages (except SQL). > >(no time for this kind of perl-uber-hacking myself but anyone looking >for a fun project . . . ) > >Another hack is to use perl with qx with jisql (and JDBC drivers) - I >have used this to access Microsoft SQLServer from perl with little >work. > >https://github.com/stdunbar/jisql > >Brian Fennell > > > > >The information contained in this electronic mail transmission is >intended only for the use of the individual or entity named in this >transmission. If you are not the intended recipient of this >transmission, you are hereby notified that any disclosure, copying or >distribution of the contents of this transmission is strictly >prohibited and that you should delete the contents of this transmission >from your system immediately. Any comments or statements contained in >this transmission do not necessarily reflect the views or position of >Radial or its subsidiaries and/or affiliates.
