DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Package size

  1. #1
    Join Date
    Dec 2000
    Posts
    9
    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

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    check out:
    PL/SQL USER's Guide and Reference
    APP. E -- PL/SQL Program Limits

  3. #3
    Join Date
    Dec 2000
    Posts
    9
    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

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    OTN (http://otn.oracle.com) has documentation of Oracel 8.x versions

  5. #5
    Join Date
    Feb 2001
    Posts
    184
    HI,

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

    THANKS..

  6. #6
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    For anonymous blocks its 64k and I believe the same for
    pkg/procedures...

  7. #7
    Join Date
    Dec 2000
    Posts
    9
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width