----- Original Message -----
From: Verdana Musone
Sent: 200289 16:27
To: [EMAIL PROTECTED]
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

Reply via email to