|
SQL> CREATE OR REPLACE TYPE list IS TABLE OF NUMBER;
2 /
Type created.
SQL>
SQL> CREATE OR REPLACE FUNCTION format_list(set_in LIST) RETURN VARCHAR2 IS
2 returnValue VARCHAR2(2000);
3 BEGIN
4 IF set_in IS NULL THEN
5 dbms_output.put_line('Null');
6 END IF;
7 RETURN returnValue;
8 END format_list;
9 /
Function created.
SQL>
|