Home » Developer & Programmer » Forms » FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508 [message #214919] Thu, 18 January 2007 10:15 Go to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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)!
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you converted the libraries?

David
icon12.gif  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 Go to previous messageGo to next message
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

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 Go to previous messageGo to next message
lacchhii
Messages: 136
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to recompile invalid objects (views, packages, procedures, functions).
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 Go to previous messageGo to next message
lacchhii
Messages: 136
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

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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
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 Go to previous messageGo to next message
lacchhii
Messages: 136
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 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: Bypass login with Oracle database
Next Topic: radio button and then text item
Goto Forum:
  


Current Time: Sun Dec 11 04:38:12 CST 2016

Total time taken to generate the page: 0.08712 seconds