Connecting Oracle Database using Oracle Objects for OLE (OO4O)

[IDILIO]

I try to connect to an Oracle Database using OO4O. First of all every property node/invoke node that I expect to return a refnum to other type it doesn't return. It returns a variant, I need to convert the variant to the refnum type I expect (which is not always obvious), is this the only way to using OO4O??

Ok, but using this I can do selects and call stored procedures. The problem is that for call storing procedures I need to put in the block diagram the property node OraDatabase(Parameters) and after this property node is in the block diagram I can't close anymore the session at database (until close the application). I removed all the parameters, I close reference to parameters, database, and session, I call invoke node close database. I don't know what more I can do, and the session in the database always still open (inactive but still exists).

Do you have any ideas? Anybody have experience with OO4O?

I need some help.

Thanks

Attached Vi that shows the problem (this only happens using the OraDatabase(Parameters) property node)

[mehdi.afif]

Hello IDILIO.

Unfortunately, we don't have enough experience in OO40 to help you. I would suggest you to rather contact Oracle and I think they will be able to give you more informations about Oracle activeX class.

Regards

[IDILIO]

This problem is specific in Labview (I can do the code in other language like vb.net and it works ok).

So I don't think Oracle can help on this.

There are some people that already used OO4O in labview, i'm sure that they know what i'm doing wrong....