RETURNS TABLE from procedures

Follow

0

Chris Shortt

• December 02, 2021 08:45

Hello,

Would it be possible to return a table from a procedure without having to specify each column in the RETURNS () clause? I have a few use cases where that would make my life a lot easier.

Thanks.

Chris Shortt

• Comment actions Permalink

  Official comment

  

  Matthias Korn

  • December 07, 2021 12:14

  Hi Chris,

  thanks for submitting this feature request. Unfortunately, this would be hard to implement for us. Let me explain the reason: entities in the DV Platform are related in a dependency graph, which we need for our metadata. The return values of a procedure are also part of the metadata, they need to be checked for all objects depending on them. If the return values of a procedure are determined at runtime, it would be impossible to do all of our dependency checks. Therefore implementation of this feature request would be very hard.
  We still like the feature you requested, and will put it on our product management system, but unfortunately cannot implement it in the very near future.

  Best,
  Matthias

Please sign in to leave a comment.