Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter table statment in pl/sql.

Re: alter table statment in pl/sql.

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/07
Message-ID: <ifl%4.237686$Tn4.2151145@news1.rdc2.pa.home.com>#1/1

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...

> 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.
>
Received on Wed Jun 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US