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.
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.