读取记录（成功） [PHP] select $sql = "select * from web_test"; $stmt = OCIParse($conn,$sql); @OCIExecute($stmt); @OCIFetchInto($stmt, &$info, OCI_ASSOC); echo "
Content=>" . $info['TEXT']->load(); @OCIFreeStatement($stmt); [/PHP] 插入记录（有错）:mad: [PHP] $text="asdfa13523;lkjASDFSADFADSGasdfa13523;lkjASDFSADFADSGasd...."; $sql = "insert into web_test (id, test) values (id = '22', text = empty_clob()) returning field2 into :text"; $stmt = OCIParse($conn, $sql); $clob = OCINewDescriptor($conn, OCI_D_LOB); OCIBindByName ($stmt, ":text", &$clob, -1, OCI_B_CLOB); if(!OCIExecute($stmt,OCI_DEFAULT)) print_r(OCIError($stmt)); else{echo "提交成功";} if($clob->save($text)){ OCICommit($conn); echo "提交成功"; } else{ print_r(OCIError($stmt)); } //释放资源 $clob->free(); OCIFreeStatement($stmt); [/PHP] 提示错误 Warning: ociexecute(): OCIStmtExecute: ORA-00917: 缺少逗号 in D:\wwwroot_php\zj_ga\web\test_oracle2.php on line 20 Array ( [code] => 24315 [message] => ORA-24315: 非法的属性类型 [offset] => 43 [sqltext] => ) Warning: save(): OCILobWrite: OCI_INVALID_HANDLE in D:\wwwroot_php\zj_ga\web\test_oracle2.php on line 23 //更改记录（还没呢！！）