Same experience just end of last week and beginning of this week: I wasted at least 4 to 4.5 days on a PL/SQL script (a rather simple one, about I would say 300 lines of code) that just stubbornly refused to do what I wanted (I could have made the script in 3 to 4 hours, perhaps even less, in Perl using DBI, but the client did not want that, they insisted on me using PL/SQL, a language that I have used not very much, and it was at least 5 years ago the last time I used it). I stumbled for days on a really stupid problem, namely that if an exception is raised by Oracle (say "no data found"), then the rest of the code of the procedure if not executed, even if you do what is needed to manage the exception. I did not know that, or had forgotten, and did not have a coworker who could help me, we are not using PL/SQL regularly. And it took me ages of debugging time, printing out variables values every other instruction, before I understood what was going wrong. Yes, I was really getting frustrated and angry at not being to solve the problem, but the upside is that I was so happy yesterday when I finally found the solution that I now almost feel good about the whole anecdote. Sorry it that sounds slightly off-topic, my example is not Perl, but I think that you sometimes have these problems and it is good to share about them.

In reply to Re^3: parsing json, problem with encodings by Laurent_R
in thread parsing json, problem with encodings by kimlid2810

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.