Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by moritz (Cardinal)
on Dec 03, 2013 at 13:57 UTC ( #1065429=note: print w/ replies, xml ) Need Help??


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

I doubt that the code you have shown us hangs. It doesn't use any loop constructs, recursion or IO, which are typically where hangs appear. Also the code you have shown us doesn't have anything to do with the title of your post, or with retrieving anything for a database.

Please show the code that actually hangs, and tell us where it hangs (you can find out by inserting print statements).


Comment on Re: Difference in retrieving values from a varchar2 column and number column from DB
Re^2: Difference in retrieving values from a varchar2 column and number column from DB
by Arun Kumar (Novice) on Dec 03, 2013 at 17:20 UTC

    Actually the script which I am using is very big(nearly 700 lines) to paste. This line comes under multiple while loop and else if statements. I found that this particular statement is producing the issue by giving multiple print statements through the script.

    This was working fine when the column's datatype was NUMBER. When I changed it to VARCHAR2 the script hangs. This is the reason why I named this thread with this title.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (9)
As of 2014-08-21 23:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (144 votes), past polls