-
Dear Sir,
We, at Datamatics ltd., are currently migrating programs on 'Databus' platform to 'VB 5.0' & 'Oracle 8.0.4'. There are 420 programs to be migrated. With the help of our in-house tool we have migrated 70% of all the programs to the target platform. Rest 30%, we have manually altered to get the desired code.
Now when we compile the programs, it gives an error viz. 'Procedure Too Long'. We browsed through the help file & found that a procedure can have a max. size of 64K only, whereas the average size of our programs is 200K. Is there any way to overcome this limitation ?.
We have tried to work out the worst case situation also viz. splitting each procedure into a number of procedures of less than 64K each. But, it is observed that even though we split the procedure into individual procedures of 59K each approx., still the same error is encountered.
How do we tackle this situation effectively ?. Kindly let us know as soon as possible since we have reached a deadlock.
Thanks & Regards,
Girish Shastri
-
I don't know what the source of your problem is, but I can tell you that if the sizes for your code that you mention are accurate, then I don't believe that that is the problem. I have a program that contains three code modules with sizes of 830, 420, and 180KB, and one of the modules contains a much to large procedure that is 84KB by itself, and I have no problem. Please post the section from help that refers to a 64KB limit, because while there may be a limit, I'm not aware of one. Also if you like, send me a zip file containing one of the problem projects and I'll take a look at it.
------------------
Marty
