-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|