Problem with Queue

Problem with Queue

Postby __SB » Wed 05 Oct 2011 08:28

Good day, while working with dotConnect I had a glitch. I need to send a message to the queue, but the message type: AQ $ _JMS_BYTES_MESSAGE. My question is, as from C # to send the message of this type.

And here's the source code in which we are trying to send a message to the queue. But this is only an error ORA-30 625
Code: Select all
OracleConnection Connection = new OracleConnection(ConnectionString);
            OracleQueue oq = new OracleQueue("EXPORT_DATA",Connection);
                OracleObject obj = new OracleObject("SYS.AQ$_JMS_BYTES_MESSAGE", Connection);
            OracleParameterCollection OPC = new OracleParameterCollection();
                obj.ExecuteMethod(Connection, "set_string_property", OPC);
               OracleObject.ExecuteMethod(obj,Connection,"SYS.AQ$_JMS_BYTES_MESSAGE", "set_string_property", OPC);
               obj["msg_type"] = "POSLog";
Posts: 1
Joined: Wed 05 Oct 2011 07:58

Postby Shalex » Tue 11 Oct 2011 09:27

AQ$_JMS_BYTES_MESSAGE can not be used via the OracleObject class. We recommend you to use messages of some user-defined type (UDT) like the one from A Simple Example of Point-to-Point Messaging:
Devart Team
Posts: 7475
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle