Just forget the above code, it is rather useless
My head is certainly not working well today (o:

Ok, to be simplier. I just put the relevant info here. Both SQL statement are prepared_cached, but only the second one is working...
I also tried to add code to track down error message, but nothing is returned )o;
I bet the solution is silly as hell, but I can't find it... maybe need some rest (o;{{ 
    $sth_imei = $dbh->prepare_cached(<<__EOSQL__); 
SELECT imei 
FROM imei_period 
WHERE (mobile_number = ?) AND 
      (account_no = ?)
__EOSQL__

    $sth_acc = $dbh->prepare_cached(<<__EOSQL__);
SELECT customer.password, 
       to_char(max(ar_open.bill_date),'DD.MM.YYYY') 
FROM customer, ar_open 
WHERE (customer.account_no = ar_open.account_no) AND 
      (customer.account_no = ?) 
GROUP BY customer.password,
         to_char(sysdate,'DD.MM.YYYY'), 
         to_char(sysdate,'HH24:MI:SS')
__EOSQL__

# [..]

$sth_imei->execute($rec[1],$rec[0]);
@imei = $sth_imei->fetchrow_array;
print "IMEI : @imei\n";
# This does not return anything )o;

$sth_acc->execute($rec[0]);
@acc = $sth_acc->fetchrow_array;
print "ACC : @acc\n";    
# This one works fine

[download]

In reply to Code useless, forget it... this is more usefull (o; by Anonymous Monk
in thread prepare_cached for DBI::Oracle by Anonymous Monk

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.