If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Yes, but you introduce a security problem by encoding the password in a file - which is no big deal if you require the user to change password on first login, but may be a big deal if everyone knows what the initial password is.

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?