I see this in the trace output: 
 -> prepare for DBD::Oracle::db (DBI::db=HASH(0x9b82ad8)~0x9b82b20 'in
+sert into swma_temp_table
(m_serial,m_start,m_end,m_stat,m_product)
select '10-641CH',to_date('2008-11-21', 'YYYY-MM-DD'),to_date('2011-07
+-31', 'YYYY-MM-DD'),'Active','694275O'
from dual 
where exists (select NULL from servers where host_serial='10-641CH')
') thr#999c008
    dbd_st_prepare'd sql INSERT (pl1, auto_lob1, check_sql1)
    dbd_describe skipped for INSERT
    <- prepare= DBI::st=HASH(0x9c5a8dc) at ./get_swma.pl line 57
    -> execute for DBD::Oracle::st (DBI::st=HASH(0x9c5a8dc)~0x9c558a8)
+ thr#999c008
   dbd_st_execute INSERT (out0, lob0)...
Statement Execute Mode is 32 (COMMIT_ON_SUCCESS)
    dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0)
    <- execute= 1 at ./get_swma.pl line 59
    -> STORE for DBD::Oracle::st (DBI::st=HASH(0x9c558a8)~INNER 'Trace
+Level' 4) thr#999c008
    STORE DBI::st=HASH(0x9c558a8) 'TraceLevel' => 4
    <- STORE= 1 at ./get_swma.pl line 60
    -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x9c558a8)~INNER) thr
+#999c008
    <- DESTROY= undef at ./get_swma.pl line 38 via  at ./get_swma.pl l
+ine 38

[download]

In reply to Re^2: Oracle Insert with DBI by simply seth
in thread Oracle Insert with DBI by simply seth

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.