Re: Asynchronous Commit in Oracle Database 10g R2


"Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx> wrote in message
news:dfbma4$hg1$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> An example where this is very bad -
> loop
> read value from row in database
> mark row as processed
> use extproc to transfer value to Swiss bank account
> commit;
> 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.

>
>
> --
> Regards
>
> Jonathan Lewis


.

Relevant Pages

  • 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 ...
    (microsoft.public.access.forms)
  • 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 ...
    (microsoft.public.dotnet.languages.csharp)
  • 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 ...
    (microsoft.public.access.conversion)
  • 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. ...
    (microsoft.public.access.queries)
  • 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 ...
    (microsoft.public.excel.worksheet.functions)