Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Configure DAD to call stored procedure from Internet Explorer

Re: Configure DAD to call stored procedure from Internet Explorer

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 28 Nov 2003 15:43:08 +0100
Message-ID: <bq7mu0$a7o$1@news.BelWue.DE>

   Hai Ly Hoang [MT00KSTN] wrote:
> After installing Oracle 9.01 Enterprise Sever (Windows OS), I created an
> user named xuanthu and created some table and a procedure 'Helo' (by CREATE
> TABLE....). Now i want to call Helo from Internet Explorer.
> I open Pl/SQL gateway and create an DAD with the following configuration:
> (Oracle server is running on my computer)
>
> Database Access Descriptor Name: myDAD
> UserName:xuanthu
> Password:****
> ConnectString: localhost:1521:tinysid
>
> (the following is default options given by DAD wizard)
> Authentication Mod: Single-signon
> Session Cookie: (blank)
> Package/Session Management Type: Stateless
> Enable Connection Pooling? yes
> Document Table : XuanThu .wwdoc_document
> Document Access Path: docs
> Document Access Procedure: XuanThu .wwdoc_process.process_download
> Extensions to be uploaded as Long Raw: blank
> Path Alias : url
> Path Alias Procedure : XuanThu .wwpth_api_alias.process_download
>
> In internet explorer, i call: http://localhost/pls/mydad/helo . I just
> received this message:
> "Service Temporarily Unavailable
> The server is temporarily unable to service your request due to maintenance
> downtime or capacity problems. Please try again later. "
>
> File Oracle9i\Apache\Apache\logs\error_log show that:
> [Fri Nov 28 20:52:59 2003] [error] mod_plsql: /pls/mydad/helo HTTP-503
> ORA-12560 <B>Proxy log On failed.</B><BR>Please verify that you have
> specified correct connectivity information i.e. username, password &
> connect-string in the DAD
>
> WHAT'S WRONG ? Can anyone help me ?
>
> (Oh, I'm sure that my Database SID (declared in ConnecString is TinySID).
> But if i want to check it again (ie. get the SID of the database), how to do
> it (by wizard or SQL command) ?
>
> Thanks alot and alot !
>
>
>

Single-Signon is for Oracle Portal, which you don't have. Try using Basic authentification.

HTH Holger Received on Fri Nov 28 2003 - 08:43:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US