create or replace procedure USERDROP2 (user_no in varchar2)
as
user_ac VARCHAR2(10);
run_statement VARCHAR2(500);
BEGIN
user_ac:=user_no;
run_statement := 'DROP USER '||user_ac||' CASCADE;';
dbms_output.put_line(run_statement);
dbms_utility.exec_ddl_statement('DROP USER '||user_ac||' CASCADE;');
END USERDROP2;
SQL> EXEC USERDROP2('SC5506');
begin USERDROP2('SC5506'); end;
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 574
ORA-06512: at "SYS.USERDROP2", line 9
ORA-06512: at line 2