Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No data with select

Re: No data with select

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 31 Jul 2006 02:06:57 -0700
Message-ID: <1154336817.354847.31400@s13g2000cwa.googlegroups.com>


Thijs wrote:
> Hello,
>
> I'm new to Oracle, so it's may-be a simple question...
>
> I've created a table, and inserted some records. In SQL*Plus, a SELECT
> statement shows me the records in the table.
>
> But when I try to get these records with an odbc connection, i've got
> an empty recordset.
> I've maded the table in the example SCOTT schema. Selecting data from
> the other tables (bonus, dept, emp, salgrade) via odbc works well.
>
> Also, when I logged in as sys in the enterprise manager, and I go to
> Database -> Tables and then 'view data', with my own table, i don't get
> results, but the example tables shows the right recordset...
>
> Has it something to do with the 'last analyzed' option? This is empty
> for my own table, and the 'rows' column (in te enterprise manager) is
> also empty...
>
> i work with oracle 10g.
>
> Anyone any idea?
> thanks in advance,
> Thijs

Have you issued COMMIT? ;)

Gints Plivna
http://www.gplivna.eu Received on Mon Jul 31 2006 - 04:06:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US