Execute any sql from another session #oracle #sql

Execute any sql from another session.md

declare

nUid number;
vSqltext varchar2(100) := 'alter user <username> profile personal';
iCursor integer;
iResult integer;

begin
select user_id into nUid from all_users where username like 'SYS';
iCursor:=sys.dbms_sys_sql.open_cursor();
sys.dbms_sys_sql.parse_as_user(iCursor,vSqltext,dbms_sql.native,nUid);
iResult := sys.dbms_sys_sql.execute(iCursor);
sys.dbms_sys_sql.close_cursor(iCursor);
end ;
/