I want to know about oracle listener .I am having oracle8i as database and
for the first time iam hearing about this. My doubts are
1)Whether it is buildin with oracle or i need to download it and configure.
The Listener is part of Oracle Net8 (previously called SQLNet). In other words, you have it already. If anyone can connect into the database, then the Listener is running and probably configured correctly. To connect into the database using PHP, you will need the Net8 client installed (and properly configured) on the machine running PHP. People forgetting Net8 (or misconfiguring it) on the client (=PHP) machine is usually where connectivity problems occur. Hint: Tell your Oracle DBA that you want SQLPlus installed and operational on your PHP machine. That will make him/her install and configure Net8 as well as SQL*Plus.
2) How can i built a C application which will update a table or delete an
entry from a table(How can i execute a query).
You don't need a C program in order to access the database from PHP. Check out PHP's OCI8 functions at http://www.php.net/manual/en/ref.oci8.php
Writing a server-side C program to access the database is definitely beyond a PHP forum like this. If you still really want to do it, then check out Oracle's precompilers. Their C precompiler used to be called Pro*C, but has been renamed many times over the last ten years. Look on your Oracle Installation CDs to find out what it is called today.
-- Michael
Darkstreak Consulting
