... In Oracle PL/SQL, an error 1403 is raised: SQL> -- SQL> drop table t; Table dropped. SQL> create table t(dummy int); Table created. SQL> declare 2 x varchar2(1); 3 -- l text; 4 l varchar2(40); 5 status integer; 6 high integer := 10; 7 begin 8 dbms_output.enable(); 9 for i in 1..high loop 10 select dummy into x from t; 11 dbms_output.put_line(to_char(i)); 12 end loop; 13 for i in 1..high loop 14 dbms_output.get_line(l, status); 15 -- raise notice 'i=% l=%', i, l; 16 end loop; 17 end; 18 / declare * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 10 Help: https://docs.oracle.com/error-help/db/ora-01403/ ... In IvorySQL PL/ISQL, no error has raised and the target output variable is NULL (like in PL/PGSQL): $ cat t1.sql drop table t; create table t(dummy int); -- PLI/PGSQL declare x varchar2(1); l text; status integer; high integer := 10; begin dbms_output.enable(); for i in 1..high loop select dummy into x from t; dbms_output.put_line(to_char(i)); end loop; for i in 1..high loop dbms_output.get_line(l, status); raise notice 'i=% l=%', i, l; end loop; end; / $ psql -p 1521 -f t1.sql DROP TABLE CREATE TABLE psql:t1.sql:22: NOTICE: i=1 l=1 psql:t1.sql:22: NOTICE: i=2 l=2 psql:t1.sql:22: NOTICE: i=3 l=3 psql:t1.sql:22: NOTICE: i=4 l=4 psql:t1.sql:22: NOTICE: i=5 l=5 psql:t1.sql:22: NOTICE: i=6 l=6 psql:t1.sql:22: NOTICE: i=7 l=7 psql:t1.sql:22: NOTICE: i=8 l=8 psql:t1.sql:22: NOTICE: i=9 l=9 psql:t1.sql:22: NOTICE: i=10 l=10 DO $ I would like to know if this is intended behavior ? Thanks.