All I need to do is store a string that has the potential to be longer than 4000 bytes into a CLOB type column, then retrieve it. Seems simple enough but I haven't been able to do it. Here's what I have:
$MLIST = ocinewdescriptor($resource, OCI_D_LO😎;
$stat = "INSERT INTO tbl_maillist (ID, O_ID, L_TITLE, MLIST) VALUES (MAILLIST.NEXTVAL,'".$_SESSION['OID']."','".$_POST['L_TITLE']."', empty_clob()) returning MLIST into :MLIST";
$st = ociparse($resource, $stat);
OCIBindByName($st,":MLIST",&$MLIST, -1, OCI_B_CLO😎;
OCIExecute($st);
This inserts "Object" into the table, but it looks like it's always 0 length. I caught something in my search that made a reference to doing a "save to the oci descriptor" but have yet to find any other information on that. I get no errors with this, or using the following code to pull the Object:
$lst = "SELECT MLIST FROM tbl_maillist WHERE ID = $L_ID";
$st = ociparse($resource, $lst);
OCIExecute($st);
OCIFetchInto($st, $row, OCI_ASSOC);
if(is_object($row['MLIST'])){
$rowlist = $row['MLIST']->load();
echo "MLIST: <BR>".$rowlist;
}
returns the word "Object" flawlessly... The actual list is well over 5000 bytes... but I can't retrieve any of it in a readable format.
ANY help would be greatly appreciated...
Thanks!
