Re: Asynchronous Commit in Oracle Database 10g R2
"Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx> wrote in message
> An example where this is very bad -
> read value from row in database
> mark row as processed
> use extproc to transfer value to Swiss bank account
> end loop;
> If the database crashes, you could be in a position where
> the extproc has sent the funds, but the committed change
> was not written into the redo log FILE. When the database
> restarts, you have repeat a couple of transfers.
> As soon as you are able to get a message out of the black
> box that is the database (in this case pl/sql) call, you have
> the ability to detect a commit that is not recoverable.
Thanks for your comments.
> Jonathan Lewis
- Re: RunCommand acCmdRecordsGoToNext
... Another thing that may come in handy if that doesn't is to loop through the ... The database I am utilizing this ... increasing intRecordCount on each loop. ... Dim strPassword As String ...
- Re: Sql Connection
... ..i dont like the code either....again a example of a loop ... making calls to the database .... ... what i did yesterday is just get the parsed data to a temp table on the ... the question is the open connection where the Datareader is used insid ...
- Re: Converting from Access to SQL2k via Excel- HELP!!!!!
... Then create a new query and paste the following into its SQL ... > In your database you'd need to start with a query that ... The function that you pointed me to allows me to concatenate all ... The problem that I have is that I need to put it into a loop ...
- Re: View contents of a folder
... For example, if your backup files are located on your D drive, in the backup ... to loop through that directory looking for other files that match the ... allows you to copy the backup file over your backend database, ... >> Folder browser and let you select a file via that mechanism. ...
- Re: How to Delete Rows in Excel In a Do Loop
... have to delete there are some that have a entry in each and every cell ... Richard Buttrey wrote: ... time you go through the loop. ... Now copy this formula down column A for the whole database ...