FireDAC with multiple SQL

[DrShepard 0]

Hello!

I am trying to execute multiple SQL statements at once in an anonymous block of code. I am using FireDAC and Postgres database. When I set the parameters, I get an error on execution: 'Parameter 'p_val1' not found'

https://pastebin.com/dPRB8T3d

I tried TFDСommand and TFDScript objects, but it didn't help. What am I doing wrong?

Edited June 10, 2021 by DrShepard

[Dmitry Arefiev 101]

You can find several answers on top:

https://www.google.com/search?q=postgresql+anonymous+block+parameters