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); }