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: Hai Ly Hoang [MT00KSTN] <Mail_at_Home.net>
Date: Fri, 28 Nov 2003 22:26:30 +0700
Message-ID: <bq7peh$1vfdte$1@ID-193509.news.uni-berlin.de>


Dear Holger,
I changed the authentication mode to basic (and all other modes). But the result is the same: "Service Temporarily Unavailable". Do you have any other suggestions?
Thanks.

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:bq7mu0$a7o$1_at_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 - 09:26:30 CST

Original text of this message

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