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]