| Why do Users get error Ora-06508 after form elevation [message #160179] |
Thu, 23 February 2006 13:27  |
snachtegaele
Messages: 2
Registered: February 2006
|
Junior Member |
|
|
Hi, We have encountered the following problem a number of times after an elevation of forms to our production environment. The Users get the error Ora-06508 when they use some of the forms that were elevated to production the previous evening. There are no invalid packages, views, triggers, procedures, functions etc. Sometimes just regenerating the executeable and re-elevating the executeable works but sometimes it doesn't. Sometimes we have to drop the attached libraries and re-attach them, create the executeables and re-elevate. A number of people have looked at this problem but as yet we have not come up with a reason why this is happening. If we could determine why it is happening then we could take steps to resolving the problem. Any help would be greatly appreciated. Thanks.
Sharon
|
|
|
|
|
|
|
|
| Re: Why do Users get error Ora-06508 after form elevation [message #160215 is a reply to message #160185] |
Thu, 23 February 2006 22:33  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
If you have changed any PLL then you really should recompile ALL Forms. If the change was to INSERT a procedure or function into the library as against adding it to the end, or deleting one then you HAVE to recompile all forms. The 'pcode' name lists will not match between the library and the form to which it is attached.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
