Home » SQL & PL/SQL » SQL & PL/SQL » Web page redirect
Web page redirect [message #198025] Fri, 13 October 2006 20:48 Go to next message
Duane
Messages: 452
Registered: December 2002
Senior Member
Is this the correct way to accomplish what I'm trying to do.

Problem:

  • Contact (Server A) from PL/SQL
  • (Server A) sends back redirect URL
  • User's browser redirects to URL that was sent back from (Server A)


My Solution:

  • User's browser hits PL/SQL procedure
  • PL/SQL procedure uses UTL_HTTP to contact (Server A)
  • Response from UTL_HTTP is read from (Server A) with redirect URL
  • User's browser redirects to URL that was sent back from (Server A)


Is UTL_HTTP the correct procedure to use to contact a server and read a response that includes a redirect URL? I'm thinking UTL_HTTP isn't the correct procedure to use for what I'm trying to do.
Re: Web page redirect [message #198045 is a reply to message #198025] Sat, 14 October 2006 01:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
There are several ways to redirect. This page shows some of them.
Re: Web page redirect [message #198085 is a reply to message #198045] Sat, 14 October 2006 10:27 Go to previous messageGo to next message
Duane
Messages: 452
Registered: December 2002
Senior Member
So, I take it, using UTL_HTTP is not the correct way to do what I want to do?

Any ideas on how to do it in PL/SQL?
Re: Web page redirect [message #198200 is a reply to message #198085] Mon, 16 October 2006 02:54 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'd use the OWA_UTIL.REDIRECT_URL procedure personally.
Re: Web page redirect [message #198539 is a reply to message #198025] Tue, 17 October 2006 09:28 Go to previous message
Duane
Messages: 452
Registered: December 2002
Senior Member
OWA_UTIL.REDIRECT_URL redirects to the site but it loses the other sites redirect. It only works if I hit the back button.

Here's a pictures of whatt I'm trying to do. What I can't figure out is how to contact the other site and read the redirect URL.

  • Attachment: itunes.gif
    (Size: 34.53KB, Downloaded 264 times)
Previous Topic: Difference between Primary key and Unique key
Next Topic: Cursor limit
Goto Forum:
  


Current Time: Fri Dec 02 14:21:26 CST 2016

Total time taken to generate the page: 0.17249 seconds