OraFAQ Forum: Forms » FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

Home » Developer & Programmer » Forms » FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214919]

Thu, 18 January 2007 10:15

harleenflora
Messages: 44
Registered: June 2006

Member

I am in process of migrating Oracle 6i Forms to Oracle 10g Forms.

In 6i, the Form compiles and runs without any giving any error.
In 10g it does complie without any error but gives following Runtime Error Message -

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

Any ideas if I am missing something!!

Thanks,
Harleen Flora

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214920 is a reply to message #214919]

Thu, 18 January 2007 10:33

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi harleen,

at the form level u write code to trap error . and see why error is coming?

Ashu

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214923 is a reply to message #214919]

Thu, 18 January 2007 10:53

scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England

Senior Member

ORA-6508 is PL/SQL: could not find program unit being called.

Is it possible you've missed converting something the ON-ERROR trigger is calling?

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214928 is a reply to message #214919]

Thu, 18 January 2007 11:34

harleenflora
Messages: 44
Registered: June 2006

Member

There is almost no code in ON ERROR trigger, it just have null value in it (Seems like a somebody created this Form long time back)!

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214934 is a reply to message #214919]

Thu, 18 January 2007 12:10

harleenflora
Messages: 44
Registered: June 2006

Member

Since there is no code in ON_ERROR trigger, I deleted it but still getting the same error message.
Why?

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214947 is a reply to message #214928]

Thu, 18 January 2007 13:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

harleenflora

There is almost no code in ON ERROR trigger ...

Are you viewing the right ON-ERROR trigger? NULL statement doesn't raise an error.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214951 is a reply to message #214919]

Thu, 18 January 2007 13:14

harleenflora
Messages: 44
Registered: June 2006

Member

Looks like you are right!

I am looking at Form Level ON-ERROR trigger, I deleted the object but still getting the same error message...
I tried to find any other ON-ERROR in my Form using FIND option but couldn't find any.
Where else in Form you think this trigger could be?

Thanks for your help in advance.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214986 is a reply to message #214919]

Thu, 18 January 2007 19:27

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Is that form has attached libraries? Did you check if you have those libraries in proper directory?
I suggest to drop and re-attach those files.

Regards,

Wency

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #215366 is a reply to message #214986]

Sun, 21 January 2007 21:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you converted the libraries?

David

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #406354 is a reply to message #214919]

Wed, 03 June 2009 09:54

rnovillo
Messages: 2
Registered: November 2008
Location: Costa Rica

Junior Member

Hi all,

There is something you must check, if you want to avoid this error. Keep in mind, you are running over a new WEB environment, so when we are locally running any form (fmb), the FORMS_PATH we used to change on REGEDIT, now must be added/changed in DEFAULT.ENV (DEV10g_HOME)\forms\server...

So when OC4J is running, and our browser is trying to display the form you are running, all paths are going to be read from that DEFAULT.ENV...

Good luck! Wink

Wink

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #577712 is a reply to message #214919]

Tue, 19 February 2013 17:08

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

hi,

sorry for opening a long closed thread.

i too am facing the same problem .

I work on oracle 10g and devsuite 9i forms and reports on linux environment. its working fine. i installed oracle 11g and devsuite 11g forms and report in my laptop and imported oracle 10g dump file .

I compiled all forms and i could get the login screen . when i tried to connect it to the database it gives this error

FRM 40735 - ON ERROR TRIGGER RAISED UNHANDLED EXCEPTION -ORA 06508

when i looked at the imp log file , it looks like all views have not got imported. it gives a error message

imp -00041 - warning: object created with compilation warnings.

is this the problem . how do i import both tables and view

i used this query to import oracle 10g dump file in command prompt

imp file =<file name.dmp> fromuser=myuser touser=myuser buffer=200000 commit=y log=imp.log

it would be great if anyone could suggest some help to solve this issue

thanks in advance

narayan

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #577737 is a reply to message #577712]

Wed, 20 February 2013 00:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to recompile invalid objects (views, packages, procedures, functions).

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #577813 is a reply to message #577737]

Wed, 20 February 2013 20:04

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

littlefoot,

thanks a lot. i did recompile forms, menus, libraries, functions, packages, proceedures and views. Yet the problem persists. My doubt-- is it because i am importing a oracle 10g dump file into oracle 11g . since all views have got imported without any values.

I also deleted the library file from all forms and reattached it. After that reports opened the parameter form, but after that it gave an error
REP-110: Unable to open file 'R_REG_CUM_PREM.rdf'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'R_REG_CUM_PREM.rdf'.
When i opened the report from report builder it works fine.

Any thing else i have missed out.

thanks

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #577821 is a reply to message #577813]

Thu, 21 February 2013 00:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Generally speaking: when moving data from two different database versions, then you should export data with LOWER export utility version (which would be 10g in your case) and import data with TARGET import utility version (which is 11g in your case).

Quote:

all views have got imported without any values

