Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: perl and Oracle8

Re: perl and Oracle8

From: Danielle Engel <dogbert_at_myremarq.com>
Date: Sun, 23 May 1999 01:28:19 -0400
Message-ID: <374791F3.A5B7801B@myremarq.com>


That question is beyond my expertise, but what I figured out how to do is use Perl to start SQL+ (using a script name in the command line parameter). I can run a fairly complex SQL+ script, and spool the output as well to log the results.

ujm_at_edv.ch wrote:

> We load data into Oracle 8/NT using perl/ODBC.
> We now get a ORA-03113 error (end-of-file on communication channel) on
> the SECOND SQl statement in each program
> - this happens for any SQL statement, i.e SELECT, UPPDATE etc.
> We can use other tools on the same machine with success (TOAD, SQl
> worksheet, ODBC Test).
> We habve reinstalled perl and ODBC copied from working machines -
> still doesn't work.
> We have tested the program on identical machines, it works fine.
>
> I have no idea where even to start looking!
>
> Any help appreciated!
> Urs J. Misteli
> ujm_at_edv.ch
Received on Sun May 23 1999 - 00:28:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US