Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access "magic" -- invisible Oracle rows?
As stated, the 'commit' is the key.... but it need not be explicitly entered - the next 'select ..... from sametable' will do a commit before the select....( so will exiting SqlPlus )
John Greco
OracleDBA ( Netware 4.11,Oracle 7.3)
Reply to newsgroup or john.greco_at_dot,state.mn.us
cybersaurn_at_aol.com (CyberSaurn) wrote:
>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