| Custom.pll problem [message #178387] |
Tue, 20 June 2006 23:33  |
deepayan
Messages: 51
Registered: December 2005
|
Member |
|
|
Hi All,
I need to make some changes in custom.pll. But whenever I am going to do that it is giving an error "Program too large".
What may be done regarding this?
Removing spaces & comments is of no help & I can't remove existing codes also .
Thanks in advance.
---------
Deepayan
|
|
|
|
| Re: Custom.pll problem [message #178555 is a reply to message #178387] |
Wed, 21 June 2006 08:59  |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
Deepayan,
It could be that you have hit size limit for a PL/SQL package in Oracle Forms. Is your CUSTOM package huge? If so, you should consider dividing the code up into several packages.
Personally, I like to have a separate package for each form I use the CUSTOM Library to extend. In the CUSTOM package I only call the corresponding functions and procedures in the form-specific packages. Just make sure to give the new packages names after CUSTOM alphabetically, or you will get errors. I usually name them XX_<name of form>.
If you have many people working on CUSTOM Library extensions at the same time, it is also worthwhile to consider putting the packages in separate PLLs. There is a performance hit, but you will be able to migrate extensions to different forms more or less independently.
This is however no longer such a big concern after the advent of forms personalisations. The need to do CUSTOM Library extensions have been reduced significantly.
--
Aleksander Dragnes
|
|
|
|
|
|
| Re: Custom.pll problem [message #180114 is a reply to message #178387] |
Fri, 30 June 2006 03:28 |
konka_kiran
Messages: 56
Registered: May 2006
Location: Bangalore
|
Member |
|
|
Hai Deepayan,
As Alexander said, try to create the custom plls and call them using the custom.pll, this will surely solve your problem. But the area of concern here is that the performance issue has to be considered while coding such a big requirement.
You also, try to use the forms personlization fature.
This will give most of the requirements fulfilled.
Regards,
Kiran
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
