CREATE TABLE plsqlpuzzle (n NUMBER)
Table created.
CREATE OR REPLACE PROCEDURE plsqlpuzzle_proc
IS
r plsqlpuzzle%ROWTYPE;
TYPE r_t IS TABLE OF plsqlpuzzle%ROWTYPE
INDEX BY PLS_INTEGER;
t r_t;
BEGIN
SELECT * INTO r FROM plsqlpuzzle;
DBMS_OUTPUT.put_line (r.n);
DBMS_OUTPUT.put_line (t (1).n);
END;
Procedure created.
EXEC plsqlpuzzle_proc
ORA-01403: no data found ORA-06512: at "SQL_KDYSSIWMJUUKRKCCAAPOTJSTG.PLSQLPUZZLE_PROC", line 10 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-00100