Re: PL/SQL: -- pkg runtime Size Limitations?

What version of ORACLE are you using?
For these packages, can you post the output from

select SOURCE_SIZE, PARSED_SIZE, CODE_SIZE from user_object_size where name = <Package name>;

• Jusung Yang

raghav_vinjamuri_at_hotmail.com (Raghav Vinjamuri) wrote in message news:<2e2fc08e.0210101032.75d082cf_at_posting.google.com>...
> Hi,
> Is there a limit on the max size a PLSQL pkg can
> takeup at runtime on the server?
>
> 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,
> Thanks,
> Sincerely,
> -Raghav Vinjamuri
>
> PS Do let me know if there is a different forum
> where this message should be addressed to. Thanks.
Received on Fri Oct 11 2002 - 01:51:46 CDT