OraFAQ Forum: Forms » How to pen a procedure in attached libraries in Forms Builder

Home » Developer & Programmer » Forms » How to pen a procedure in attached libraries in Forms Builder (10g Forms Builder )

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

How to pen a procedure in attached libraries in Forms Builder [message #657303]

Fri, 04 November 2016 14:00

jwang02
Messages: 26
Registered: May 2014
Location: Indiana

Junior Member

I got an error message: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-1422
when I pushed PageDown to populate a child section after entering fields in parent section.

I did this without problem in dev environment with old data. Production has newer data and has this issue

I checked WVI triggers in those data blocks and found some of them reference procedures in Attached Libraries.
How to open or edit a procedure in Attached Libraries?

Am I doing right to fix the bug?

Report message to a moderator

Re: How to pen a procedure in attached libraries in Forms Builder [message #657342 is a reply to message #657303]

Mon, 07 November 2016 03:10

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

Senior Member

You open up the attached library itself and then you can see/modify the code in it.

Report message to a moderator

Re: How to pen a procedure in attached libraries in Forms Builder [message #657505 is a reply to message #657342]

Thu, 10 November 2016 14:31

jwang02
Messages: 26
Registered: May 2014
Location: Indiana

Junior Member

Thank you for answering my question.

However, I clicked/double-clicked the procedure name under Attached Libraries, and nothing came out.
I right clicked to have a menu, and tried to use SQL/PL Editor to open it, the same thing.

I checked the procedure name in the database, and could not find it.

How to open it?

Report message to a moderator

Re: How to pen a procedure in attached libraries in Forms Builder [message #657559 is a reply to message #657505]

Mon, 14 November 2016 03:41

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

Senior Member

Have you actually opened the library as a separate file? you need to use open from the file menu, same as opening an fmb.
You try to look at it from the attached libraries node under the form you will not be able to access the code.

Report message to a moderator

Re: How to pen a procedure in attached libraries in Forms Builder [message #658028 is a reply to message #657559]

Wed, 30 November 2016 23:35

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

You may click on the procedure name and drag the same into your Program units node in your object navigator and drop the same. You can debug from here and finally you can delete it from Program units.

Report message to a moderator

Previous Topic:	When I Run the oracle form Builder I got error
Next Topic:	Mobility application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:08:48 CST 2024