Oracle CLOB and PHP
| From: | Bob Kakalec | 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