Insert visibility

[BobGeezer]

We have an OLTP system. Rebooking a "call"
results in two bookings made for delivery.

On one development machine, we see both bookings
by pressing F8 in PL/SQL Developer SQL Window.
This is good.

On another development machine using the same
tnsnames.ora and PL/SQL Developer, only one extra
row is visible until the OLTP application is
stopped. Then the other row appears too.

Can you please tell us if the behaviour is an
error in the OLTP application, or whether it is
simply a development machine / PL/SQL Developer
configuration problem? If so, what might it be?

Thanks in advance,

 

[Marco Kalter]

I can't imagine what could cause this.

 

[dozey]

Hi,

Just an idea, is there a COMMIT anywhere in your solution?

I has this yesterday... inserting records and they were not appearing - I am new to Oracle...and dislike it so far with a passion... but anyway - I put a commit at the end of my statement and then it worked!

SQL may not be a better database, but the ease of use, and information/help online is a lot faster to get to!

Hope this helps and was not just a silly idea

Good Luck!

 

[BobGeezer]

Thanks dozey.

There is a commit. Missing the commit would have
stopped both seeing it I expect.

We have moved on. Perhaps it's something to do
with read snapshot and/or read committed or
something and PL/SQL Developer. This is a minor
concern now.

No further responses required, Ta.