When using SQL scripting languages instead of SQL queries, there's an option to output a message to the client. This is very useful for logging and debugging SQL scripts, but there's no service that supports it. I'd like to suggest a new node be added to the RunQuery Info node that contains the content of these messages, and I'd like to have the messages regardless of whether the service throws an exception or not.
Some resources to the features in question for the scripting languages I've used:
T-SQL - https://docs.microsoft.com/en-us/sql/t- ... ansact-sql
PL/SQL - https://docs.oracle.com/database/121/TTPLP/d_output.htm
SQL Script Messages
-
- Posts: 178
- Joined: August 31st, 2021, 11:37 am
- Contact:
-
- Posts: 329
- Joined: August 26th, 2021, 9:18 am
- Contact:
Re: SQL Script Messages
Task #10576 has been created to look into the possibility of adding this feature. This post will be updated when it has been completed.
word count: 24