Re: Access "magic" -- invisible Oracle rows?

From: Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
Date: 1997/12/15
Message-ID: <Fh0P3DAsWRl0MwDg@camk.demon.co.uk>#1/1

In article <19971213135600.IAA17295_at_ladder02.news.aol.com>, CyberSaurn <cybersaurn_at_aol.com> writes
>
>I ran the error-free stored procedure in SQL*Plus. It completed successfully
>(no errors). Viewing the table in Access, it was empty (Huh?). I tinkered about
>for a while rerunning things and scratching my head, wondering what was wrong,
>as I couldn't see an error in my procedure or table definition. During this
>process, I selected * from the table in SQL-Plus. Voila! Rows! Ahha! Fluky
>Access/ODBC! I'm used to this! Time to "Do the Drill"....

Too obvious to be true, but...

Did you COMMIT after running the procedure in SQL*Plus? Until you did so, only that session would see the new data...

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG

Received on Mon Dec 15 1997 - 00:00:00 CST