Oracle CLOB and PHP

From: Date: Thu, 08 Mar 2001 06:10:25 +0000
Subject: Oracle CLOB and PHP
Groups: php.general 
Request: Send a blank email to php-general+get-42989@lists.php.net to get a copy of this message
Hello, I am trying to execute a simple SELECT from Oracle 8.1.6 in a php4.0.3pl1 page..... $sql_get_info="SELECT ID, Title, CLOB FROM Employee WHERE ID=37"; if ($cursor = ora_do($connection, $sql_get_info)) { $valid_opp_title = ora_getcolumn($cursor, 0); //id $valid_opp_text = ora_getcolumn($cursor, 1); //title $valid_opp_sort_flag = ora_getcolumn($cursor, 2); //CLOB } ....and I get the following error: Warning: Ora_Do failed (ORA-00932: inconsistent datatypes -- while processing OCI function OEXFET) in /direcotry/file.php If I take out the reference to the clob field, my page works fine. Once I add it, it blows-up. Here is how I configured Apache 1.3.12 './configure' '--with-apxs=/staples/apache/bin/apxs' '--with-config-file-path=/shoes/httpd' '--with-oracle=/bob/bobagain/bobapp/oracle/product/8.1.6' Any idea what I am doing wrong? I am using the clob field because I need to store text documents that may be longer than 4000 characters. Thanks, Bob K

« previous php.general (#42989) next »