Re: [MacPerl] MacPerl<=>Oracle

[larryat@cts.com (Larry F. Allen-Tonar)]

Greg, Nico,

What Nico responded with is not a 'dump', but a 'report' -- the output,
interactive or otherwise, using P/SQL.  The format can be varied tremendously.
For example,  'SQL> SET SPACE 0' would remove the space between fields,
and there are pagination, header, etc. controls.

A more-proper 'dump' would use a CSV (comma separated values) format, in
which each field is separated by a comma, each comma inside a value (and
?NewLine? and backslash) is escaped with a backslash.

I'd be interested in learning the best way to interface PERL to an Oracle
Db too.
-- Larry

Nico wrote:
>Greg Aiken wrote:
>>I'm interested to know what a dump from an SqlPlus interactive session
>>would look like.  Can you possibly send me something to look at?  Is this
>>basically a socket connection to a server with a well defined protocol?
>> What exactly, are you proposing to do?  DBI + DBD is the preferred Perl
>>interface method to databases, to include Oracle.  From what I've heard
>>these modules don't work with MacPerl, and a Mac porting of these modules
>>is required.
>
>Hallo,
>
>A dump (just a short example) of an interactive session
>with SqlPlus looks like :
>
>SQL> SELECT REGNR,FOLLUPNR,STR1,STR2,STR3,STR4
>  2  FROM RCAD.SKWT_TEST
>  3  WHERE REGNR <= 2000;
>
>     REGNR   FOLLUPNR       STR1       STR2       STR3       STR4
>---------- ---------- ---------- ---------- ---------- ----------
>       191          0         64         78       92.2

--
Regards, Larry F. Allen-Tonar        (larryat@cts.com) +1 760/746-6464 (voice)
         Principal Designer                              +1 760/746-0766 (FAX,
         P.O. Box 463072                                         upon request)
         Escondido, CA  92046-3072



***** Want to unsubscribe from this list?
***** Send mail with body "unsubscribe" to mac-perl-request@iis.ee.ethz.ch