Originally posted by tamilselvan
The source code (PL/SQL) limitations are:
Upto 7.3.4, it is 64K
From 8.0 upto 8.1.3.4, it is 128K.
From 8.1.3.4 , it is 256M.
Those are only *very roughly estimated limits* of maximal PL/SQL source code length. PL/SQL compiler is actualy not limited by the size of source code, its actual limit (regarding the size of the code it has to compile) is the size of the "parse tree" it builts out of the source code. And the corelation between the size of the source code and its parse tree can only be very roughly estimated. So for example, with 7.3 you could easily compile PL/SQL object that has much more source code than 128K, but you won't be able to compile another PL/SQL object that is much smaler than 128K.