Re: WebDB- Removing Sites...How

Hey Jason,

Got another EASY question for ya...I need to retrieve the value of the LOGGED IN user into a WebDB component Form. Only way that I can see doing it is to create a stored procedure and call the procedure via a WebDB form...in the procedure, I need to retrieve the user's login value to a variable, but "select user in v_user from dual" doesn't retrieve the right value...it retrieves <SCHEMA>_public, EVEN THOUGH the user has logged in and validated against the database...HOW can I best do this??? I've been racking my brains on this for some time...as a former Oracle Employee of 4 years, I thought I could beat THIS easy problem!

Lance White
winker11_at_hotmail.com

Jason Pepper wrote:

> Connect as a DBA to sqlplus
>
> drop [sitename]_public cascade;
> drop [sitename]_admin cascade;
> drop [sitename] cascade;
>
> delete wwv_modules$
> where upper(name) = upper([sitename])
> and type_id = 40;
>
> Where [sitename] is the name you use for connecting via your browser
> --
> regards
>
> Jason
> ----------------------------------------------------------------------------
> Jason Pepper
> Snr Product Manager Enterprise Internet Tools
> Oracle Corporation
>
> <nummer2_at_my-deja.com> wrote in message news:7sqhac$5lo$1_at_nnrp1.deja.com...
> > Dear John
> > I have the same problem
> > Did you ever get any answers?
> >
> > Nummer2
> >
> > In article <37ce8a93.3225067_at_news.news-ituk.to>,
> > See Message body for real address wrote:
> > > In my learning to use WebDB I have created several sites that I now
> > want to get
> > > rid of...the Site Manager indicates that it can be used to
> > administer, modify or
> > > delete sites, but I cannot find out how to delete a site....What am I
> > missing ?
> > >
> > > Thanks,
> > > John Greco
> > >
> > > ( Site is in Oracle 7.3.4 database on Netware 4.11 )
> > >
> > > -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---
> > -------
> > > http://www.newsfeeds.com The Largest Usenet Servers in the
> > World!
> > > ------== Over 73,000 Newsgroups - Including Dedicated Binaries
> > Servers ==-----
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Tue Sep 28 1999 - 21:14:11 CEST