I wanted a centralized example of how to read multiple rows using SQL, into an RPG host variable when one of its columns was also an array. We think of reading multiple rows into a data structure as ...

You can fetch a single row into variables in PL/SQL with SELECT column(s) INTO variable(s) FROM ... Amy Simpson-Grange explains common errors this raises including ORA-01422: TOO_MANY_ROWS - query ...