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

[moritz]

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

[Arun Kumar]

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.