MSCEWI1100
Multiple result sets are returned in temporary tables
Last updated
Multiple result sets are returned in temporary tables
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
Snowflake Scripting procedures only allow one result set to be returned per procedure.
To replicate Teradata behavior, when there are two or more result sets to return, they are stored in temporary tables. The Snowflake Scripting procedure will return an array containing the name of the temporary tables.
To obtain the result sets, it is necessary to run a SELECT query with the name of the temporary tables returned by the procedure.
As much as possible, avoid procedures that return multiple result sets; instead, make them single-responsibility for more direct results.
For more support, you can email us at support@mobilize.net or . If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.