Forum Stats

  • 3,825,197 Users
  • 2,260,480 Discussions
  • 7,896,437 Comments

Discussions

Problems connecting to Oracle queue using C#

User_QLGOS
User_QLGOS Member Posts: 1 Green Ribbon
edited Apr 6, 2022 5:13AM in Advanced Queueing

I'm trying to connect to an Oracle queue using C#.

I'm using the Oracle.DataAccess.Client DLL:

OracleAQQueue queue = new OracleAQQueue("BANINST1.GP_SYNC_Q", connection, OracleAQMessageType.Udt, "BANINST1.GP_SYNC_Q");

Where BANINST1 is obviously the schema and GP_SYNC_Q is the queue name. The DB connection is established, as I can run SQL using the connection object.

But I keep getting the following error when I run queue.Dequeue():

OCI-22303: type "BANINST1"."GP_SYNC_Q" not found

I can't seem to get past this. I've confirmed that the permissions are correct. The user has both Queue and Dequeue privileges. Any ideas on this? Much appreciated!