From: "Nilanjan Das" <[EMAIL PROTECTED]>
>
> update fmly set HQ_SRS_ID = N'20037026',HQ_SRS_NAME = N'TRADOC
> DOCUMEWTAAO E SERVIOS' where fmly_id = 126908
....
>
> DBD::Oracle::db prepare failed: ORA-01756: quoted string not properly
> terminated (DBD ERROR: OCIStmtPrepare)
That's what placeholders are for, try:
$sql =
"update fmly set HQ_SRS_ID = ?,HQ_SRS_NAME = ? where fmly_id = ?";
$dbh->prepare($sql);
$dbh->execute("N'20037026'", "N'TRADOC
DOCUMEWTAAO E SERVIOS", 126908);HTH
