add
remove
language
chart
show hidden
hide
db<>fiddle
Db2
DocumentDB
DuckDB
Firebird
MariaDB
MySQL
Oracle
Postgres
Redis
SQL Server
SQLite
TimescaleDB
Valkey
YugabyteDB
11.1
11.5
12.1
0.114 (MongoDB 7.0)
0.116 (MongoDB 7.0)
1.4 LTS
2.0 LTS
3.0
4.0
5.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
10.11
11.4
11.8
12.3
5.5
5.6
5.7
8.0
8.4
9.7
11g Release 2
18c
21c
23c
23ai
26ai
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
17
18
19 RC 2
8.10
2012
2014
2016
2017 (Linux)
2017
2019 (Linux)
2019
2022
2025
3.8
3.16
3.27
3.39
3.45
3.53
2.11
2.14
2.28
9.1
2.6
2.8
2.18
2024.2 LTS
2025.2 LTS
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
Sakila
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
HR
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
db<>fiddle Statistics
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
abort
markdown
clear
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE PACKAGE package_name AS TYPE REF_TYPE_NUM_TABLE IS TABLE OF NUMBER; TYPE REF_VARCHAR2_ARRAY_TABLE IS TABLE OF VARCHAR2(1); PROCEDURE SP_INNER( PARAM1 NUMBER, PARAM2 NUMBER, V_REF_CURSOR OUT SYS_REFCURSOR ); PROCEDURE OUTER_SP( PARAM1 NUMBER, PARAM2 NUMBER, P_REF_ID_LIST SYS.ODCINUMBERLIST ); END; /
CREATE PACKAGE BODY package_name AS PROCEDURE SP_INNER( PARAM1 NUMBER, PARAM2 NUMBER, V_REF_CURSOR OUT SYS_REFCURSOR ) IS BEGIN OPEN v_ref_cursor FOR SELECT 1, 'A' FROM DUAL; END; PROCEDURE OUTER_SP( PARAM1 NUMBER, PARAM2 NUMBER, P_REF_ID_LIST SYS.ODCINUMBERLIST ) AS V_SUCCESSFUL_COUNT NUMBER; V_RESPONSE_CODE VARCHAR2(10); V_SUCCESSFUL_COUNTS REF_TYPE_NUM_TABLE := REF_TYPE_NUM_TABLE(); /* Cumulative Successful Counts */ V_RESPONSE_CODES REF_VARCHAR2_ARRAY_TABLE := REF_VARCHAR2_ARRAY_TABLE(); /* Cumulative Response Codes */ V_REF_CURSOR SYS_REFCURSOR; /* Result from each inner SP */ BEGIN FOR i IN 1 .. P_REF_ID_LIST.COUNT LOOP SP_INNER(PARAM1, PARAM2, V_REF_CURSOR); /* Add V_SUCCESSFUL_COUNT, V_RESPONSE_CODE outputs from this call to collections */ FETCH V_REF_CURSOR INTO V_SUCCESSFUL_COUNT, V_RESPONSE_CODE; V_SUCCESSFUL_COUNTS.EXTEND; V_SUCCESSFUL_COUNTS(V_SUCCESSFUL_COUNTS.COUNT) := V_SUCCESSFUL_COUNT; V_RESPONSE_CODES.EXTEND; V_RESPONSE_CODES(V_RESPONSE_CODES.COUNT) := V_RESPONSE_CODE; CLOSE V_REF_CURSOR /* Error here! */; END LOOP; FOR i IN 1 .. V_SUCCESSFUL_COUNTS.COUNT LOOP DBMS_OUTPUT.PUT_LINE(V_SUCCESSFUL_COUNTS(i) || ' - ' || V_RESPONSE_CODES(i)); END LOOP; END; END; /
BEGIN DBMS_OUTPUT.ENABLE(); package_name.OUTER_SP(3.141, 42, SYS.ODCINUMBERLIST(1,2,3)); END; /
1 rows affected dbms_output: 1 - A 1 - A 1 - A
SELECT * FROM USER_ERRORS;