Re: htp "301 Moved Permanently"



marathoner@xxxxxxxx wrote:
I found it:

owa_util.status_line(301,FALSE);
owa_util.redirect_url('http://www.abcd.com', TRUE);

I'm aware some of the DBA folks out there couldn't care less. I post
it here just in case somebody needs it in the future.

Many thanks to those who replied.

Lei

On Jul 16, 1:28 pm, maratho...@xxxxxxxx wrote:
Hi,

Is it possible to redirect a web page using htp? I want the web page
to send a "301 Moved Permanently" message.

Thanks in advance.

Lei

Now that it is clearer what you intended ... your demo code will not run.

SQL> BEGIN
2 owa_util.status_line(301, FALSE);
3 owa_util.redirect_url('http://www.psoug.org', TRUE);
4 END;
5 /
owa_util.status_line(301, FALSE);
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'STATUS_LINE'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

SQL>

You are missing one of the parameters in status_line. Try this instead:

SQL> ed
Wrote file afiedt.buf

1 BEGIN
2 owa_util.status_line(301, '', FALSE);
3 owa_util.redirect_url('http://www.psoug.org', TRUE);
4* END;
SQL> /

PL/SQL procedure successfully completed.

SQL>
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • Re: htp "301 Moved Permanently"
    ... I'm aware some of the DBA folks out there couldn't care less. ... Is it possible to redirect a web page using htp? ...
    (comp.databases.oracle.server)
  • Re: simple query with distinct keyword
    ... it for amost and hour and a half and I cant make it work. ... I am a bit of a newb to SQL, so pardon the 'basicness' of my ... Sux being a total newb. ... I don't care which of the 'dup' records ...
    (comp.databases.ms-access)
  • Re: simple query with distinct keyword
    ... I am a bit of a newb to SQL, so pardon the 'basicness' of my question ... but I still cant seem to get what Im after. ... being a total newb. ... I don't care which of the 'dup' records gets ...
    (comp.databases.ms-access)
  • Re: As VB index help
    ... If you are using Access instead of SQL, ... instead of SQLDataAdapter, OLEDBCONnection instead of SQLConnection, ... I care about build a program with a mdb database in VB. ... (I dont care about SQL servers databases) ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Can start SERVICE
    ... Care to post it here so others can benefit? ... Regards, ... Hank Arnold ... >> Am using SQL Server2000 on WINXP. ...
    (microsoft.public.sqlserver.tools)

Loading