Oracle PHP CHAR() datatype retrieval

[Anon]

When I try to retrieve from Oracle 8.0.6 a field that has a CHAR() datatype with PHP, my result set returns only NULL values. I can retrieve the NUMBER and DATE fields from the same table just fine. I can retrieve VARCHAR2 fields from other tables too. Just the CHAR datatype returns NULL. Any help would be greatly apreciated. Thanks

[pranav]

Try to give what u are querying and how u are retriving.

[Anon]

I use this. and it works, except when retrieiving a CHAR([0-9]) field
$db = \"(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))(CONNECT_DATA = (SID=fmep)))\";

    $c1 = ocilogon(\"login\", \"pw\", $db);

    $stmt = ociparse($c1, \"select ACT_TOT from ROOT.AE_P_PRO_E\");
    ociexecute($stmt, OCI_DEFAULT);

    echo $c1.\"----selecting\\n\\n\";
    while (ocifetch($stmt))
            print ociresult($stmt,\"ACT_TOT\").\"\\n\";