0 Replies Latest reply on Jun 11, 2002 3:05 PM by 273604

    Advanced Queueing (Oracle 8i) & VB6 ORA-25215

    273604
      Hi all.
      I am trying to dequeue a queue I created in Oracle 8i using VB6 & OO4O, however when I call Q.Dequeue I get the error ORA-25215 'user_data type and queue type do not match'.

      Does anyone have any ideas ??


      I am new to Oracle & queues so I appologise for any stupid mistakes.


      The Queue payload type:

      CREATE type aq.message_type as object (
      subject VARCHAR2(30),
      text VARCHAR2(80));



      The suspect code:


      Dim Q As OraAQ
      Dim QMsg As OraAQMsg

      Set OO4OSession = CreateObject("OracleInProcServer.XOraSession")
      Set empDb = OO4OSession.OpenDatabase("AQ_DUAL", "aq/aq", 0)
      Set Q = empDb.CreateAQ("AQQUEUE")
      'Specify the message value.

      Set QMsg = Q.AQMsg(ORATYPE_OBJECT, "MESSAGE_TYPE", "AQ")


      Set QMsg = Q.AQMsg
      'HERE for Error ORA-25215 'user_data type and queue type do not match'
      Q.Dequeue