Einzelnen Beitrag anzeigen

lxo

Registriert seit: 30. Nov 2017
288 Beiträge
 
Delphi 12 Athens
 
#5

AW: Firebird - context limit

  Alt 24. Nov 2023, 09:28
nö, das ist der stand von 2006, da gab es noch gar kein execute block
Siehe Kommentare, ganz unten.

Zitat:
The limit applies to the BLR (byte code) where every table reference is encoded with a single-byte number. Thus the limit is static and does not affect how many times the procedure is executed.


BLR is per-procedure, so one procedure call cannot have more than 255 table references, but many different calls do not share this limit.
EXECUTE PROCEDURE does not create a context, so EXECUTE BLOCK may have lots of them. However, SELECT FROM PROCEDURE creates a context, so your EXECUTE BLOCK cannot have more than 255 SELECTs from procedures.
  Mit Zitat antworten Zitat