Re: How can i lock an user from a package?

"Alvaro G?lvez" <bakanon_at_yahoo.com> wrote in message news:dce856b.0411301159.7bddae42_at_posting.google.com...
> Hi
> I need to lock an oracle user from inside a package, so i can't use
> ALTER instruction... If i do
>
> ALTER USER username ACCOUNT LOCK;
>
> it throws the following:
>
> PLS-00103: Encountered the symbol "ALTER" when expecting one of the
> following:
>
> begin declare exit for goto if loop mod null pragma raise
> return select update while

execute immediate 'alter user username account lock';

its not sql so it cant run it so must wrap it in execute immediate Received on Tue Nov 30 2004 - 14:18:02 CST