Recent content by ajeeth

  1. A

    How do I insert CLOB into LOB attribute of a TOracleQueue.Payload

    The OCI-21710 error occurs at myMsg2 := myMsg.Reference.Pin(poAny, plNone); -- Regards Ajeeth
  2. A

    How do I insert CLOB into LOB attribute of a TOracleQueue.Payload

    Im trying to enqueue a text message (size greater than 4000 ) into an Oracle Queue of message type AQ$_JMS_TEXT_MESSAGE. As per Oracle documentation, I must insert the message into the TEXT_LOB field of the object if size is greater than 4000. I have tried using the following Delphi code: var...
  3. A

    Conditional dequeuing of AQMessages from Topic causes EOracleError

    Yes the problem is reproducable and happens only when I try to dequeue with a condition. Dequeuing without using conditions seems to work perfectly. Regards Ajeeth
  4. A

    Conditional dequeuing of AQMessages from Topic causes EOracleError

    Using DOA to conditionally dequeue JMS Text messages from Oracle AQ caused the following error Project DOASub.exe raised exception class EOracleError with message 'ORA-01002: fetch out of sequence ORA-06512: at "SYS.DBMS_AQ", line 333 ORA-06512: at line 10 ' The condition Im using is...
  5. A

    Enqueue JMS Message

    I figured out how to do it. Thanks anyway
  6. A

    Enqueue JMS Message

    I have successfully used the QueueDemo sample to enqueue and dequeue simple messages. But I would like to know how to create messages of type sys.AQ$_JMS_TEXT_MESSAGE FYI sys.AQ$_JMS_TEXT_MESSAGE attributes:- HEADER (sys.AQ$_JMS_HEADER) TEXT_LEN (Integer) TEXT_VC (VARCHAR2)...
  7. A

    Enqueue JMS Message

    How can I enqueue a message of type sys.AQ$_JMS_TEXT_MESSAGE using DOA. How can I create the message properly so that other standard JMS client can dequeue it. To do this the JMS header fields(sys.AQ$_JMS_HEADER) have to be set properly. How do I do that using DOA? Thanx
See more
Back
Top