Hi I am connecting to Oracle 9 database using OracleInProcServer library from my .NET 1.1 project.
I want to use database events so Oracle can notify me of a change in database.
My code:
Dim gOraSession As Object
Dim gOraSubscriptions As OracleInProcServer.OraSubscriptions
Dim gOraDatabase As OracleInProcServer.OraDatabase
gOraSession = CreateObject("OracleInProcServer.XOraSession")
gOraDatabase = gOraSession.DbOpenDatabase("<database_instance>", "<username>/<password>", OracleInProcServer.dbOption.ORADB_ENLIST_FOR_CALLBACK)
gOraSubscriptions = gOraDatabase.Subscriptions
gOraSubscriptions.Add("<queue_name>:<subscriber>", DBEventsHdlr, A) --------ERROR
gOraSubscriptions(0).Register()
I get the Type Mismatch error on the line before the last one. What could be the problem?
I want to use database events so Oracle can notify me of a change in database.
My code:
Dim gOraSession As Object
Dim gOraSubscriptions As OracleInProcServer.OraSubscriptions
Dim gOraDatabase As OracleInProcServer.OraDatabase
gOraSession = CreateObject("OracleInProcServer.XOraSession")
gOraDatabase = gOraSession.DbOpenDatabase("<database_instance>", "<username>/<password>", OracleInProcServer.dbOption.ORADB_ENLIST_FOR_CALLBACK)
gOraSubscriptions = gOraDatabase.Subscriptions
gOraSubscriptions.Add("<queue_name>:<subscriber>", DBEventsHdlr, A) --------ERROR
gOraSubscriptions(0).Register()
I get the Type Mismatch error on the line before the last one. What could be the problem?