Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PUZZLE: A call that succeeds N times then fails for any single connection
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.comReceived on Fri Apr 27 2007 - 21:55:17 CDT
![]() |
![]() |