Re: PLSQL pkg runtime Size Limitations?

Obviously some of this code is running as a client. Communcations channel to me means network.

Bill

"Raghav Vinjamuri" <raghav_vinjamuri_at_hotmail.com> wrote in message news:2e2fc08e.0210101025.7d4c874_at_posting.google.com...
> Hi,
> Is there a limit on the max size a PLSQL pkg can
> takeup at runtime?
>
> The issue in essence, is that - we have a 3000
> line pkg, that works for 299,999 cases out of
> 300,000 cases.
>
> But, for that 1 case in 300,000, the
> processing breaks down.
>
> - There are no PLSQL exceptions raised.
> - We get a ORA-3113 - "end of file on communication
> channel" error in the front end.
> - Sometimes the db crashes.
>
> There is nothing different in terms of data
> volumes or elements being processed.
>
> However, given the reproducibility of this error,
> it lead us into thinking that there are some
> implicit size restrictions on PLSQL packages.
>
> We have experimented on breaking the package into
> smaller packages, and, per expectations - we do have
> a version that works. It works SOLID.
>
> But, except for this one version that works,
> there are 4 other versions, similarly "downsized",
> that do NOT work.
>
> How do we get a clue into breaking this impasse?
>
> Any pointers/suggestions/comments are gratefully accepted,
> Sincerely,
> -Raghav Vinjamuri
Received on Fri Oct 11 2002 - 05:41:30 CEST