Hello all,
I met a strange scenario which throw No_data_found exception in function, but actually, it has result.
I create a function to fetch a view as picture 1. I called the function from another function, and it return ‘No_Data_Found’ as picture 2 shows
picture 1
picture 2
But I double-check the query by sql developer, it has result as below picture.
I don't know why and very strange, if someone met the same situation.
I think I need to plus more information about the scenario.
I have a table WA, and a view V_WA.
In FUNCTION1, insert new data into WA, then call FUCNTION2.
In FUNCTION2, I need to SELECT V_WA, but throw ‘NO_DATA_FOUND’.
I don't know if clearly, pls let me know if any .