protected virtual void Generate(
OracleDropUserOperation operation,
IModel model,
MigrationCommandListBuilder builder)
{
builder
.Append(
$@"BEGIN
FOR v_cur IN (SELECT sid, serial# FROM v$session WHERE username = '******') LOOP
EXECUTE IMMEDIATE ('ALTER SYSTEM KILL SESSION ''' || v_cur.sid || ',' || v_cur.serial# || ''' IMMEDIATE');
END LOOP;
EXECUTE IMMEDIATE 'DROP USER {operation.UserName} CASCADE';
END;")
.EndCommand(suppressTransaction: true);
}
protected virtual void Generate(
[NotNull] OracleDropUserOperation operation,
[CanBeNull] IModel model,
[NotNull] MigrationCommandListBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
builder
.Append(
$@"BEGIN
FOR v_cur IN (SELECT sid, serial# FROM v$session WHERE username = '******') LOOP
EXECUTE IMMEDIATE ('ALTER SYSTEM KILL SESSION ''' || v_cur.sid || ',' || v_cur.serial# || ''' IMMEDIATE');
END LOOP;
EXECUTE IMMEDIATE 'DROP USER {operation.UserName} CASCADE';
--EXCEPTION
-- WHEN OTHERS THEN
-- IF SQLCODE != -01918 THEN
-- RAISE;
-- END IF;
END;")
.EndCommand(suppressTransaction: true);
}
