[PHP-DB] [PHP] ORA-28582: direct connection not allow

[PHP - NEWS]

I test my script PHP on Debian(sarge) Oracle9.0.2 , and a mandrake 
Oracle 9.0.2 . On Mandrake all is OK, but on Debian, i have this message :

 ORA-28582: a direct connection to this agent is not allowed
I search on Google, faqoracle, oracle.com, without finding any answers 
or way of solutions.

CODE PHP:
i need to add this on debian, if i want to have any message :

[code]
putenv("ORACLE_BASE=/home/oracle");
putenv("ORACLE_HOME=/home/oracle/OraHome");
putenv("ORACLE_SID=STOR");

[/code]

SCRIPT GLOBAL :

[code]

echo "TEST<BR><BR>";

if ($c=OCILogon("storeland", "storeland", "TEST-ORCL")) {
  echo "Successfully connected to Oracle.\n";
} else {
  $err = OCIError();
  echo "Oracle Connect Error " . $err[text];
}

$query = "select * from articles";

$stmt = ociParse($c, $query);

if (!ociExecute($stmt)){
        echo " NOK";
        return FALSE;
}else{
        echo "OK<br>";
}

while ($succ = OCIFetchInto($stmt, $row)) {
        foreach ($row as $item) {
                echo $item." ";
        }
        echo "<br>\n";
}

[/code]

I create a new topic, as my problem is different.

Thanks a lot for your help.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php