Database events

ziza84

New member
Joined
Nov 5, 2010
Messages
1
Programming Experience
Beginner
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?
 
Back
Top