Originally posted by tamilselvan The source code (PL/SQL) limitations are:
Upto 7.3.4, it is 64K
From 8.0 upto 22.214.171.124, it is 128K.
From 126.96.36.199 , 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.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?