Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^2: Difference in retrieving values from a varchar2 column and number column from DB

by Arun Kumar (Novice)
on Dec 03, 2013 at 13:37 UTC ( #1065422=note: print w/replies, xml ) Need Help??


in reply to Re: Difference in retrieving values from a varchar2 column and number column from DB
in thread Difference in retrieving values from a varchar2 column and number column from DB

Thanks for the quick reply

I am not getting any error message. I am running the script through cron job which simply hangs after 5 to 10 seconds and at that time the CPU usage goes to 99.9 for this process.

I tried removing the double colon in between IP and $row_ip->{IP}, but ended with same issue

  • Comment on Re^2: Difference in retrieving values from a varchar2 column and number column from DB

Replies are listed 'Best First'.
Re^3: Difference in retrieving values from a varchar2 column and number column from DB
by hdb (Prior) on Dec 03, 2013 at 13:54 UTC

    What I would try:

    Run the script from the command line.

    Run a simple script like this:

    my $obj = new MyPackage::NetAddr::IP('10.10.10.10', '255.255.255.255') +;

    with an IP address from your sample.

    Add a print statement to the sub new and re-run the simple script.

      Sorry, I am a newbie for perl. I do not know how to access packages from command line scripts. Could you please give me an idea to do this.

        What I wanted to say is to run the script directly, rather than from cron. Like perl script.pl on the command line.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1065422]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2016-09-30 21:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (574 votes). Check out past polls.