How to add a column in table via stored procedure?
You can't embed DDL in a stored procedure like this.

Either use execute immediate and your DDL statement passed to it as a string, or, better, remove the stored procedure entirely an execute the DDL directly.