Does anyone know how to CREATE a USER with ROLES within a procedure? I'm
using a web form to Create users, but when I complile the code Oracle gets
confused with the 'CREATE OR REPLACE' in the Procedure.
Richard Norris
Printable View
Does anyone know how to CREATE a USER with ROLES within a procedure? I'm
using a web form to Create users, but when I complile the code Oracle gets
confused with the 'CREATE OR REPLACE' in the Procedure.
Richard Norris
Use dynamic SQL.
Or DBMS_SQL package.