How to take control from exception section to the body... [message #275307] |
Fri, 19 October 2007 06:50  |
vishalvinayak
Messages: 1 Registered: October 2007
|
Junior Member |
|
|
My problem is:
Suppose a table has a column name 'code' with values
code
-------
113
1124
543
6546
786
333
6646
553
Now suppose i've to pass a 10 digit number to a function
whose initial 3 or 4 (or may be 5) digits are similar to one of the rows of the column...........
eg:
a given number is 11345646
i'll first search it in the table---not found???
i'll trim the last digit and find again...not found??
repeat until found......
the number found in the end needs to be returned..
now the problem is if i use sql%notfound in a loop the control jumps to the exception section.......
SO ANYONE HAS ANY SOLUTION??????
|
|
|
|
|