Page 1 of 1

SQL Script Messages

Posted: June 24th, 2022, 1:29 pm
by JefferyD
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

Re: SQL Script Messages

Posted: June 29th, 2022, 8:57 am
by SteveCap
Task #10576 has been created to look into the possibility of adding this feature. This post will be updated when it has been completed.