clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36293 in the last week).

select * from V$VERSION;
BANNER
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
 hidden batch(es)


create or replace type rec force is object ( id number, code varchar2(16 char), status varchar2(32 char)); /
 hidden batch(es)


create or replace type statuses is table of rec; /
 hidden batch(es)


declare sts statuses := statuses (); begin sts := statuses ( rec (1, 'ERROR', 'Ошибка запроса'), rec (2, 'FATAL', 'Ошибка непонятная')); for i in 1..sts.count loop dbms_output.put_line ('id='||sts(i).id||' code='||sts(i).code||' status='||sts(i).status); end loop; end; /
1 rows affected dbms_output: id=1 code=ERROR status=Ошибка запроса id=2 code=FATAL status=Ошибка непонятная
 hidden batch(es)