Oracle - can't see data from tables or views

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

Hi,

we still cannot reproduce the problem. Can you show first half of columns, then second half. If you create a simple table with 1 record, is it showing any data?

Best regards,
Viljem

Hi Viljem,

Did what you asked and no data is showing...

On the second test, I created a new table TABLE1 with one column COLUNM1 and inserted two records.

Record count shows 2 records but no data is displayed on the grid.

Could this be related with charsets or Oracle NLS?

JMDias

By the way, the new table is as simple as it can be:

desc table1
Name Null Type

---

---

---

COLUMN1 VARCHAR2(20)
1 rows selected

Contents of the 2 records are:

Record1
Record2

Update:

Just tried with one table TABLE2 with one field COLUMN1 Varchar2(20)an one single record "Reg01".

The resulting grid still shows no results.

Hi,

We are trying to troubleshoot this issue but could use some help from you.

I kindly ask for directions into debuggind this.

JMDias