Re: Alter Command In PL/SQL?

Hi,

It depends on which alter command you want to execute. Certain commands like alter session .... are available thru DBMS_SESSION package. A number of other commands like ALTER TABLE can be executed thru DBMS_SQL package.

I hope this helps,
Ajit

In article <6asd7c$fr1_at_romeo.logica.co.uk>,   "Stephen Darlington" <Stephen_Darlington At Earthling Dot Net> wrote:
>
> I'm sure that this is an easy question for all you gurus...
>
> Is there a way to use the ALTER command in a PL/SQL stored procedure? Is
> ALTER really a SQL*Plus command, or am I doing something wrong?
>
> We're using Oracle Workgroup Server 7.3, if that makes any difference.
>
> Cheers,
> --> Steve
> ----------------------------------------------------------------------------
> Stephen Darlington (public.logica.com/~darlings/)
> "I blame sex and paper for most of our problems"
> Don't believe a single word I say -- these are my words, not Logica's
> ----------------------------------------------------------------------------

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet