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 -> PL/SQL: -- pkg runtime Size Limitations?

PL/SQL: -- pkg runtime Size Limitations?

From: Raghav Vinjamuri <raghav_vinjamuri_at_hotmail.com>
Date: 10 Oct 2002 11:32:38 -0700
Message-ID: <2e2fc08e.0210101032.75d082cf@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 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 Thu Oct 10 2002 - 13:32:38 CDT

Original text of this message

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