OCI Wrapper?

[fizban]

I have searched through the forum looking for ways to access Oracle without having a preconfigured ODBC DSN or having to create it on the fly and the alternatives I found are ADO and OCI. OCI seems more efficient and OCILib seems to be the way to go.

Apparently, there seems to be some kind of OCI Wrapper for pb (RW_ocilib), but I am not sure if it is mantained. It also seems to be a wrapper for the dll.

I also found a piece of code from gnozal that also wrapped some functions, although I did not manage to make it work (it failed at the OCI_ConnectionCreate call, while the RW wrapper did not, with the same parameters). [Edit:] I actually made it work after realising it was supposed to be compiled in Unicode.

There is also a wishlist item to include ocilib as part of PB. I do not want to go that far (and probably the ocilib license does not allow full integration), but a working wrapper would be nice. Anyone is using OCILib and has already created some kind of wrapper and examples?

The above mentioned RW_OCIlib is working fine here with PB 5.11 and a very simple query, after removing the types in the definitions of the pointers.

[Michael42]

This would be an incredible feature for PB! There are so many .Net and Java applications that could be replaced by PB if this could be implemented. PB is so much easier and faster to development in.

True ODBC can be used to connect to an Oracle database, but if the ability to easily use an OCI connection to Oracle were to be added into PB it would put PB in the big leagues.

...and possibly into big league profits for the developers\company.

BTW, I am a certified Oracle DBA and Oracle book author. Oracle Enterprise Handbook ISBN-13: 978-1878398635 etc. I would promote PB even more than I do now if PB could make OCI connections to Oracle.

Michael

[fizban]

As I indicated above, you can actually make OCI connections using OCILib. It is pretty easy to use for basic access and seems to have a lot of power for more advanced functionality... Are you looking for an alternative to OCILib?

[Michael42]

Wow I did not realize we had away to do this. Thanks!!!

Yes, though to being able to connect to Oracle using OCI as being part of the standard PB product for the furture.


For now though I will pursue your info\lib.

Thanks so much!