?
Solved

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

Posted on 2008-10-08
9
Medium Priority
?
1,758 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 2000 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
Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

 

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

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.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

719 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