Re: Comments on tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 28 Sep 2000 06:25:18 +0200
Message-ID: <970120304.14621.0.pluto.d4ee154e@news.demon.nl>

The comment statement is DDL and hence can't be used in PL/SQL directly. You'll need the dbms_sql package to apply it.

Hth,

Sybrand Bakker, Oracle DBA

<keenej_at_my-deja.com> wrote in message news:8qu10k$s22$1_at_nnrp1.deja.com...
> Does anyone know how to add a comment to a table from an Oracle 7.3
> stored procedure?
>
> I tried using: COMMENT ON TABLE myTable IS 'myComment';
>
> However, I get the follow error message:
>
> PLS-00103: Encountered the symbol "ON" when expecting one of the
> following: := . ( @ % ;
>
> Any help would be most appreciated.
>
> Thanks...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 27 2000 - 23:25:18 CDT