You have nested single quotes (')s

I'm sorry I don't currently have access to a database to test this against, but I believe this should work: 

my $sth = $dbh->prepare(q~
    select
        smt.uniqueid, smt.creationtime, att.name, att.val, gsm.msisdn
    from
        dagenericsmt smt, dagenericsmtattribute att, dagsmproduct gsm
    where smt.uniqueid = att.genericsmt_uniqueid
        and smt.product_uniqueid = gsm.uniqueid
        and smt.smtstatus=2
        and smt.smtcommand=3
        and att.name in ('GSM/Cur/IMSI','GSM/Rpl/IMSI')
        and smt.acktime is null order by smt.uniqueid
~)

[download]
Also - when you're posting code - if you use <code> ... </code> tags around the code it will format it correctly for you and make it downloadable.

It's also easier for us (and you) to read if you can split it up and indent it some logical way. :o) Update: (like dragonchild's *beautiful* example below - definitely gets my ++!)

In reply to Re: problems with DBI and am oracle statement by serf
in thread problems with DBI and am oracle statement by Alex_T2

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.