i use oracle8i and php4
my table struct show below
create table hx(name varchar2(10),content clob)
I want to insert large text into the table
but appear these errors
OCILobWrite: ORA-22990: LOB locators cannot span transactions
my program show below:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ÊäÈë</title>
<style type="text/css">
<!--
body { font-size: 9pt}
-->
</style>
</head>
<body bgcolor=white>
<?
$conn=OCILogon("txl","txl123");
$SQL="INSERT INTO hx(name,content) VALUES('$name', empty_clob()) RETURNING content INTO :content";
$stmt = OCIParse($conn,$SQL);
$clob = OCINewDescriptor($conn, OCI_D_LO😎;
OCIBindByName ($stmt, ":content", &$clob, -1,OCI_B_CLO😎;
OCIExecute($stmt);
if ($clob->save("sadfsd")){
OCICommit($conn);
echo "<br><br><br><center>ÒѾ³É¹¦·¢²¼£¡";
}Else{
echo "ʧ°Ü";
}
OCIFreeDesc($clob);
OCIFreeStatement($stmt);
?>
</body>
<?
OCILogoff($conn);
?>
