PL/SQL (MOSC)

MOSC Banner

ORA-01422

in PL/SQL (MOSC) 11 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center