PL/SQL代码以获取重定向的URL | SQL代码以获取重定向的URL

本文介绍了PL/SQL代码以获取重定向的URL的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

已要求我编写PL/SQL代码以获取定向页面的URL.

I've been asked to write PL/SQL code to get the URL of the directed page.

一个URL可能会自动重定向到另一个URL.

One URL may be automatically redirected to other URL.

例如，链接http://www.arabseed.com可能被重定向到http://www.arabseed.com/ar/home.html.

For example the link http://www.arabseed.com maybe redirected to http://www.arabseed.com/ar/home.html.

因此，我的PL/SQL块应接受第一个URL，然后返回第二个URL.我在Oracle API中查看了@htp pkg，但对我没有太大帮助.

So my PL/SQL block should accept first URL and return second one. I have looked @ htp pkg in Oracle API and it did not help me a lot.

推荐答案

从您提供给我们的信息中，我只能提出以下建议:

from the info you gave us I'm only able to come up with this:

function get_redirected_url (url varchar2) return varchar2 is
begin
  case url
    when 'http://www.arabseed.com' then return 'http://www.arabseed.com/ar/home.html';
    when /* other URLs go here */
    else return '';
  end;
end;

但是，我很确定这不是您要的.您必须完善您的问题.

However, I'm pretty sure that's not what you've been asked for. You'll have to refine your question.

也许这都是您的管理者的错，因为实际上Web服务器将处理默认重定向.

Perhaps it's all your managers fault, because in fact the webserver would handle the default redirects.

这篇关于PL/SQL代码以获取重定向的URL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！