Solved

oracle Forms from 6i to 10g -only blank screen is displaying after deployment

Posted on 2008-10-08
9
1,656 Views
Last Modified: 2013-12-18
I have converted oracle Forms from 6i to 10g (almost 10 forms). In the development environment all 10 forms are working fine without any problems. I have deployed the forms in the server. Now all the forms are working fine except one form. Only blank screen is displaying in this case. What could be the reason? How to resolve this issue? This form is also working fine in the development environment.
Thanks for all your suggestions.
0
Comment
Question by:jyothsna1803
  • 4
  • 3
9 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 500 total points
ID: 22676059
hard to say what's the reason ... try to put some message codes to have control over the form.
start with the PRE-FORM trigger:

BEGIN
    MESSAGE(1);PAUSE;
    ...
    ... [your code]
    ...
    MESSAGE(2);PAUSE;
END;

then WHEN-NEW-FORM-INSTANCE, then on block level PRE-BLOCK, WHEN-NEW-BLOCK-INSTANCE and so on.

so maybe you are able to locate where the form stops ....
0
 

Author Comment

by:jyothsna1803
ID: 22679886
WHEN-NEW-FORM-INSTANCE is not firing and PRE-FORM trigger is firing. What could be the reson, how to tesrt/resolve this issue,
Thanks!
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22680218
PRE-FORM fires before WHEN-NEW-FORM-INSTANCE ... does PRE-FORM finish completly?
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:jyothsna1803
ID: 22680283
Just one small alert i have used in PRE-FORM Trigger. i am using the below line and it is displaying the message.
message( 'pre form Trigger');
Even i have written the same alery in the WHEN-NEW-FORM-INSTANCE trigger. but i am not seeing this messge. I thought after firing PRE-FORM trigger the process is stopped, but in the development it is working fine and i am seeing messages successfully.
0
 

Author Comment

by:jyothsna1803
ID: 22681725
I have written alert messages in the following triggers to verify above problem
pre form
pre block
pre record
pre text item
when new form instance

I got alert messages for pre form,pre block and pre record triggers. But not to pre text item. So is it the real issue with pre text item, anyway i am not getting any kind response to when new form instance trigger. Any suggestions please
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22684792
i'm not sure if Forms 10g supports this, in 6i you can debug the form by turning on Debug Mode: Tools --> Preferences --> Runtime --> Debug Messages
at runtime you will get a message for every trigger that is fired.
maybe this will help you to locate the problem ...?
0
 

Author Comment

by:jyothsna1803
ID: 22687580
Still no luck Jwahl. Thanks for all your help. I am developing a new form.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now