Hi!
**This is the error.....
oci8_open_server: Error while trying to retrieve text for error ORA-12154 in /home/apcosoft/www/test_oci.php3 on line 3
**This is the setup....
two servers one DB server 192.168.0.4, one webserver 192.168.0.5.
tnsping and sqlplus work just fine on the webserver to the dbserver
**This is the script giving the error
<?php
print "<PRE>";
$c1 = ocilogon(?????, ?????, ????) ;
function select_data($conn)
{ $stmt = ociparse($conn,"select * from scott.emp");
ociexecute($stmt,OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt)){
echo ociresult($stmt,"EMPNO")." ";
echo ociresult($stmt,"HIREDATE")." ";
echo ociresult($stmt,"ENAME")."\n";
}
echo $conn."----done\n\n";
}
select_data($c1);
ocilogoff($c1);
print "</PRE>";
?>
**These are the updates to apachectl
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/8.1.5
ORACLE_NLS33=/opt/oracle/product/8.1.5/ocommon/nls/admin/data
LD_LIBRARY_PATH=$LD_LIRARY_PATH:$ORACLE_HOME/lib:/usr/lib
