Home » Developer & Programmer » Forms » FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. (Forms11g)
FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #570955] Mon, 19 November 2012 05:16 Go to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear All,
I am trying to Configure Webutil in Forms 11g.
I follow the same instructions as mentioned in https://support.oracle.com
Note: For 11g Forms see Note 1093985.1 "How to Configure Webutil in Forms 11g ".

When run the Demo form getting below error.
FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508.


./fa/10519/0/

Please advise.

Regards,
Irfan
  • Attachment: Webutil.png
    (Size: 59.26KB, Downloaded 2824 times)
Re: FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #570976 is a reply to message #570955] Mon, 19 November 2012 07:53 Go to previous messageGo to next message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle

ORA-06508: PL/SQL: could not find program unit being called

Cause: An attempt was made to call a stored program that could not be found.
The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.

[Updated on: Mon, 19 November 2012 07:53]

Report message to a moderator

Re: FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #570979 is a reply to message #570976] Mon, 19 November 2012 08:21 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thanks for reply.
Problem Solved !
1- Copy Webutil.pll in FORMS_PATH folder & complile it.
2- GRANT CONNECT ,RESOURCE,CREATE PROCEDURE,CREATE PUBLIC SYNONYM TO webutil user;
3- Recompile WEBUTIL_DB_LOCAL (Package Body)in Webutil.pll.



Regards,
Irfan


[Updated on: Tue, 20 November 2012 04:29]

Report message to a moderator

Re: FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #609489 is a reply to message #570979] Fri, 07 March 2014 07:14 Go to previous messageGo to next message
Alez
Messages: 1
Registered: March 2014
Location: Lima
Junior Member
Buenas dias , tengo el mismo problema y he tratado de seguir tus pasos para solucionarlo, pero no encuentro la carpeta FORMS_PATH y no entiendo los pasos de mas abajo me podrian dar una mejor explicacion por favor.

necesito solucionar este problema cuanto antes
Tmb estoy trabajando en Oracle 11g.

Gracias de Antemano.


Good day, I have the same problem and have tried to follow your steps to fix it, but can not find the folder FORMS_PATH and do not understand the steps below might give me a better explanation please.

I need to fix this problem asap
Tmb am working on Oracle 11g.

Thanks in advance.



[EDITED by LF: inserted English translation for non-Spanish speakers (me included)]

[Updated on: Fri, 07 March 2014 10:56] by Moderator

Report message to a moderator

Re: FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #609496 is a reply to message #609489] Fri, 07 March 2014 10:55 Go to previous message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yo no hablo español, lo que es la traducción realicé por Google Traductor así - lo siento si suena extraño.

FORMS_PATH no es una carpeta en sí, debería comparar variable de entorno (o una entrada del Registro de Windows), cuyo nombre es FORMS_PATH y copiar PLL en esa carpeta.

Por ejemplo, si "FORMS_PATH = C:\Oracle\my_forms", que había copiar webutil.pll en C:\Oracle\my_forms carpeta.



I don't speak Spanish; this is translation performed by Google Translator so - sorry if it sounds strange.

FORMS_PATH is not a folder per se; you should check environment variable (or Windows Registry entry) whose name is FORMS_PATH and copy PLL into that folder.

For example, if "FORMS_PATH=C:\Oracle\my_forms", you'd copy webutil.pll into C:\Oracle\my_forms folder.

[Updated on: Fri, 07 March 2014 10:57]

Report message to a moderator

Previous Topic: How to increase the Alert Title Width
Next Topic: List of Value
Goto Forum:
  


Current Time: Fri Dec 19 20:02:24 CST 2014

Total time taken to generate the page: 0.08598 seconds