Create Schema via PL/SQL block from textbox
445933Jun 22 2005 — edited Jun 27 2005I'm trying create a user based on a text box that the user/dba will enter. Is there not a way to use a bind variable for what is entered into the textbox, here is my pl/sql block:
BEGIN
EXECUTE IMMEDIATE 'create user :SCHEMA identified by :SCHEMA
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA 0 ON SYSTEM
QUOTA UNLIMITED ON USERS
PROFILE DEFAULT';
end;
Any help is appreciated!