Re: [WEB PL/SQL]How to logoff from Oracle Database thru. OAS?

Two things here: when using a non-named connection (Database Access Descriptor, or DAD), the user is prompted for a valid (Oracle Database) uid and password.
OAS does not use persistent connections (Apache, aka iAS, can), so will re-use this info time and again.

Bottom line: you're not connected, so why logoff? In detail: there's a (session) cookie set - remove it, and you're "logged off", that is, you will be prompted for the uid/password again. Again, you are not actually logged on.

Patrick Lo wrote:

> Thanks for you reply. If so, how could I pretend a logout procedure?
>
> Thanks.
>
> Kevin Brand wrote:
>
> > If you are using the PL/SQL toolkit ( the PL/sql cartridge ) within OWAS,
> > the end user at the browser level never actually makes a connection to the
> > database. The application server invokes an instance of the cartridge to
> > handle a request. This causes a DAD to connect to the database to fire the
> > appropriate PL/SQL code. All the connections are managed at the OWAS level.
> >
> > -Kevin
> >
> > "Patrick Lo" <cylo_at_vtc.edu.hk> wrote in message
> > news:3A30A52E.35516B16_at_vtc.edu.hk...
> > > Hi,
> > >
> > > I am developing an application using Web PL/SQL on OAS 4.0.8.1 with
> > > Oracle 8i (8.1.5). I used Basic Oracle as the basic authentication for
> > > the user to logon to Oracle database but I could not find any package
> > > function bundled with OAS 4.0.8.1 to logoff the user from the Oracle
> > > database.
> > >
> > > Could anyone tell me what kind of package function I could use in order
> > > to logoff the user from Oracle Database?
> > >
> > > Thanks.
> > >
> > > --
> > > Patrick
> > >
> > >
>
> --
> Patrick

--
Gtrz,

Frank van Bortel