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