Greetings.

I'm having problems when I try to retrieve *char values from Oracle 8.1.7. I'm trying with a script that I've made and even with the examples from php.net and nothing seems to work. I always receive the same message from Oracle (see the title).

The strange thing is that this only happens with string-types (char, varchar, etc). If I try to retrieve a date or a number it works ok.

If I try it with other languages than PHP it also works.

Here is an example script - you can see it's the same from PHP docs:

<?php
    $user = "foo";
    $pass = "bar";
    $tns  = "my_db";
    
    $conn = ociplogon($user,$pass,$tns) or die("Connection error");
    
    $query = sprintf("SELECT NAME FROM xyz");
    
    $stmt = ociparse($conn,$query);
    
    ociexecute($stmt); // Here's where the error occur
    
    while(ocifetch($stmt))
    {
        echo ociresult($stmt);
    }


    ocilogoff($conn);
?>

If I replace "NAME" by "COD" (an int field) it works fine.

I've also saw dozens of posts in PHP communities relating directly to the same problem I'm having.

Is this a bug? If it is when it will be fixed?

If it's not you should at least post the solution on the FAQ, since there are many developers having this problem.

Thanks in advance,

Er Galv?o Abbott
 Informa Brasil