Anybody knows that whether there is any limit on the size of a PL/SQL block. If yes then is it again different for Oracle 9i and 10g. Thank you in advance.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Currently, the maximum parsed/compiled size of a PL/SQL block is 64K and the maximum code size is 100K.
We can run the following select statement to query the size of an existing package or procedure. SQL> select * from dba_object_size where name = 'procedure_name'
No one has followed this question yet.
What are Anonymous Blocks in PL/SQL ?
Can anyone explain this PL/SQL block Error
Sleep command in pl/sql ?
Difference between case and code statements in oracle?
Conversion of a number from decimal to hexa decimal?