What is the limitation on the block size of PL/SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

As of now a compiled/ parsed block of PL/SQL has a maximum size limitation of 64K and max. code size being 100K. The statement for querying existing procedure or the package size is as follows:

SQL> select * from dba_object_size where name = 'procedure_name'

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle Interview Questions

    What is Oracle?

    Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..

    Oracle Interview Questions

    Define Oracle database

    An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...

    Oracle Interview Questions

    Explain Oracle instance.

    Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database,..