question

OracleApprender avatar image
OracleApprender asked

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

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.

oracleplsql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
OracleApprender avatar image
OracleApprender answered

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'

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.