can't we use ddl statements in procedures
581587Jun 6 2007 — edited Jun 6 2007i am using an oracle database.
i have written a procedure for altering the table to add new columns.
But when i invoke my procedure from another anonymous block it says the object is invalid.
can anybody help me with the steps to alter table using a procedure which has to be invoked by another program.
is there any other way of doing it.
Thank u,
ss