Wednesday, July 27, 2011

one case for sqlexception with msg NO Data

while writing PLSQL in store procedure ,if we use select column_name into variable where bla,bla statement,if it returned resultset is empty, then it will throw sqlexception with error massage says that "no data",best solution is that check existence of the records before use select into.

No comments:

Post a Comment