Re: Oracle and CLOBs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



try

SELECT Title, NewsDate, Content FROM inf_news WHERE ID_News = 5
Where Title is VarChar, NewsDate is Date and Content is CLOB


! not "Content is a CLOB" ! ----- simple "is CLOB" because i guess it interprets you say "is a" not "is a CLOB"..it thinks the datatype you are searching is "a"

cybercop78



On Mon, 13 Jan 2003 19:35:04 -0600, Jadiel Flores wrote
> 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 a CLOB.
> 
> Any suggestion???
> 
> Jadiel Flores
> -------------------------
> http://www.abargon.com
> jflores@abargon.com
> (52-55) 52-29-80-34
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php





http://www.idilis.ro - Stiri, e-mail gratuit, download,
SMS, server de counter-strike, hosting gratuit, servicii internet...
Fii cu un pas inaintea celorlati!


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux