note 81259 added to ref.oci8
| From: | AlexMonte at osu1 dot php dot net | Date: | Wed, 20 Feb 2008 13:56:11 +0000 |
| Subject: | note 81259 added to ref.oci8 | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-136311@lists.php.net to get a copy of this message | ||
Salvando um CLOB.
$CLOB_texto = OCINewDescriptor($conexao, OCI_D_LOB);
$CLOB_insert = "INSERT INTO table_clob
(name, C_texto) VALUES (:name ,EMPTY_CLOB()) RETURNING C_texto INTO :C_texto";
$stmt = OCIParser($conexao, $CLOB_insert);
OCIBindByName ($stmt, ":C_texto", $CLOB_texto, -1, OCI_B_CLOB);
OCIBindByName ($stmt, ":name", $name, 80);
if (OCIExecute($stmt, OCI_COMMIT_ON_SUCCESS))
{
$CLOB_texto->save($texto_descricao);
OCICommit($conexao);
$CLOB_texto->free();
}
Atualizando um CLOB
$CLOB_texto = OCINewDescriptor($conexao, OCI_D_LOB);
$CLOB_update = "UPDATE BD_SICA.FC_PLANO_ENSINO SET C_texto = EMPTY_CLOB(),
name = :name
WHERE id = :id
RETURNING C_texto INTO :C_texto";
$stmt = OCIParser($conexao, $CLOB_update);
OCIBindByName ($stmt, ":C_texto", $CLOB_texto, -1, OCI_B_CLOB);
OCIBindByName ($stmt, ":name", $name, 80);
OCIBindByName ($stmt, ":id", $id, 10);
if (OCIExecute($stmt, OCI_COMMIT_ON_SUCCESS))
{
$CLOB_texto->save($texto_descricao);
OCICommit($conexao);
$CLOB_texto->free();
}
----
Server IP: 69.147.83.197
Probable Submitter: 200.242.39.2
----
Manual Page -- http://www.php.net/manual/en/ref.oci8.php
Edit -- https://master.php.net/note/edit/81259
Del: integrated -- https://master.php.net/note/delete/81259/integrated
Del: useless -- https://master.php.net/note/delete/81259/useless
Del: bad code -- https://master.php.net/note/delete/81259/bad+code
Del: spam -- https://master.php.net/note/delete/81259/spam
Del: non-english -- https://master.php.net/note/delete/81259/non-english
Del: in docs -- https://master.php.net/note/delete/81259/in+docs
Del: other reasons-- https://master.php.net/note/delete/81259
Reject -- https://master.php.net/note/reject/81259
Search -- https://master.php.net/manage/user-notes.php