How to change run status in Oracle DB (i.e.  done -> failed)

• First you need to get the oprid (which is a unique number for each run processing entry in oracle)
  ../bin/$BFARCH/OprCmd.pl -iQuery runinfo <runnumber>
  the output will look like:
  connection failed
RUN -> 45179 RELEASE -> 14.3.0b    STATUS -> processing VERSION -> 0 OPRID -> 81287 PROCTYPE -> Calibration
RUN -> 45179 RELEASE -> 14.3.2     STATUS -> done VERSION -> 1 OPRID -> 81459 PROCTYPE -> Processing
  you can ignore the 'connection failed' message.
  Here we want to change the PC pass entry to 'failed' instead of 'processing', so the oprid we want is: 81287
• Now we make the change:
  ../bin/Linux24RH72_i386_gcc2953/OprCmd.pl -iQuery setstatusflag <OPRID> failed
  where you supply OPRID not the run number. The output will look like:
  connection failed
updated
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().
• check that all is ok:
  ../bin/$BFARCH/OprCmd.pl -iQuery runinfo <runnumber>
  connection failed
RUN -> 45179 RELEASE -> 14.3.0b    STATUS -> failed VERSION -> 0 OPRID -> 81287 PROCTYPE -> Calibration
RUN -> 45179 RELEASE -> 14.3.2     STATUS -> done VERSION -> 1 OPRID -> 81459 PROCTYPE -> Processing