Solved

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

Posted on 2008-10-08
9
1,681 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
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

828 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