OraFAQ Forum: Forms » FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509

Home » Developer & Programmer » Forms » FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 (OS :- Windows Server 2008 R2 Enterprise Edition 64bit ; Database VERSION :- oracle rac 10.2.0.4.0 (64bit); Application Server Version :-10.1.2.0.2 ;Jinitiator 1.3.1.22: test application reside on )

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

FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579421]

Tue, 12 March 2013 02:58

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

hello i have succusffly install webutil and also i did configuration also using this url

http://www.baigzeeshan.com/2010/01/open-file-dailog-box-example-using.html

and i succussfuly upload and download .pdf using my form on my test database server my test database its a single database its version also 10.2.0.4.0 .but when i upload and download my .pdf file on my live database server using this same form its give me error while upload

Quote:

FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509

my live database server its a RAC Database server its version 10.2.0.4.0 .so anybody help me in this error. i serach on google on this ora-06509 they told me

Cause: This indicates a version clash between some package distributed with an Oracle product and the product executable.
Action: Contact Oracle Support Services

.

but my question its my test database server and live database both server version are same its 10.2.0.4.0 just only its differece its test database its a single database server and live its a rac database server.
so why this error i got any solution you have please help me in this error because i have not oracle id for help and surrport so can you help me here please

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579454 is a reply to message #579421]

Tue, 12 March 2013 06:14

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

hello senior no any solution in this error .any one have any solution in this error please help me

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579456 is a reply to message #579454]

Tue, 12 March 2013 06:19

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

Senior Member
Account Moderator

So, did you contact Oracle Support Services? What did they say?

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579460 is a reply to message #579456]

Tue, 12 March 2013 06:51

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

thanks for your reply littlefoot..no i not contact oracle supoort because i do not have oracle help and support id.do you have any solution in this error so suggest me i can try it.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579463 is a reply to message #579460]

Tue, 12 March 2013 06:52

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

I sugget you get a support ID personally, assuming you're paying for an oracle licence I believe you should have access to oracle support.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579465 is a reply to message #579463]

Tue, 12 March 2013 06:55

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

just can you tell me this webutil its supported on oracle rac database.right now our organization have no plan for this.if you have any suggestion in this error please guide me i can try it.just can you tell me its webutil support oracle rac or not.because i can connect with my single database server its run successfuly so.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579473 is a reply to message #579465]

Tue, 12 March 2013 07:21

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

Senior Member
Account Moderator

I don't know, sorry.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579572 is a reply to message #579473]

Wed, 13 March 2013 05:47

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

please no any senior you have any suggestion into my this error.anybody please give me some hint how can i solve this error.its rac database error or application level error or form level error .suggest me please

[Updated on: Wed, 13 March 2013 05:55]

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579775 is a reply to message #579456]

Fri, 15 March 2013 01:41

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

no little foot i not contact them i already told you na.i not have oracle help and surrport id.may b i try db link from this my rac user to single database user.cause this form work successfully on my single database user but not work on my rac database so i connnect this my rac user to this single database user using db link.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579776 is a reply to message #579775]

Fri, 15 March 2013 01:46

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

Senior Member
Account Moderator

As I told you, I don't know what to do.

Feel free to try anything you think could help. If you succeed, please, share that information with us.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579777 is a reply to message #579776]

Fri, 15 March 2013 01:54

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

yeah but i successfully create db link on this my rac database server can u help me how can i use this db link into my oracle forms.cause i have no idea how to use this db link in oracle forms.just help me into this.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579778 is a reply to message #579777]

Fri, 15 March 2013 01:57

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

Senior Member
Account Moderator

How to use a DB link? As usual - name a table, add @ followed by a database link name. For example:

select * from emp@my_db_link

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579780 is a reply to message #579778]

Fri, 15 March 2013 02:04

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

yeah but in form level how can we use where to use this can u suggest me .yeah i know this how to use db link using sql*plus but how can i use this in oracle form.thanks for your reply littlefoot

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579781 is a reply to message #579780]

Fri, 15 March 2013 02:07

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

Senior Member
Account Moderator

Just the same, I don't think that there's any difference.

Report message to a moderator

Re: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509 [message #579797 is a reply to message #579780]

Fri, 15 March 2013 08:11

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

x-oracle wrote on Fri, 15 March 2013 03:04

yeah but in form level how can we use where to use this can u suggest me .yeah i know this how to use db link using sql*plus but how can i use this in oracle form.thanks for your reply littlefoot

Do you mean you want to base a block on a dblnked table?
why not create a view on the table with a dblink and base the block on it?

Report message to a moderator

Previous Topic:	Help with Data Block Based on Procedure--getting compilation error
Next Topic:	Microsoft TreeView Control 6.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:16:07 CDT 2024