[PHP] ORA-28582: direct connection not allow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux