Если в максимально упрощенном варианте. Таблица.
CREATE TABLE APP_TEXTS ( TEXT_ID INTEGER NOT NULL, TEXT BLOB SUB_TYPE 1 SEGMENT SIZE 254 NOT NULL, DATE_CREATION TIMESTAMP NOT NULL, DATE_LASTVERSION TIMESTAMP NOT NULL, VERSION_NUMBER INTEGER NOT NULL, TEXT_NAME VARCHAR(82) DEFAULT 'unknown' NOT NULL, SUBVERSION INTEGER, TEXT_TYPE INTEGER NOT NULL, TEXT_PID INTEGER NOT NULL, TEXT_ORDER INTEGER, USER_ID INTEGER ); триггеров нет. Вообще ничего кроме таблицы нет. Таблица вообще пустая. Такой вот блок EXECUTE BLOCK AS BEGIN UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=0 WHERE TEXT_ID=100102; UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=1 WHERE TEXT_ID=100042; UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=2 WHERE TEXT_ID=100061; UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=3 WHERE TEXT_ID=100038; UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=4 WHERE TEXT_ID=67; UPDATE APP_TEXTS SET TEXT_PID=67, TEXT_ORDER=5 WHERE TEXT_ID=68; UPDATE APP_TEXTS SET TEXT_PID=68, TEXT_ORDER=6 WHERE TEXT_ID=19; UPDATE APP_TEXTS SET TEXT_PID=67, TEXT_ORDER=7 WHERE TEXT_ID=69; UPDATE APP_TEXTS SET TEXT_PID=69, TEXT_ORDER=8 WHERE TEXT_ID=21; UPDATE APP_TEXTS SET TEXT_PID=69, TEXT_ORDER=9 WHERE TEXT_ID=17; UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=10 WHERE TEXT_ID=100107; UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=11 WHERE TEXT_ID=100017; UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=12 WHERE TEXT_ID=100018; UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=13 WHERE TEXT_ID=100019; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=14 WHERE TEXT_ID=100073; UPDATE APP_TEXTS SET TEXT_PID=100073, TEXT_ORDER=15 WHERE TEXT_ID=100074; UPDATE APP_TEXTS SET TEXT_PID=100074, TEXT_ORDER=16 WHERE TEXT_ID=100075; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=17 WHERE TEXT_ID=35; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=18 WHERE TEXT_ID=64; UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=19 WHERE TEXT_ID=65; UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=20 WHERE TEXT_ID=62; UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=21 WHERE TEXT_ID=63; UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=22 WHERE TEXT_ID=100071; UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=23 WHERE TEXT_ID=100072; UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=24 WHERE TEXT_ID=70; UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=25 WHERE TEXT_ID=71; UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=26 WHERE TEXT_ID=27; UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=27 WHERE TEXT_ID=29; UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=28 WHERE TEXT_ID=33; UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=29 WHERE TEXT_ID=100078; UPDATE APP_TEXTS SET TEXT_PID=100078, TEXT_ORDER=30 WHERE TEXT_ID=100079; UPDATE APP_TEXTS SET TEXT_PID=100078, TEXT_ORDER=31 WHERE TEXT_ID=100080; UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=32 WHERE TEXT_ID=100085; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=33 WHERE TEXT_ID=66; UPDATE APP_TEXTS SET TEXT_PID=66, TEXT_ORDER=34 WHERE TEXT_ID=13; UPDATE APP_TEXTS SET TEXT_PID=66, TEXT_ORDER=35 WHERE TEXT_ID=15; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=36 WHERE TEXT_ID=72; UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=37 WHERE TEXT_ID=100001; UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=38 WHERE TEXT_ID=100002; UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=39 WHERE TEXT_ID=43; UPDATE APP_TEXTS SET TEXT_PID=43, TEXT_ORDER=40 WHERE TEXT_ID=100012; UPDATE APP_TEXTS SET TEXT_PID=43, TEXT_ORDER=41 WHERE TEXT_ID=100044; UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=42 WHERE TEXT_ID=100064; UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=43 WHERE TEXT_ID=100065; UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=44 WHERE TEXT_ID=100066; UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=45 WHERE TEXT_ID=100067; UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=46 WHERE TEXT_ID=100068; UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=47 WHERE TEXT_ID=100069; UPDATE APP_TEXTS SET TEXT_PID=100069, TEXT_ORDER=48 WHERE TEXT_ID=100070; UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=49 WHERE TEXT_ID=100013; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=50 WHERE TEXT_ID=73; UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=51 WHERE TEXT_ID=94; UPDATE APP_TEXTS SET TEXT_PID=94, TEXT_ORDER=52 WHERE TEXT_ID=95; UPDATE APP_TEXTS SET TEXT_PID=95, TEXT_ORDER=53 WHERE TEXT_ID=96; UPDATE APP_TEXTS SET TEXT_PID=96, TEXT_ORDER=54 WHERE TEXT_ID=97; UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=55 WHERE TEXT_ID=45; UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=56 WHERE TEXT_ID=100009; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=57 WHERE TEXT_ID=74; UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=58 WHERE TEXT_ID=75; UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=59 WHERE TEXT_ID=76; UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=60 WHERE TEXT_ID=23; UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=61 WHERE TEXT_ID=25; UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=62 WHERE TEXT_ID=31; UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=63 WHERE TEXT_ID=37; UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=64 WHERE TEXT_ID=39; UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=65 WHERE TEXT_ID=100104; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=66 WHERE TEXT_ID=77; UPDATE APP_TEXTS SET TEXT_PID=77, TEXT_ORDER=67 WHERE TEXT_ID=78; UPDATE APP_TEXTS SET TEXT_PID=78, TEXT_ORDER=68 WHERE TEXT_ID=100076; UPDATE APP_TEXTS SET TEXT_PID=78, TEXT_ORDER=69 WHERE TEXT_ID=79; UPDATE APP_TEXTS SET TEXT_PID=77, TEXT_ORDER=70 WHERE TEXT_ID=80; UPDATE APP_TEXTS SET TEXT_PID=80, TEXT_ORDER=71 WHERE TEXT_ID=81; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=72 WHERE TEXT_ID=82; UPDATE APP_TEXTS SET TEXT_PID=82, TEXT_ORDER=73 WHERE TEXT_ID=83; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=74 WHERE TEXT_ID=84; UPDATE APP_TEXTS SET TEXT_PID=84, TEXT_ORDER=75 WHERE TEXT_ID=87; UPDATE APP_TEXTS SET TEXT_PID=87, TEXT_ORDER=76 WHERE TEXT_ID=85; UPDATE APP_TEXTS SET TEXT_PID=87, TEXT_ORDER=77 WHERE TEXT_ID=86; UPDATE APP_TEXTS SET TEXT_PID=84, TEXT_ORDER=78 WHERE TEXT_ID=88; UPDATE APP_TEXTS SET TEXT_PID=88, TEXT_ORDER=79 WHERE TEXT_ID=89; UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=80 WHERE TEXT_ID=90; UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=81 WHERE TEXT_ID=91; UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=82 WHERE TEXT_ID=93; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=83 WHERE TEXT_ID=98; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=84 WHERE TEXT_ID=99; UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=85 WHERE TEXT_ID=100; UPDATE APP_TEXTS SET TEXT_PID=100, TEXT_ORDER=86 WHERE TEXT_ID=101; UPDATE APP_TEXTS SET TEXT_PID=100, TEXT_ORDER=87 WHERE TEXT_ID=102; UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=88 WHERE TEXT_ID=103; UPDATE APP_TEXTS SET TEXT_PID=103, TEXT_ORDER=89 WHERE TEXT_ID=104; UPDATE APP_TEXTS SET TEXT_PID=103, TEXT_ORDER=90 WHERE TEXT_ID=105; UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=91 WHERE TEXT_ID=100106; UPDATE APP_TEXTS SET TEXT_PID=100106, TEXT_ORDER=92 WHERE TEXT_ID=11; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=93 WHERE TEXT_ID=107; UPDATE APP_TEXTS SET TEXT_PID=107, TEXT_ORDER=94 WHERE TEXT_ID=108; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=95 WHERE TEXT_ID=100063; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=96 WHERE TEXT_ID=100082; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=97 WHERE TEXT_ID=100084; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=98 WHERE TEXT_ID=100086; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=99 WHERE TEXT_ID=100060; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=100 WHERE TEXT_ID=100052; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=101 WHERE TEXT_ID=100058; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=102 WHERE TEXT_ID=100048; UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=103 WHERE TEXT_ID=100051; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=104 WHERE TEXT_ID=100087; UPDATE APP_TEXTS SET TEXT_PID=100087, TEXT_ORDER=105 WHERE TEXT_ID=100088; UPDATE APP_TEXTS SET TEXT_PID=100087, TEXT_ORDER=106 WHERE TEXT_ID=100081; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=107 WHERE TEXT_ID=100089; UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=108 WHERE TEXT_ID=100090; UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=109 WHERE TEXT_ID=100083; UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=110 WHERE TEXT_ID=100091; UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=111 WHERE TEXT_ID=100092; UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=112 WHERE TEXT_ID=100093; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=113 WHERE TEXT_ID=100094; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=114 WHERE TEXT_ID=100035; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=115 WHERE TEXT_ID=100030; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=116 WHERE TEXT_ID=100028; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=117 WHERE TEXT_ID=100045; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=118 WHERE TEXT_ID=100006; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=119 WHERE TEXT_ID=100008; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=120 WHERE TEXT_ID=100039; UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=121 WHERE TEXT_ID=100054; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=122 WHERE TEXT_ID=100095; UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=123 WHERE TEXT_ID=100004; UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=124 WHERE TEXT_ID=100005; UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=125 WHERE TEXT_ID=100056; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=126 WHERE TEXT_ID=100096; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=127 WHERE TEXT_ID=100016; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=128 WHERE TEXT_ID=100023; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=129 WHERE TEXT_ID=100024; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=130 WHERE TEXT_ID=100041; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=131 WHERE TEXT_ID=100043; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=132 WHERE TEXT_ID=100053; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=133 WHERE TEXT_ID=100050; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=134 WHERE TEXT_ID=100046; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=135 WHERE TEXT_ID=100049; UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=136 WHERE TEXT_ID=100059; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=137 WHERE TEXT_ID=100099; UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=138 WHERE TEXT_ID=100021; UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=139 WHERE TEXT_ID=100037; UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=140 WHERE TEXT_ID=100007; UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=141 WHERE TEXT_ID=100047; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=142 WHERE TEXT_ID=100100; UPDATE APP_TEXTS SET TEXT_PID=100100, TEXT_ORDER=143 WHERE TEXT_ID=100036; UPDATE APP_TEXTS SET TEXT_PID=100100, TEXT_ORDER=144 WHERE TEXT_ID=100040; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=145 WHERE TEXT_ID=100103; UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=146 WHERE TEXT_ID=100010; UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=147 WHERE TEXT_ID=100011; UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=148 WHERE TEXT_ID=100027; UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=149 WHERE TEXT_ID=100015; UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=150 WHERE TEXT_ID=100101; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=151 WHERE TEXT_ID=100029; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=152 WHERE TEXT_ID=100034; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=153 WHERE TEXT_ID=100032; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=154 WHERE TEXT_ID=100026; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=155 WHERE TEXT_ID=100014; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=156 WHERE TEXT_ID=100020; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=157 WHERE TEXT_ID=100033; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=158 WHERE TEXT_ID=100031; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=159 WHERE TEXT_ID=100025; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=160 WHERE TEXT_ID=100055; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=161 WHERE TEXT_ID=100062; UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=162 WHERE TEXT_ID=100022; END размер блока - 11729 байт, т.е. далеко до 64 Кб. Количество операторов - 163. Получаем ошибку invalid request BLR at offset 6420. Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255. Если уменшить количество операторов до 127 - т.е. до половины 255, то такой блок выполняется. --~--~---------~--~----~------------~-------~--~----~ -~----------~----~----~----~------~----~------~--~---