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