Gena01 Blog

Leveraging Oracle connection metadata functionality

One little known feature of Oracle is connection metadata functionality. It might not sound as important as it actually is.

Here is a bit of a back story. When Oracle 10g came out one of the biggest features that it added was web-based Oracle Enterprise Manager (OEM) interface. For the... [Read More]

May 21, 2010, 06:14:22 pm - 0 comments

Oracle query validation

So we got an interesting use case at work where we have an admin interface to setup filters in our system. Our staff is able to enter expressions in the web interface and we have a way of checking that whatever they enter is valid or not.

While trying to optimize the validation code to... [Read More]

May 21, 2010, 05:39:10 pm - 0 comments

Going to PHP Tek 2010 next week.

I am heading to PHP Tek 2010 ( next week.

If you are going to be there come and say hi.

Gena01 [Read More]

May 13, 2010, 03:12:23 pm - 0 comments

My recent learnings with Oracle Instant Client and OCI8 API.

I was recently involved in upgrading our Application servers to the latest Oracle Instant Client 11.g ( including installing the latest PHP OCI8 ( module (1.4.1).

Currently Oracle provides binaries for Linux in RPM and ZIP(?) format.... [Read More]

May 13, 2010, 03:10:12 pm - 0 comments

CodeWorks 2009 NYC

I had a chance to attend the NYC stop of CodeWorks 2009 ( tour. NYC was the last stop of the tour. It was a two day event with a tutorial on the first day (Sunday) and the main conference event on Monday with a closing open bar event sponsored by Microsoft. I attended... [Read More]

October 13, 2009, 10:29:00 am - 0 comments