different between OCIPLogon and ora_logon

alexnico

Hello everybody, what is the different between these functions:

OCIPLogon(username, password, [database]) and
ora_logon(username@database, password).

I found these functions to connect to Oracle database, but where is the different?

Thank you!

Yamakazi

ociplogon is in the OCI 8 function set and so it uses the OCI8 call interface. The OCI 8 function set is more advanced then the Oracle function set of wich ora_logon is a member.

You can't use the OCI8 and Oracle function set together (although you can use both in one script).

My standard rule is
Oracle DB < 7 --> ORACLE function set
Oracle DB 7 + --> OCI 8 function set.

Hope that helps.

alexnico

Thank you Yamakazi, it's very helping me. Sorry for the cross post, because nobody answer me at that post, so i moved to here. 🙂

blaci

Originally posted by Yamakazi

My standard rule is
Oracle DB < 7 --> ORACLE function set
Oracle DB 7 + --> OCI 8 function set.

Hope that helps.

Should i use OCI8 functions also with Oracle9i ?