Oracle and CLOBs

From: Date: Tue, 14 Jan 2003 15:53:20 +0000
Subject: Oracle and CLOBs
Groups: php.general 
Request: Send a blank email to php-general+get-131571@lists.php.net to get a copy of this message
Hi, I'm having a big problem with php and Oracle. I'm using Oracle 8.1.6 and PHP 4.2 with the Oracle component in a Solaris server, I can not recompile apache and php to install the oci8 component and I'm having lot of problems with CLOBs, I'm receiving this error: Warning: Ora_Exec failed (ORA-00932: inconsistent datatypes -- while processing OCI function OEXEC/OEXN) in /var/www/espejo/includes/con.php on line 107 Line 107 contains this code: Ora_Exec($this->cursor); The query is: SELECT Title, NewsDate, Content FROM inf_news WHERE ID_News = 5 Where: Title is VarChar, NewsDate is Date and Content is a CLOB It works fine if the query doesn't contain the CLOB field. Any suggestion??? Jadiel Flores ------------------------- http://www.abargon.com jflores@abargon.com (52-55) 52-29-80-34

« previous php.general (#131571) next »