Examples

Example 1: 3

begin;
3EXECUTE FUNCTION MQReceiveClob();
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table(clob_col) VALUES(MQReceiveClob());

This example receives the content of the message as a CLOB at 3the head of the queue into the CLOB with the following parameters: 3

3
• service_name: default service name
3
• policy_name: default policy name
3
• correl_id: none

Example 2: 3

begin;
3EXECUTE FUNCTION MQReceiveClob('MYSERVICE');
3rollback;

Alternatively, the following syntax can be used: 3

insert into my_order_table(clob_col)
3 VALUES(MQReceiveClob('MYSERVICE'));

This example receives the content of the message as a CLOB at 3the head of the queue into the CLOB with the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: default policy name
3
• correl_id: none

Example 3: 3

begin;
3EXECUTE FUNCTION MQReceiveClob('MYSERVICE', 'MYPOLICY');
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table(clob_col)
3 VALUES(MQReceiveClob('MYSERVICE', 'MYPOLICY'));

This example receives the content of the message as a CLOB at 3the head of the queue into the CLOB with the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: "MYPOLICY"
3
• correl_id: none

Example 4: 3

begin;
3EXECUTE FUNCTION MQReceiveClob('MYSERVICE', 'MYPOLICY', 'TESTS');
3commit;

Alternatively, the following syntax can be used: 3

insert into my_order_table(clob_col)
3 VALUES(MQReceiveClob('MYSERVICE', 'MYPOLICY', 'TESTS'));

This example receives the content of the message as a CLOB at 3the head of the queue into the CLOB with the following parameters: 3

3
• service_name: "MYSERVICE"
3
• policy_name: "MYPOLICY"
3
• correl_id: "TESTS"