What can be the Maximum size of a plsql block?

Showing Answers 1 - 16 of 16 Answers

gouthami kodangal

  • Aug 13th, 2006
 

There is no limitation on the size of a plsql block.

  Was this answer useful?  Yes

Wadikar

  • Jul 11th, 2007
 

There is limit on PL/SQL code and it is depends on identifiers,literals,operators used in code.

  Was this answer useful?  Yes

Gaurav

  • Oct 4th, 2007
 

There is a limit. The limits typically range from 2000-3000 lines of code.

  Was this answer useful?  Yes

Ajay

  • Oct 18th, 2007
 

there is no limit on the number of bytes. however, there is a limit on the size of the parse tree generated for your pl/sql code.

  Was this answer useful?  Yes

jabir.mkk

  • Oct 16th, 2009
 

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'

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions