Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table statment in pl/sql.
sys.dbms_utiltity.exec_ddl_statement('your sql with no ;');
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "ken" <kckcabc_at_email.com> wrote in message news:393BE60A.A71D46F9_at_email.com...Received on Wed Jun 07 2000 - 00:00:00 CDT
> hi there,
>
> I put in this statement in my pl/sql procedure: alter table modify
> column A null ", Oracle returns this error msg.:
>
> (1):PLS-00103: Encountered the symbol "ALTER" when expecting one of the
> following:
> (1): begin declare end exception exit for goto if loop mod null
>
> can someone one there help?
>
> Thanks in advance.
> gojo.
>