"Martijn Tonies" <m.tonies@...> wrote:

>
> The problem is "how to know if you should use SELECT or EXECUTE
> if you don't know anything about the procedure".

This is not a client developer's problem. The engine returns this info since
1980s. The problem is how the engine should determine this to report
correctly. There's no answer currently. There can be an answer if we can
live with EXECUTE and SELECT returning different results, or with EXECUTE
and CALL returning different results, or with EXECUTE and EXECUTE1 (knowing
about user-declared procedure invokation type) returning different results.
There's no other option, AFAIU.


Dmitry