I'm having problems loading an Oracle CLOB field using php. I'm
loading 4 fields, one of where a.ANSWER is a CLOB. The first three
have data but the CLOB comes through NULL. I verified data is present.
Below is my sql code:

___ Start of SQL ---

$sql  = "SELECT a.ID, a.ENTRY, a.NO, a.QUESTION, a.ANSWER) ";
$sql .= "FROM SARQUAN a ";
$sql .= "WHERE a.ENTRY = '2008' AND a.ANSWER IS NOT NULL";
$stmt = oci_parse($conn, $sql) or die ("Couldn't parse statement-1A");
 oci_execute($stmt) or die ("Couldn't execute query Select-1A");

___ End of SQL ___

Any help will be appreciated.

Michael


Reply via email to