I'm experiencing similar problems as stated on this post www.toolsjx.com/support/2-installation/3...t-cant-see-real-data
Sent email to This email address is being protected from spambots. You need JavaScript enabled to view it. but still no answer. I'm posting here now, hoping for an answer.
I can connect to the remote Oracle server and retrieve tables and views from the drop down list, but no data is displayed. There is a record count that shows the correct number of records on the table or view but the grid output remains empty.
If I choose a table from the local MySQL server, the grid works as expected.
Connecting with sqlplus from the web server works as expected: data is retrieved.
It is not definitely a PHP or OCI8 issue. I've run this script with success against both 9i and 10G Oracle servers:
<?php
$conn = oci_connect("user", "password", "hostname/servicename");
if (!$conn) {
$m = oci_error();
echo $m["message"];
exit;
}
$stid = oci_parse($conn, "select * from v_previsoes_chegada");
oci_execute($stid);
echo "<table border='1'>";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo "<tr>";
foreach ($row as $item) {
echo "<td>".($item!==null?htmlentities($item):" ")."</td>";
}
echo "</tr>".PHP_EOL;
}
echo "</table>";
oci_free_statement($stid);
oci_close($conn);
?>
Found another post with similar issue: www.toolsjx.com/support/2-installation/541-grid-not-showing But we don't use special characters on table or view names.
Help will be appreciated.
Web Server:
CENTOS 5.4 i386 no GUI
APACHE 2.2.3
PHP 5.3.6RC3
OCI8 1.4.5
MySQL 5.5.1
MySQLi 5.1.54
Joomla 1.5.22
Table JX 1.5.8
Remote Oracle Servers:
Oracle 9i Enterprise 9.2.0.4.0
Oracle 10g Enterprise 10.2.0.4.0
View structure:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
SQL> desc jup.v_previsoes_chegada;
Name Null? Type
ORIGEM VARCHAR2(403 CHAR)
CONTRAMARCA VARCHAR2(20 CHAR)
CAPACIDADE_TEUS NUMBER(38)
IMO VARCHAR2(7 CHAR)
NAVIO NOT NULL VARCHAR2(200 CHAR)
TIPO_NAVIO NOT NULL VARCHAR2(200 CHAR)
AGENTE NOT NULL VARCHAR2(100 CHAR)
ETA VARCHAR2(16)
ESCALA NOT NULL VARCHAR2(50 CHAR)
SQL>
Best regards,
JMDias
