tomsee7 wrote:

>
> Is that right? Maybe there's a misunderstanding to my question?

Sure there was ;-)

> My knowledge is limited but I thought that sending dynamic sql (e.g 'select a,b,c from d where e=?' as part of a prepare statement caused a single preparation on the server.
>
> The client app can then just send the ? param each time thereby giving good performance and a midway option between passing dynamic sql repeatedly and calling stored procedures.

You're correct.


Dmitry