We can remove those lines($ora_errstr="";) but it needs lot of effort.

How much effort is it to do this? 

 perl -i.bak -pe 's/(\$ora_errstr="";)/\# $1/' *.pl

[download]
That assumes all your perl script files have a ".pl" extenstion; if that's not the case, just create a simple plain-text list of the names of the script files to be edited, and do it like this: 
 xargs perl -i.bak -pe 's/(\$ora_errstr="";)/\# $1/' < file.list

[download]
(xargs is a standard unix tool; it you're using ms-windows, just get one of the windows ports of unix tools)

Of course, it sounds like a more profound rewrite might be in order, to get away from the old oraperl paradigm, but just removing the offending line from your scripts might get things running well enough that stuff will work while you hammer out the next version of your code.

In reply to Re^5: perl DBI special variable problem by graff
in thread perl DBI special variable problem by renu

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.