Re: No data with select

How simple could it be...

thanks it works!!

Greets,
Thijs

Gints Plivna schreef:

> 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:39:42 CDT