Views don't contain data. They are just stored queries (i.e. SELECT statements), selecting data from underlying tables. Which means: if SELECT FROM VIEW doesn't return anything, it means that data is missing in these TABLES. Re-check the import log file; some tables failed to import correctly. Or, if a VIEW is based on tables in other schemas or databases and acquired data via database links, then you'll need to recreate them as well. Anyway, you'll have to look closer into these views.

As of report issues: did you correctly set new locations (I mean, path to these reports) if you moved them to a new system as well?

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #578146 is a reply to message #577821]

Sun, 24 February 2013 18:40

lacchhii
Messages: 151
Registered: May 2009
Location: bangalore

Senior Member

Quote:

Or, if a VIEW is based on tables in other schemas or databases and acquired data via database links, then you'll need to recreate them as well.

sir,

I did queried on views. it does not contain any values whereas in my server version those views have values. all views are based on tables in the same schemas. how do i recreate views. is it to drop view and then create. As i told earlier i have compiled all views, proceedures, packages and functions as well as all forms.

i have not compiled the reports. just for checking i did compiled 1 report but it gave the error mentioned earlier.

Quote:

As of report issues: did you correctly set new locations (I mean, path to these reports) if you moved them to a new system as well?

where do we set the path for reports. i was only aware that the form_path need to be set at regedit, default.env

I thought i might have done importing wrongly, so did install db and devsuite in another desktop and imported an other file . even in that i am struck with the same problem.

Is this because some of the proceedures, packages or function have not got imported properly.

Is it possible to import any of those missing proceedures, packages or function now.

awaiting for some suggestions / solution....

thanks

[EDITED by LF: fixed [quote] tags]

[Updated on: Mon, 25 February 2013 00:46] by Moderator

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #578153 is a reply to message #578146]

Mon, 25 February 2013 00:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As of views: I don't feel like repeating myself. Everything I meant to say, I have already said. You can review those lines.

As of reports path: on MS Windows, that would be REPORTS_PATH, located in Windows registry.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659545 is a reply to message #214919]

Fri, 20 January 2017 11:36

Udai Pratap
Messages: 4
Registered: January 2017

Junior Member

Compare all .pll files in WEbTier $AU_TOP/resource/ from other running instance and copy paste the missing
(JE.pll/VERT.pll/IGILUTIL.pll/ or any other .pll) files in $AU_TOP/resource/ then bounce the services.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659546 is a reply to message #659545]

Fri, 20 January 2017 11:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

thread is only 10 years old & Forms6 is obsoleted, unsupported, & unavailable

Please join the 21st Century at your earliest convenience.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659547 is a reply to message #659546]

Fri, 20 January 2017 11:57

Udai Pratap
Messages: 4
Registered: January 2017

Junior Member

Application Forms not Launching after login in EBS 11i/R12. Compare all .pll files in WebTier $AU_TOP/resource/ from other running instance and copy paste the missing
(JE.pll/VERT.pll/IGILUTIL.pll/ or any other .pll) files in $AU_TOP/resource/ then bounce the services.

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659549 is a reply to message #659547]

Fri, 20 January 2017 14:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure I understand what you have said; what does EBS 11i/R12 have to do with the original discussion?

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659554 is a reply to message #659549]

Fri, 20 January 2017 16:31

Udai Pratap
Messages: 4
Registered: January 2017

Junior Member

Actually I get the same error "FRM-40735: ON-ERROR trigger raised unhandled axception ORA-06508" when I launch the forms after login in front end.

Also I go through the many oracle docs :

1:: => FRM-40735:ON-ERROR Trigger Raised Unhandled Exception ORA-06508 Occurs When Launching Application Forms (Doc ID 1523945.1)
2:: =>Cannot Log into Oracle Applictions after the Custom.pll has been Changed (Doc ID 146038.1)
3:: =>Oracle Application Return The following Error FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508 (Doc ID 797293.1)
4:: =>Receipts Workbench Error: Listing of FRM Errors (Doc ID 1361887.1)

But not any one resolve my issue.

after that I compare all .pll files in $AU_TOP/resource/ with another running instance then I found that there is 1-2 .pll files are missing.
so Copy & paste that .pll files from running instance to current instance and bounce the services ,it works fine for me . Smile

Smile

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659555 is a reply to message #659554]

Fri, 20 January 2017 17:01

Udai Pratap
Messages: 4
Registered: January 2017

Junior Member

Above steps works for me . Smile

Smile

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659556 is a reply to message #659555]

Fri, 20 January 2017 18:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Udai Pratap wrote on Fri, 20 January 2017 15:01

Above steps works for me .

NOBODY cares about this 10 YEAR old thread on obsoleted & unsupported software!

http://www.vesterli.com/2008/01/31/oracle-forms-6i-officially-unsupported-tomorrow/

Report message to a moderator

Re: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #659559 is a reply to message #659556]

Sat, 21 January 2017 11:21

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ah, OK, now I understand. It is much more clear when you properly describe what you did and why; without the explanation, it looked like a wildpost. Thank you!

Report message to a moderator

Previous Topic:	Navigation problem between records in a multi block form
Next Topic:	character error in oracle forms / error nls lang

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 14:04:53 CST 2025