SQL Script Messages

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
JefferyD
Posts: 178
Joined: August 31st, 2021, 11:37 am
Contact:

SQL Script Messages

Unread post 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
word count: 116

Tags:
SteveCap
Posts: 329
Joined: August 26th, 2021, 9:18 am
Contact:

Re: SQL Script Messages

Unread post 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.
word count: 24
Post Reply