Re: ORA-01013 error and Humble Pie!

From: Manu <emmanuel.pl.bontemps_at_wanadoo.fr>
Date: Wed, 2 Jun 1999 10:20:56 +0200
Message-ID: <7j2phg$e4$1@oceanite.cybercable.fr>

The cause could be DCD (Dead Connection Detected) from SQL*NET (or NET8). I already had this problem with Oracle 7.3 Have a look in sqlnet.ora. The parameter is sqlnet.expire_time=10.

Regards

Martin Strandgard a écrit dans le message <375476A0.87A6D3F3_at_landfood.unimelb.edu.au>...
>Recently I sent a message to this newsgroup concerning a problem I was
>having deleting records from an ORACLE 8 db via a VB5 application.
>
>The problem was that when I attempted to delete more than about 4000
>recs via VB, I received an ORA-01013 error, which is an informative
>error to let the user know that ORACLE received a CTRL-C. Now I knew I
>wasn't pressing CTRL-C so what was happening?
>
>After much chasing of ORACLE and ODBC red herrings, a colleague
>suggested that it could be a VB limit. Sure enough, the problem is
>caused by the default value of QueryTimeout being 60 seconds!
>
>Pass me another slice of humble pie, please. :)
>
Received on Wed Jun 02 1999 - 03:20:56 CDT