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

Home -> Community -> Usenet -> c.d.o.server -> Re: PUZZLE: A call that succeeds N times then fails for any single connection

Re: PUZZLE: A call that succeeds N times then fails for any single connection

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 26 Apr 2007 22:30:02 -0500
Message-ID: <ups5quxi7.fsf@rcn.com>


On 26 Apr 2007, joe.weinstein_at_gmail.com wrote:
> Hi all. I want some parameter-less SQL or procedure that will run
> uneventfully N times for any given DBMS connection, but will then
> *fail* such that the caller gets some ORA-XXXXXX error. I would
> like this as light-weight and quick as possible.

Is this procedure called by java and therefore java has been forced to deal with an exception, or are you trying to mimic a connection in the connection pool all of the sudden croaking?

-- 
Galen Boyer
Received on Thu Apr 26 2007 - 22:30:02 CDT

Original text of this message

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