Re: 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).

Perl 6 - the future is here, just unevenly distributed

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

Replies are listed 'Best First'.
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.	[reply]

Replies are listed 'Best First'.

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.

[reply]