SQL Script Messages
Posted: June 24th, 2022, 1:29 pm
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
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