Oracle and CLOBs
| From: | Jadiel Flores | 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