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: 535
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.


/forum/fa/10519/0/

Please advise.

Regards,
Irfan
  • Attachment: Webutil.png
    (Size: 59.26KB, Downloaded 13442 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: 21806
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: 535
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 messageGo to next message
Littlefoot
Messages: 21806
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

Re: FRM-40735:WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508. [message #640452 is a reply to message #609496] Tue, 28 July 2015 15:06 Go to previous message
rajesh4851
Messages: 89
Registered: January 2007
Member
Dear Friends,
I'm also getting the same error when i run one form in my local. I have started the weblogic server locally. Im using forms11g.

WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06502.


here is my form builder version:

Forms [32 Bit] Version 11.1.2.1.0 (Production)
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle Toolkit Version 11.1.2.1.0 (Production)
PL/SQL Version 11.1.0.7.0 (Production)
Oracle Procedure Builder V11.1.2.1.0 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 11.1.2.1.0 - Production
Oracle Virtual Graphics System Version 11.1.2.1.0 (Production)
Oracle Tools GUI Utilities Version 11.1.2.1.0 (Production)
Oracle Multimedia Version 11.1.2.1.0 (Production)
Oracle Tools Integration Version 11.1.2.1.0 (Production)
Oracle Tools Common Area Version 11.1.2.1.0
Oracle CORE 11.1.0.7.0 Production
Previous Topic: Re: FRM-40501 unable to reserve record for update or delete
Next Topic: How to Check a listbox change in oracle forms
Goto Forum:
  


Current Time: Fri Mar 29 07:39:02 CDT 2024