Archive for 'Oracle'

PHP call oracle store procedure

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 import & export

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 […]

Oracle procedure testing

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 […]

Zend php connect to oracle using tnsnames

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. (more…)