Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0004224 [Quercus] block always 09-24-10 09:11 09-24-10 09:11
Reporter ryagatich View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 4.0.8
Summary 0004224: Cannot retrieve VARCHAR/VARCHAR2 columns from Oracle 11g database
Description Sample Code:

$queries = Array("select cast('hello' as varchar2(100)) as a from dual",
                 "select cast('hello' as char(100)) as a from dual");
$dbh = oci_pconnect($u, $p, $s);
foreach ($queries as $query) {
   print "" . $query . "
";
   $stmt = oci_parse($dbh, $query);
   if (oci_execute($stmt)) { 
       while ($row = oci_fetch_object($stmt)) { 
          print_r($row);
       }
   }
   oci_free_statement($stmt);
   print "


";
}
oci_close($dbh);

From the above, the first query reported returns a null string for the value "A", whereas the second query reports "hello" for the value "A".

Expected results: "hello" is returned in both instances.

Other tests against this same set of queries have been performed in the following manner:
   a) Using "php" brand php from the command line <-- works
   b) Using Quercus CLI (com.caucho.quercus.CliQuercus) <-- fails
   c) Using pure Java implementation of "oracle.jdbc.xa.client.OracleXADataSource" <-- works
   d) Using pure Java implementation of oracle.jdbc.driver.OracleDriver <-- works
   e) Using Quercus deployed via Weblogic Application Server <-- fails

By "works", I mean that the string "hello" is reported in both instances.
   
Additional Information This is actually one of many issues we are having connecting to our Oracle (i.e. honoring of tnsnames.ora), and seems that we are missing any relevant documentation pertaining to such installation. We're willing to accept not having various settings correct in our environment, but do need to have a clear understanding of how to execute this detail.
Attached Files

- Relationships

There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
09-24-10 09:11 ryagatich New Issue
09-24-10 09:12 ryagatich Issue Monitored: ryagatich


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
27 total queries executed.
24 unique queries executed.
Powered by Mantis Bugtracker