• Someone Not Important (unregistered)

    Hi

    I get this problem when I post this comment.

  • STFU (unregistered)

    comment stuff or something

  • Nallam (unregistered) in reply to Someone Not Important

    Try again at 6 pm...

  • Botia (unregistered)

    NULL

  • Mikoangelo (unregistered)

    This thread is a statistical anomaly.

  • (cs)

    I never thought my cursory knowledge of exactly one phrase in Klingon would ever be helpful.

    Your mother has a smooth forehead!

  • justsomedude (unregistered)

    DBAs do it in transactions.

  • wieczo (unregistered) in reply to Mikoangelo
    Mikoangelo:
    This thread is a statistical anomaly.
    Yep. Something is missing:

    First(or whatever)!

  • KnowOracle (unregistered)

    The article is a WTF. The procedure is absurd; but the arcane message usually means that you are querying a table, and updating it and happily committing the changes while doing so. I won't bore you with the details :-).

    My point is that there can be no relation (pun not intended) whatsoever between ORA-1555, the procedure, and the Irish girl.

    All things considered, I'd have preferred the Irish girl and "T-shirt too tight" to "snapshot too old".

  • (cs)

    PROCEDURE resolve_wtf_by_supplying_good_end ( w_date IN DATE ) IS BEGIN NULL; END;

  • (cs) in reply to Code Dependent
    Code Dependent:
    PROCEDURE resolve_wtf_by_supplying_good_end ( w_date IN DATE ) IS BEGIN NULL; END;
    Shouldn't that be:

    resolve_wtf_by_supplying_good_end ( w_date IN DATE ) IS BEGIN FILE_NOT_FOUND; END;

  • (cs)

    yIDoghQo' naDevvo' yIghoS

  • (cs)

    Whenever I come across this kind of issue where I work, invariably the user INSISTS that it worked just yesterday. Despite me being able to scrape around and find hard proof that the routine has been empty/incorrect for years. I'm always puzzled about what they thought they saw.

  • Philip Newton (unregistered)

    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

  • (cs) in reply to Philip Newton

    If seems that today we are reading qaStaH nuq jay'

  • Anon (unregistered) in reply to Philip Newton
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis

  • JdFalcon04 (unregistered)

    TRWTF is that the error came from "our_form_key_commit_trigger," not the "statistics_and_stuff" procedure.

  • (cs)

    Joe got complicated error message from empty procedure.

  • Worf (unregistered) in reply to Philip Newton

    Yeah, I noticed that.

    I wonder who did the translation?

    Or does Google Translate support Klingon now?

  • Ken B (unregistered) in reply to jetcitywoman
    jetcitywoman:
    Whenever I come across this kind of issue where I work, invariably the user INSISTS that it worked just yesterday. Despite me being able to scrape around and find hard proof that the routine has been empty/incorrect for years. I'm always puzzled about what they thought they saw.
    Typical support conversation:

    Them: I just upgraded from version X.Y to X.(Y+1) and my code doesn't behave like it used to. It used to do [foo] and now it does [bar].

    Us: The code you supplied has always done [bar].

    Them: No, it used to do [foo]. I need it to still do [foo].

    Us: I have tried the code you listed in versions going all the way back to 1.0, and they all do [bar]. Try the code in your old version and if you can duplicate the behavior you describe, send us files to demonatrate.

    Them: Well, the old version now does [bar] just like the new version. I know it used to do [foo], but I can't duplicate it anymore.

  • Jay (unregistered) in reply to Anon
    Anon:
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis

    Every now and then I feel that something I am doing may not be the best possible use of my time, that perhaps I could do something more important with my life than fixing errors in the assignment of status codes on returned products and the like. And then I think of people who have apparently devoted hundreds of hours to learning Klingon grammar.

  • (cs) in reply to Someone Not Important
    Someone Not Important:
    Hi

    I get this problem when I post this comment.

    Then don't post that comment.

  • RoverDaddy (unregistered) in reply to Mikoangelo
    Mikoangelo:
    This thread is a statistical anomaly.

    The anomaly must return to the source to complete the cycle.

    captcha: saepius (holy scotsman?)

  • (cs)
    Not meandering and filling up whitespace to get to a particular wordcount, wasting the reader's time with boring, extraneous detail.

    Unlike some of the articles around here ;)

  • Anonym (unregistered)

    That's what you get when using Twitter for error reporting.

  • Mr. Mackey (unregistered)

    Triggers are bad. Mmmmkay??

  • (cs) in reply to Anon
    Anon:

    Great, now we have Klingon grammar Nazis

    Klingon Nazis?

    shivers

  • Larry (unregistered)

    Joe was clearly barking up the wrong tree. The proc in question was probably stubbed in to support some future capability. There is no WTF here.

  • whatever (unregistered) in reply to amischiefr

    resolve_wtf_by_supplying_good_end ( w_date IN DATE ) IS BEGIN SMEAR_KNOB_CHEESE_ON_THE_WALL; RAPE_JESUS; END;

  • bored (unregistered) in reply to Anon

    LOL,

    They boldly go where no grammar nazi has gone before.

  • (cs) in reply to Jay
    Jay:
    And then I think of people who have apparently devoted hundreds of hours to learning Klingon grammar.
    And then there's another group studying Elvish.
  • (cs) in reply to Anon
    Anon:
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis

    You gotta admit, they'd be far more entertaining than the common-or-garden type.

    "By missing the initial apostrophe you have questioned my family honor. Prepare to invade Poland!"

    (Well, maybe not if you're Polish.)

  • Zapakh (unregistered)
    It started simply.
    Hi
    
    I get this problem when I push this button.
    

    Oh thank goodness there's more text. I thought this was going to be it.

  • Krischan (unregistered) in reply to Ken B

    And sometimes it did [foo] just because some external things changed. And you have to dig deeper (aka restore/recreate an image of the whole system).

    Happened to me just two weeks before. System does not crash in old configuration although exception can be actually caught with catch/try. Does crash hard in new configuration. So ... user was right. Question unsolved but he was right :)

  • BCS (unregistered)

    "Amortization by Defenestrated Capital"

    I love it, money out the window

  • CynicalTyler (unregistered) in reply to Anon
    Anon:
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis
    You haven't lived until you've read Mein Kampf in its original language: Klingon.

  • Roman Kennke (unregistered) in reply to jetcitywoman

    Must be a Schroedinbug then.

  • Roman Kennke (unregistered) in reply to jetcitywoman
    jetcitywoman:
    Whenever I come across this kind of issue where I work, invariably the user INSISTS that it worked just yesterday. Despite me being able to scrape around and find hard proof that the routine has been empty/incorrect for years. I'm always puzzled about what they thought they saw.

    Must be a Schroedinbug then.

  • (cs) in reply to Zapakh
    It started simply.
    Hi
    
    I get this problem when I push this button.
    

    Then don't push that button. NEXT!

  • vaucanson (unregistered)

    @KnowOracle:

    "My point is that there can be no relation (pun not intended) whatsoever between ORA-1555, the procedure, and the Irish girl."

    Oh, come on now: We set Henryk up with her, not telling him that the photo was from St. Patrick's Day 1975. That handles 2/3 of the relation. He asked us for her date of birth, etc., we called stats_n_stuff & got null.

  • (cs) in reply to Anon
    Anon:
    Great, now we have Klingon grammar Nazis
    Wouldn't they be Klingon grammar Romulans?
  • Jason (unregistered) in reply to Anon

    No - we have nazis for Kligon grammer. If we actually had a Klingon grammer Nazis, you'd be dead by now.

  • Sauron (unregistered) in reply to CynicalTyler
    CynicalTyler:
    Anon:
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis
    You haven't lived until you've read Mein Kampf in its original language: Klingon.

    Lies. Everyone knows Mein Kampf was originally written in Black Speech.

  • JoPoser (unregistered) in reply to Jason
    Jason:
    No - we have nazis for Kligon grammer. If we actually had a Klingon grammer Nazis, you'd be dead by now.

    What's Kligon?

    Captcha: "augue" How "Jason" debats his peeling.

  • Anon (unregistered) in reply to Jason
    Jason:
    No - we have nazis for Kligon grammer. If we actually had a Klingon grammer Nazis, you'd be dead by now.

    In that case, you should be eternally grateful.

  • jbrecken (unregistered) in reply to snoofle
    snoofle:
    Klingon Nazis?

    shivers

    No Gagh for you!
  • (cs) in reply to Larry
    Larry:
    Joe was clearly barking up the wrong tree. The proc in question was probably stubbed in to support some future capability. There is no WTF here.
    Yes there is: the lack of a comment to say that it's a stub.
  • (cs) in reply to Sauron
    Sauron:
    Everyone knows Mein Kampf was originally written in Black Speech.
    You mean in “Ebonics”?
  • (cs) in reply to pink_fairy
    pink_fairy:
    Anon:
    Philip Newton:
    I'm impressed that they got the Klingon right.

    (Except for the missing initial apostrophe in {'arlogh Qoylu'pu'}.)

    Great, now we have Klingon grammar Nazis

    You gotta admit, they'd be far more entertaining than the common-or-garden type.

    "By missing the initial apostrophe you have questioned my family honor. Prepare to invade Poland!"

    (Well, maybe not if you're Polish.)

    I find this personal. PREPARE TO DIE AND STUFF!

  • Grassfire (unregistered)

    Initial Developer:
    "This is too hard, no-one's going to ever use it, I'm just going dummy up the report in excel and give them a hardcopy and tell the user it's done."

    (3 years later) User: "Why did this report stop using, it was fine when I used it yesterday"

Leave a comment on “A Statistical Anomaly”

Log In or post as a guest

Replying to comment #253228:

« Return to Article