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: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 28 Apr 2007 02:55:17 GMT
Message-ID: <pan.2007.04.28.02.55.17@verizon.net>


On Fri, 27 Apr 2007 07:55:20 +0100, Jonathan Lewis wrote:

> create or replace package body fail_n as
>
> g_target number(10) := 3;
> g_ct number(10) := 0;

Jonathan, one question: why didn't you create a public package variable, in the package spec? Putting the counter in the package counter would give you more control as the counter would be adjustable from an anonymous block, outside the package?

-- 
http://www.mladen-gogala.com
Received on Fri Apr 27 2007 - 21:55:17 CDT

Original text of this message

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