yes, its is make && make install.
i installed it properly. The mistake I found was that instead of "--with-oci8" I should have put "--with-oracle" - as I am accessing oracle functions NOT oci8 functions.
so the php compiles, not probs.
Also I put "libclntsh.so.8.0" which is in $ORACLE_HOME/lib/libclntsh.so.8.0 into $ORACLE_HOME. before starting apache, I set the $ORACLE_HOME, $ORACLE_SID, etc parameters and now apache+php was able to atleast attempt a connection to oracle.
BUT (nevertheless) my next problem is..
somehow, it could not make a connection. let me explain as below.
--(sampleora.php)--
<?
echo "$ORACLE_HOME <br> $ORACLE_SID <br>";
$handle = ora_plogon("scott@ndb01_my.hostname.com", "tiger")or die;
$cursor = ora_open($handle);
ora_commitoff($handle);
$query = "SELECT * FROM EMP";
ora_parse($cursor, $query) or die;
ora_exec($cursor);
echo "<PRE>\n";
echo "$query\n\n";
$numcols = 0;
while(ora_fetch($cursor))
{
$numcols = ora_numcols($cursor);
for($column=0; $column < $numcols; $column++){
$data = trim(ora_getcolumn($cursor, $column));
if($data =="")
$data = "NULL";
echo"$data\t";
}
echo "\n";
}
$numrows = ora_numrows($cursor);
echo "\nROWS RETURNED: $numrows\n";
echo "</PRE>\n";
ora_close($cursor);
?>
--end(sampleora.php)--
--begin-browser-output--
/usr/local/oracle/software/8.1.5
NDB01
Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-12154) in /usr/local/apache/htdocs/oracle-test/check_ora.php on line 3
--end-browser-output
So thats the problem, I cannot even retrieve the error text from oracle.. have you found such things before... ?
cheers
nilesh
