Record Lock in Oracle

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Record Lock in Oracle

    We wanted to lock the record for update and wanted to consider which lock to be used <CFLOCK> Or Oracle Select lock for update? Experts please advise.

    Thanks
    CFRAM Guest

  2. Similar Questions and Discussions

    1. Oracle Database Lock Issue
      Hi, I have a SQL statement that I execute obn Oracle 9i Database: select lnum from parolee Where lNUM='#trim(UCase(Form.fnum))#' FOR UPDATE...
    2. Stop adding record in subform after record count = 1
      Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the...
    3. Adding a new record when the record source is a query.
      Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick...
    4. Lock record
      I have a master(Order) and a details(Items) table. I need to lock a record from master table when select it and check if another one have locked it...
    5. Releasing a Record Lock
      I have Filemaker Pro 5, Server, running our database. Currently what is happening is the 1st user will make a modification, finish, and then leave...
  3. #2

    Default Re: Record Lock in Oracle

    When a DB lock is available, it is always better than CFLOCK.
    MikerRoo Guest

  4. #3

    Default Re: Record Lock in Oracle

    can somebody send me a sample code or point me to article that has sample to implement <cflock> for db update.

    Thanks
    CFRAM Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139