1007: else
1008: seededKeyPrefix := null;
1009: end if;
1010: loop
1011: select ame_rule_keys_s.nextval into ruleKeyId from dual;
1012: newRuleKey := databaseId||':'||ruleKeyId;
1013: if seededKeyPrefix is not null then
1014: newRuleKey1 := seededKeyPrefix||'-' || newRuleKey;
1015: else
1827: ruleId := -1;
1828: end if;
1829: end if;
1830: else
1831: select ame_rules_s.nextval into ruleId from dual;
1832: end if;
1833: else
1834: ruleId := ruleIdIn;
1835: select count(*)