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
Solved

apex database question

Posted on 2008-10-29
9
2,210 Views
Last Modified: 2012-05-05
we have a apex page that uses a popup.  The popup works fine and refreshes the calling page.  however after the popup closes and we go to submit or choose another item on the page, the page closes and goes back to the login page.  Any clue as to why this would happen.  this only appears to happen on IE 7
0
Comment
Question by:BillyH-1
  • 5
  • 4
9 Comments
 
LVL 20

Expert Comment

by:gatorvip
ID: 22840066
How does the popup refresh the calling page? If you use a link, are you passing :APP_SESSION ? Or do you have an AFTER SUBMIT branch on the initial page that redirects to the login page?

You might want to post a sample app on apex.oracle.com or at least some code here...
0
 

Author Comment

by:BillyH-1
ID: 22840375
The popup (change or add date:etc) all works until you click on Submit changes and redirects to the login page. I have found that this only happens with IE7. When I use with IE6 the problem is not happening.
I also should have posted that we are running this on Tablet pc 2005 edition of Windows xp on Panasonic Toughbooks.
The After Submit button works fine as long as there is no popup window data entered.
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 22840548
i'm a little bit confused about the actual flow:
- page A launches popup
- popup refreshes calling page (how?)
- popup closes, then any further action on the calling page redirects to login
Is this right? Are you launching the popup via a button, something like this:

Button: redirect to URL
URL: javascript:popupURL('f?p=&APP_ID.:<your_page_id>:&SESSION.:::::')

If not, then how?

Where is the submit button? On the popup?
You haven't answered a couple of my questions: how does the popup refresh the calling page? And are you passing the session ID in your link(s)?

0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:BillyH-1
ID: 22840940
The popup is generated by a datepicker on page A.  All the code to handle this is built-in by Apex.  The code behind the Submit button on page A is generated by Apex as well.  It is a "save" operation to the XE database.  I do not explicitly pass a session link as I am utilizing the Apex built-in choices.  
0
 
LVL 20

Accepted Solution

by:
gatorvip earned 500 total points
ID: 22841616
Again you are not answering this question: how does the popup refresh the calling page? The default action for the datepicker is to close the popup window and to populate the text field with the date/time selected, it doesn't do anything else.

Do you have any branches that already exist on the calling page (under the Page Processing section)? If yes, do you have one that goes to your login page?

My suspicion is that your session id is not being passed but there's no way to be sure without seeing an actual example. One way to test this is by checking the ID in both IE6 and IE7, before submit and after.

Another thing you can do is to create a brand new page. Drop a date picker on it as well as a submit button that redirects to another page in your app. See if the same issue occurs in that case.

0
 

Author Comment

by:BillyH-1
ID: 22842286
To your paragraph 1, as to your question, your statement is correct.It populates the text fields with date/time and closes popup window. then when you click anythwhere else (Submit data or any other text box) it returns you to the login screen.

To your paragraph 2, I don't think there are any branches, but I will have to check.  I did not write the code.

To your paragraph 3, If the session id is not being passed, it is a bug in Apex.  It workins in IE6 and IE7 on my XP  Pro PC, but not on the tablet PCs using IE7.  But after being down graded to IE6, the tablets work as well.

To paragraph 4, we have tested the behavior after changing the definition of the trip date from a date picker to a text and the behavior clears up.  As we have said, it ONLY happens after a pop up has been  invoked.
I
I am not sure about the session ID.  I do not see it being shown on the address bar in the popup either on IE7 or IE6.  I did see some documentation about this possibly being the issue.  I am beginning to wonder if this is a issue with the IE7 specifically on these Win XP tablet PC versions.  I am going to try to reload IE7 and see that helps.
0
 

Author Comment

by:BillyH-1
ID: 22894092
Resolved by using Internet Explorer 6 instead of IE7.
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 500 total points
ID: 22894569
That is not really a solution but rather a workaround. I am unable to duplicate this issue on my end.

File a bug report at metalink.oracle.com if you have access to it, or post this in the APEX forum at http://forums.oracle.com/forums/forum.jspa?forumID=137 to see if anyone else is having this problem.
0
 

Author Closing Comment

by:BillyH-1
ID: 31511420
Thanks for the help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PL/SQL Two changes 7 34
error in my cursor 5 41
How to drop system generated virtual column in a table in12c 15 48
return value in based on value passed 6 27
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 recover a database from a user managed backup

839 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