Please send your Questions & Answers or Feedback to ""

Is there a limit on the size of a PL/SQL block?

Currently, the maximum parsed/compiled size of a PL/SQL block is 64K and the maximum code size is 100K. You 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'

Related Posts Plugin for WordPress, Blogger...
Flag Counter