Differentiate OCl8 and ORA Extension Module

Asked By frank wilkinson 0 points N/A Posted on - 10/21/2011

I need to complete a report regarding OCl8 and ORA extension modules.

These two are extension modules that PHP offers and can be used in connecting to Oracle.

My question is what are the major differences of the two?

And which is providing more options and very optimized to use. 

• Status: Open
• Question Views: 926
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Harpe byers

Go To Solution

Answered By stephen_99 0 points N/A #111572

Differentiate OCl8 and ORA Extension Module

 

Hello,

As both of the extension modules are for PHP that can be used to connect to Oracle.

ORA [Normal Oracle Function]

OCI [Oracle Call Interface Function]

It's up to you whom you used to connect to Oracle but it is recommended that we should use OCI instead of ORA because OCI is more optimized and OCI also provides more features and options. Whereas ORA, it does not support CLOBs, BLOBs, BFILEs, ROWIDs.

Therefore OCI should be used instead of ORA.

 

About stephen_99

Questions
0

Answers
5

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/27/2011
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Harpe byers 10 points N/A #111574

Differentiate OCl8 and ORA Extension Module

Hi Frank,

The important thing for you is to complete your project well and in right time instead of selecting OCI or ORA.

I am not using BFILEs, CLOBs, BLOBs etc. in my project and therefore I can still use OCI and not ORA.

I will suggest you to use OCI or ORA which saves your time the most.

Your database shall not have any extra burden to carry the weight of the images or files you are using in your project.

About Harpe byers

Questions
3

Answers
202

Best Answers
91

• Vote Up 0 Vote Down

• Posted on - 12/06/2012
• Question Category: Oracle Database