note 81259 added to ref.oci8

From: 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

« previous php.notes (#136311) next »