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" 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:0P11_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.
