COMMENT call gives PLS-00103
From: <sysmansm_at_my-deja.com>
Date: 2000/05/03
Message-ID: <8eqcce$6l2$1_at_nnrp1.deja.com>#1/1
Date: 2000/05/03
Message-ID: <8eqcce$6l2$1_at_nnrp1.deja.com>#1/1
[Quoted] I am trying to write a comment into the data dictionary for a given column. I believe the syntax is OK.
My PLSQL code fragment looks like:
begin
...
COMMENT ON COLUMN schema.tablename.column_name IS 'some text in here';
...
end;
This fails with Error Text PLS-00103: Encountered the symbol ON when expecting one of :=.(_at_%;
This code works fine from the SQL> prompt.
I would appreciate any clues on why this fails to compile.
Cheers Grant
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed May 03 2000 - 00:00:00 CEST