Re: (2)no select statement output in svrmgr30 or on ASP page but in T.O.A.D it works

Alistair Thomson wrote:

> are you performing a commit after inserting the row?
>
> Alistair
>
> "Hakan Jakobsson" <hakan_at_lge.com> wrote in message
> news:4f31a2dc.0210110238.5cdc6298_at_posting.google.com...
> > for backroung read "post no select statement output in svrmgr30 or on
> > ASP page but in T.O.A.D it works"
> >
> > Now it's the other way around (svrmgr30 and TOAD)
> > but i still get nothing on the ASP page
> > i inserted a row using svrmgr30 and there i could select ang i get the
> > same data out that i inserted but if i do the same select in T.O.A.D i
> > do not get anything there the tabel is empty, but if i insert a row in
> > T.O.A.D i can select that ro but it doesnt show in svrmgr30. and there
> > is still nothing on webpage from that table from the other table i get
> > the same out put on web, TOAD and svrmgr30. Are there two databases
> > with same name? or two tables with same name? - No! i checked in
> > schema manager and there is only one tablea with that name and only
> > one db with that name... so how can this be?
> > Hakan Jakobsson

You should not be doing anything in svrmgr30 ... Period ... that does not involve being logged on as internal and managing the database. There is no rational reason for doing what you appear to be doing so please stop it. Create a user account, build your schema where you should be working (not as SYS or SYSTEM or INTERNAL).

Now to your question. Lets see ...

No hardware platform.
No operating system.
No Oracle version or edition
No SQL
No indication that a commit was ever performed following the insert.

First test anything you do using SQL*Plus before attempting to use ASP or any other tool.

How much help do you expect?

Daniel Morgan Received on Fri Oct 11 2002 - 10:15:07 CDT