OraFAQ Forum: Forms » Oracle forms

Home » Developer & Programmer » Forms » Oracle forms

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

Oracle forms [message #684553]

Tue, 29 June 2021 00:27

Rakesh8522
Messages: 1
Registered: June 2021

Junior Member

Hi

I have a fmb file and I need to find a plsql code in it.

My problem is after cancelling the order when I go back to the history the drop date in the cancelled order is picking future random date but not same as the date there when we ordered. So I thought I need to find a plsql code that relates to cancel line and drop date. I searched for that but I couldn't find it anywhere.
If anyone understand this problem please help me out.

Report message to a moderator

Re: Oracle forms [message #684567 is a reply to message #684553]

Tue, 29 June 2021 15:37

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

Senior Member
Account Moderator

Which Forms version is it? If it supports debugging, put a breakpoint into one of PL/SQL units (a trigger, for example). If you want to start debugging at once, put it into a WHEN-NEW-FORM-INSTANCE trigger (if you don't have it, create one; doesn't have to contain anything smart, a "NULL;" statement would do).

Then run the form and move forward step-by-step and you'll, hopefully, find what's going on.

If your Forms version doesn't support debugging (that would be 6i or lower), then you'll have to do it manually, by putting "MESSAGE" calls into triggers and procedures so that you'd know what's going on.

Also, maybe you could trace the session, use TKPROF and review the result.

Report message to a moderator

Previous Topic:	Load data from txt file and csv
Next Topic:	display values in form6i run time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:26:06 CDT 2025