折雨的天空
贴一段php使用Oracle把字符串写入blob字段的代码。
2016-8-27 我好笨
// connect to oracle
require __SITEROOT."config/oracleConfig.php";
$conn = oci_connect($databaseConfig[__INTERFACE]['user'],$databaseConfig[__INTERFACE]['password'],$databaseConfig[__INTERFACE]['host']);
if($format=='xml')
{
$stmt = oci_parse($conn,"INSERT INTO api_data_xml(uuid,suuid,original_type,original_xml) VALUES ('$api_data_uuid','$summary_uuid',1, EMPTY_BLOB()) RETURNING original_xml INTO :tex_blob");
}
if($format=='json')
{
$stmt = oci_parse($conn,"INSERT INTO api_data_xml(uuid,suuid,original_type,original_json) VALUES ('$api_data_uuid','$summary_uuid',2, EMPTY_BLOB()) RETURNING original_json INTO :tex_blob");
}

$clob = oci_new_descriptor($conn,OCI_D_LOB);
oci_bind_by_name($stmt,':tex_blob',$clob,-1, OCI_B_BLOB);
oci_execute($stmt,OCI_DEFAULT);
//这个save要写到oci_execute后面,手册上的例子都是错误的
$clob->save($xml);
oci_commit($conn);
$clob->free();
oci_free_statement($stmt);


发表评论:
昵称

邮件地址 (选填)

个人主页 (选填)

内容