Package size

Hi ,

Could you please any body tell the limitation in the size of the database object Package body for the Oracle Version 8.1.6. or 8.1.7 or Version 8.0.5 in the NT server?

Thanks
Surya

check out:
PL/SQL USER's Guide and Reference
APP. E -- PL/SQL Program Limits

Hi Sysdba,

I did refer but limitation is given for version 7.3 , but I need to know the package body size for version 8.0 and above.

Surya

OTN (http://otn.oracle.com) has documentation of Oracel 8.x versions

HI,

CHECK WITH
SELECT * FROM USER_OBJECT_SIZE
WHERE TYPE = 'PACKAGE'
AND NAME = 'YOUR PACKAGE NAME';

THANKS..

For anonymous blocks its 64k and I believe the same for
pkg/procedures...

Hi Steive

I did refer the books and found 128K is the maximum parsed size for Version7.3, but I am looking for the maximum size limit in the Version8.0 or above..?

Hi OracleDBA8

If we do the query on USER_OBJECT_SIZE, we will get the size of our package body.But I am looking for the maximum size limit for the package bodies in version 8 or above.

Thanks for the replies.
Surya