Hi,

I just finish to configure my debian(sarge) with php4.3.10/oracle9i support/apache1.3.
I use this link (http://www.faqts.com/knowledge_base/...html/aid/26582) to make a package .deb .
But before use this tips, i have installed my php / apache / mysql , apt-get install php4 / apt-get apache / apt-get mysqld .
Now, in my phpinfo(), i see Oci8 / oracle support version 9.0 correctly. I can connect with sqlplus on my server oracle , same with PHP.
Unfortunately, when i test to do a query, i have many messages error different :

$query = "select * from magasins";
Warning: ocifetchinto(): OCIFetchInto: ORA-01858: a non-numeric character was found where a numeric was expected in /var/www/test3.php on line 28
$query = "select * from articles";
Warning: ociexecute(): OCIStmtExecute: ORA-03106: fatal two-task communication protocol error in /var/www/test3.php on line 21
$query = "select * from articles";
Warning: ociexecute(): OCIStmtExecute: ORA-28582: a direct connection to this agent is not allowed in /var/www/test3.php on line 21
my script PHP is :
Code:
putenv("ORACLE_BASE=/home/oracle");
putenv("ORACLE_HOME=/home/oracle/OraHome");
putenv("ORACLE_SID=TEST");

$c=OCILogon("storeland", "storeland", "TEST-ORCL")
$query = " ";
$stmt = ociParse($c, $query);
ociExecute($stmt);

while ($succ = OCIFetchInto($stmt, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "<br>\n";
}
tnsnames.ora:
TEST-ORCL.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.206.39)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
I m apoligize to disturb you, but i dont know where is my problem. Probably configuration linux, maybe compilation PHP, or my script.

Thanks for your help, Best regards,
INARD Ludovic

PS : i have a 2nd linux (mandrake) and all is OK.I can do query.