- 论坛徽章:
- 0
|
php操作oracle的clob类型字段有大小限制?
OCI函数的相关用法手册里应该写的很详细,网上也有文章介绍,你找找吧。
$conn = OCIlogon("user","pw","TNS" ;
(1)插入数据库(手册中的例子):
<?
$stmt = OCIParse($conn,"INSERT INTO table (id, clobtext) VALUES (text.NEXTVAL,, EMPTY_CLOB()) RETURNING clobtext INTO :clob" ;
sql = "begin tempclobtest_package.saveclob(:clob); end;";
$clob = OCINewDescriptor($conn, OCI_D_LOB);
$stmt = OCIParse($conn, $sql);
OCIBindByName ($stmt,':clob', &$clob , -1,OCI_B_CLOB );
if(!OCIExecute($stmt, OCI_DEFAULT)) {print_r(OCIError($stmt));}
else{echo "提交成功";}
if($clob->;save($clobtext))
{
OCICommit($conn);
echo "提交成功";
}
else
{
print_r(OCIError($stmt));
}
//释放资源
$clob->;free();
OCIFreeStatement($stmt);
?>;
(2)读取:
$stmt = OCIParse($conn,"SELECT clobtext From table" ;
OCIFetchInto($stmt, $result);
$clobtext=$result[1]->;load() ; |
|