Originally posted by stecal:
quote:
--------------------------------------------------------------------------------
Originally posted by Raminder
DDL commands are not allowed directly into a stored procedure.
--------------------------------------------------------------------------------



Really? Do you mean not at all, or only if you use something like execute_immediate, dbms_sql, or something along those lines?
What I meant was direct DDL sql. You can use dynamic sql, though.