Hi Guys,
This is part of my code When I run my whole program I get this warning
OCI-Lob::save()[function.save]😮RA-22990: LOB locators cannot span transactions
the value of row[1] is coming from mysql.
$temp_picture=$row[1];
$pict_image=oci_new_descriptor($conn,OCI_D_LO😎;
$oracle_query="insert into card(id,picture) VALUES (:id,empty_blob()) returning picture into :pict";
$stid=oci_parse($conn, $oracle_query);
oci_bind_by_name($stid,':id',$temp_suid);
oci_bind_by_name($stid,':pict',$pict_image,-1,OCI_B_BLOB);
$r=oci_execute($stid);
if ($r)
{
print "One Row Inserted \n";
$pict_image->save($temp_picture);
}
Could you please double check the last line if the command is correct
Thank you