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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to