How 2 Guru

For PHP, it is not a difficult task to connect to Oracle database.
But recently, I am working on a project that require me to execute the oracle store procedure with pass in some input & retrieve the output.

It should be pretty easy, just I never try it before.
So I write a simple Oracle Store procedure & a PHP page.

Below is my testing.
read more »

Actually, I am a newbie for the oracle database. Never though it before I start my current job.
Lucky my company has a oracle expert & always help me to solve those problems. 

Today, just want to share some of my experience regarding the export & import for oracle.
I was taught to use the imp & exp command for import & export an oracle schema. 
Below is the imp & exp command examples:
read more »

As a developer, most of the time you have to testing on your script output.
Some how, you also need to debug into the script & checking on each variable value.

In Oracle procedure, if you doesn’t having any debugging tools like sql developer. It is very difficult to trace your procedure whether is working properly or not.
For me, I will using the DBMS_OUTPUT.PUTLINE command & sqlplus into the Oracle for the testing.

Below is the example. read more »

This few days I am trying to configure my Linux server Zend PHP to connect oracle by using the tnsnames.ora profile.

For my finding, there are several ways to do so.

read more »