Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problems connecting to Oracle queue using C#

User_QLGOSApr 6 2022 — edited Apr 6 2022

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!

Comments

Post Details

Added on Apr 6 2022
#advanced-queueing, #database-key-features
0 comments
301 views