error adding a column

[programmer]

The code is

DECLARE
message VARCHAR(30);
BEGIN
message := 'Welcome to the Oracle World';
EXECUTE IMMEDIATE 'alter table emp add Desc_ription varchar(30)';

UPDATE emp
SET desc_ription = message;

COMMIT;
END;

I get the following error.

ORA-06550: line 6, column 26:
PLS-00417: unable to resolve "DESC_RIPTION" as a column
ORA-06550: line 6, column 1:
PL/SQL: SQL Statement ignored

[thanigai]

Hi why don't you continue with the same thread....which is just below this for the same issue by YOU PROGRAMMER.
Donot tell me to be quite like you said in that thread.
People like us really awaiting for the help keeping fingers crossed are getting affected because of this kind of duplicating thread.
I am sorry if it affend you.
Thanks.
Thanigaivasan.

[TimHall]

Check your syntax manually and you'll see:

EXECUTE IMMEDIATE 'alter table emp add Desc_ription varchar(30)';

should be:

EXECUTE IMMEDIATE 'alter table emp add (Desc_ription varchar(30))';

Cheers