Returns the message content of a text message.

Parameters

Return value

The text content as LONG VARCHAR.

If the message has binary content rather than text content, this stored procedure returns null.

Remarks

You can read this content after a message is received and until a rollback or commit occurs; after that you cannot read it.

See also

• Setting up SQL applications
• ml_qa_settextcontent
• ml_qa_createmessage
• ml_qa_getmessage
• ml_qa_getcontentclass

Example

In the following example, the content of a message is output to the database server messages window:

begin
    declare @msgid varchar(128);
    declare @content long binary;
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @content = ml_qa_gettextcontent( @msgid );
    message 'message content: ' || @content ;
    commit;
end