Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access "magic" -- invisible Oracle rows?
Andy Hardy wrote:
>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...
And Matthias Gresz wrote:
>All you got to do is to commit your work in SQL*PLUS. All changed you
>made will only be seen by your SQL*PLUS-session until you issue COMMIT.
Well, I'd own up to having egg on my face for asking the obvious only in this case I'll claim the ignorance of the over-worked and under-educated (*grin*). I'll have to study up on SQL*Plus in general, but in specific on its behavior with regard to COMMITs. I was assuming an autocommit upon successful completion of the procedure (that pesty DB2 background, you know? <g>) Thanks to all respondents for your help and kind patience! Received on Wed Dec 17 1997 - 00:00:00 CST