why do JDBC queries only recognize data populated by JDBC and not through SQLPlus*Worsheet?

From: Slim <slim_at_cs.stanford.edu>
Date: 2000/02/17
Message-ID: <88gj9a$r8v$1@nntp.Stanford.EDU>#1/1

I execute the query:

select * from <table>

SQL worksheet returns:

   ANN_ID ANN_NAME                       ANN_DESC

ANN_EMAIL
--------- ------------------------------ ------------------------------ ----

---

        1 tic                            tac                            toe
        2 a                              b                              c
        3 x                              y                              z
        4 f                              g                              h
       10 f                              g                              h

JDBC returns:

   ANN_ID ANN_NAME                       ANN_DESC

ANN_EMAIL
--------- ------------------------------ ------------------------------ ----

---

       10 f                              g                              h

ann_id 10 was inserted using JDBC, ann_id 1-4 were inserted using SQL worksheet.

why does this happen?

slim. Received on Thu Feb 17 2000 - 00:00:00 CST