Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the message content of a text message.
The text content as LONG VARCHAR.
If the message has binary content rather than text content, this stored procedure returns null.
You can read this content after a message is received and until a rollback or commit occurs; after that you cannot read it.
In the following example, the content of a message is output to the database server messages window:
declare @msgid varchar(128);
declare @content long binary;
set @msgid = ml_qa_getmessage( 'myaddress' );
set @content = ml_qa_gettextcontent( @msgid );
message 'message content: ' || @content ;