Calling stored procedure with table-valued parameter

Many many thanks for your endurance and effort to find a solution and I have to say, thats a smart one - creative! :slight_smile:
Yet I also have to admit, that I don’t really get warm with the direction this is heading towards :-/

I hope I am not offending anyone, its just…
I really start wondering! All I want is simply to call a given stored procedure, it cannot be all that hard can it. I have seen code samples in C# and C++ doing exactly this and its like three lines of code (without the need of creating and deleting temporary tables, on the fly creating and deleting mock stored procedures and other cumbersome hacks resulting in another A4 page of ugly, cumbersome and unmaintainable code from hell - simply to call a stored procedure using a table valued parameter which was first introduced 8 years ago). I feel a little frustrated that simply calling a stored procedure in delphi requires half a day of elaboration, while it takes minutes to figure it out in other mainstream languages…

I start to think about whether its time to move to another technology stack in the long run if its that hard to perform a really basic and standard operation like invoking a stored procedure - FROM WITHIN A DATABASE FRAMEWORK in delphi…