Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ml_qa_getcontentclass

Returns the message type (text or binary).

The content class as INTEGER.

The return value can be:

• 1  indicates that the message content is binary and should be read using the stored procedure ml_qa_getbinarycontent.

• 2  indicates that the message content is text and should be read using the stored procedure ml_qa_gettextcontent.

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

• Setting up SQL applications
• ml_qa_createmessage
• ml_qa_getmessage
• ml_qa_getbinarycontent
• ml_qa_gettextcontent

In the following example, a message is received and the content is output to the database console:

begin
    declare @msgid varchar(128);
    declare @contentclass integer;
    set @msgid = ml_qa_getmessage( 'myaddress' );
    set @contentclass = ml_qa_getcontentclass( @msgid );
    if @contentclass = 1 then
        message 'message  binary is ' || ml_qa_getbinarycontent( @msgid );
    elseif @contentclass = 2 then
        message 'message  text is ' || ml_qa_gettextcontent( @msgid );
    end if;
    commit;
end