I have been trying to insert some text into a blob space on an informix database. I keep getting an SQLCODE=-603 Could not Close blob error. Here is the code for my insert:
function Process_Data()
{
$connection = @ifx_pconnect() or die("Couldn't connect to the database.");
$strEmp_Name = "Fernando";
$strEmp_ext = "123";
$strSubCategory = "1";
$strText = "this is some data that I would like to insert into the big field";
$blobidarray = array();
$textid = ifx_create_blob(1,0,"this is the text blob data");
$blobidarray[] = $textid;
$db_query = "insert into ticket_info
(user,emp_ext,status,hardware_id,emp_assigned_id,desc,software_id)
values('$strEmp_Name','$strEmp_Ext','1','$strSubCategory','0',?,'0')";
$result = ifx_query($db_query, $connection, $blobidarray);
if (!$result){
echo ifx_errormsg();
}else{
ifx_free_result($result);
echo "<h1>Insert OK</h1>";
}
