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