Re: Alter Command In PL/SQL?

From: H. John C. Hopkins <john_nospam_at_hpe.ufl.edu>
Date: 1998/02/06
Message-ID: <6bfs2r$o5i@no-names.nerdc.ufl.edu>#1/1

Simply... no.

You can issue an ALTER statement (and other DDL/DML statements) via the DBMS_SQL and DBMS_DDL packages. Check your Oracle Docs, or better still, Feuerstein's PL/SQL book, for details.

-John

Stephen Darlington > wrote in message <6asd7c$fr1_at_romeo.logica.co.uk>...
>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
Received on Fri Feb 06 1998 - 00:00:00 CST