ORA-01422
For a 19c database, I have this question: ORA-01422 ( " fetch returns more than requested number of rows " ) is raised for a known, simple query.
All I want to do is: at the moment this error is raised, I wish to capture the full query of all data of the select statement. I don't want a count of the data records, I want all the actual data.
I'm posting in the PL/SQL thread, because I know the causing query is written in a PL/SQL block. It might not have been, and then the answer could be different, but I know the code is in a PL/SQL package already. And, because of the error being thrown, I know the error is NOT caught already.