php oracle clob

来源:互联网 发布:做股票网络销售怎么样 编辑:程序博客网 时间:2024/05/16 06:22
      //$sqlstr="INSERT INTO m_t_announcement(ann_content)VALUES(EMPTY_CLOB())RETURNING ann_content INTO : log";
$sqlstr="update m_t_announcement set ann_content=EMPTY_CLOB() RETURNING ann_content INTO : log";
$clobstr="很大的内容;
$conn=ociLOGOn("yygh","yygh4rfv","(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.98)(PORT=1521)))(CONNECT_DATA=(SID=DHDH114)))",'utf8');
//$conn=OCILogon("edt", "ppedt4rfv", "ORCL","UTF8");//数据库连接

$stmt=oci_parse($conn,$sqlstr);
$clob = oci_new_descriptor($conn, OCI_D_LOB);
oci_bind_by_name($stmt, ":log", $clob, -1, OCI_B_CLOB);
$result=oci_execute($stmt,OCI_DEFAULT);
$clob->save($clobstr);
oci_commit($conn);

dump("ok");
原创粉丝点击