Fw: [PEAR] ORA 12571 error TNS PACKET write failure
| From: | Verdana Musone | Date: | Fri, 09 Aug 2002 08:28:16 +0000 |
| Subject: | Fw: [PEAR] ORA 12571 error TNS PACKET write failure | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-111782@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: Verdana Musone
Sent: 2002年8月9日 16:27
To: pear-general@lists.php.net
Subject: [PEAR] ORA 12571 error TNS PACKET write failure
I used below code to write data to ORACLE 8i DB. But i got some error message some times:
"12571 error TNS PACKET write failure."
How to solve this problem?
----------------------------------------------------------------------------------------------------
$id = $nws -> _dbIns -> nextId('news_cata_sequence', true);
if (DB::isError($id)) {
die($id->getMessage());
}
if ($_POST['neverExpire']=='1') {
$expireTime = 0;
} else {
$expireTime = mktime(0, 0, 0, $_POST['month'], $_POST['day'],
$_POST['year']);
}
$alldata = array(.....); // omission
$sth = $nws -> _dbIns -> prepare("INSERT INTO NEWS_CATA VALUES(?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)");
$res = $nws -> _dbIns -> execute($sth, $alldata);
if (DB::isError($res)) {
die($res->getMessage());
}
------------------------------------------------------------------------------------------------------
db_error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -1
[message] => DB Error: unknown error
[userinfo] => SELECT news_cata_sequence_seq.nextval FROM dual [nativecode=ORA-12571: TNS:
PACKET write failure]
[callback] =>
)
-
- Verdana Musone
- http://www.phpdoc.net
-Get more from the Web. FREE MSN Explorer download : http://explorer.msn..comGet more from the Web. FREE MSN
Explorer download : http://explorer.msn.com