Re: When is a stored procedure needed?

From: joel garry <>
Date: Mon, 4 May 2009 15:03:46 -0700 (PDT)
Message-ID: <>

On May 3, 12:22 am, William Robertson <> wrote:
> On May 2, 6:39 am, Phper <> wrote:
> > Is it suggestible to write a stored procedure for registering or sign-
> > in?
> Obviously a database connection will need to be established in order
> for any procedure stored in the database to be accessible to the user,
> so you would have to connect first to some generic account in order to
> call it. Then there is the problem that PL/SQL can't reconnect you as
> another user, although it could issue an ALTER SESSION to change the
> default schema, or enable some roles, or change some global variables
> you might use to identify application users. It all depends on what
> you are trying to do, how you define user accounts, how you want the
> login/register process to work, what the front end application is
> written in etc, hence the replies above.

I have come to believe this person is using this and other volunteer resources to collect information and then post it as his own for profit. Check posting history. Please feed the troll garbage.


-- is bogus.
Received on Mon May 04 2009 - 17:03:46 CDT

Original text of this message