[PHP-DB] Problem with writing to database. Possibly a CLOB error...

[simon]

Hi,

I get the following error when I try and write to the database on only
some of the items in $res. The majority go in fine. When I enter the
ones causing an error, individually, they go in without a problem.  Is
it because I'm using a loop to enter the data? Can anyone help please?

Thanks in advance,

Simon.


Error:
Warning: OCIStmtExecute: ORA-01704: string literal too long

Code:
while ( list($k, $v) = each($res) )
{
    $body = $res[$k][1];
    $id = $res[$k][0];
    $body = preg_replace( "/'/", "''", $body );
    $sql = "update story
            set body = '$body'
            where id = $id returning body into :body";

    $stmt = OCIParse($db->conn, $sql);
    $lob = OCINewDescriptor($db->conn, OCI_D_LOB);
    OCIBindByName($stmt, ":body" , &$lob, -1, OCI_B_CLOB);
    OCIExecute($stmt, OCI_DEFAULT);
    $body = preg_replace( "/''/", "'", $body );
    if ( $lob->save ("$body") )
    {
        echo "$id written to database<BR>\n";
    }

    OCICommit($db->conn);
    OCIFreeStatement($stmt);
    OCIFreeDesc($lob);
}

--

Simon Pospisil                          Mail:  [EMAIL PROTECTED]
Web Engineer                            Web:   http://www.fastsearch.com/
Fast Web Media Ltd.                     Phone: +44 (0) 161 835 3444
Suite 1202, Sunlight House Quay Street  Fax:   +44 (0) 161 835 3488
Manchester, England M3 3JZ

Try FAST Search: http://www.alltheweb.com




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]