Re^2: 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 (Monsignor) 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') +;` [download] with an IP address from your sample. Add a print statement to the `sub new` and re-run the simple script.	[reply] [d/l] [select]
Re^4: Difference in retrieving values from a varchar2 column and number column from DB by Arun Kumar (Novice) on Dec 03, 2013 at 17:34 UTC
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.	[reply]
Re^5: Difference in retrieving values from a varchar2 column and number column from DB by hdb (Monsignor) on Dec 03, 2013 at 20:05 UTC
What I wanted to say is to run the script directly, rather than from cron. Like `perl script.pl` on the command line.	[reply] [d/l]