Friday, August 04, 2006

What is the difference between the OCI and ORA extension modules?

PHP offers two extension modules that can be used to connect to Oracle:

(1) The normal Oracle functions (ORA)
(2) The Oracle Call-Interface functions (OCI)

OCI should be used whenever possible since it is optimized and provides more options. For example, ORA doesn't include support for CLOBs, BLOBs, BFILEs, ROWIDs, etc.

But it doesn't matter what module do you used, the important thing is your project finished on schedule and satisfy your client. How about me? I'm using the ORA module in my Oracle project. I'm not using CLOB or BLOB to save my image or file on the Oracle database but only the path to the image or the file. So, our database not to be burden to handle images or file.

No comments: