In a function, you must declare a return datatype.
The return datatype can be any datatype allowed by Oracle, such as
- CHAR
- VARCHAR2
- NUMBER
- INTEGER
- DATE
- BOOLEAN (true/false values)
- TABLE
- RECORD
SQL>
SQL> CREATE OR REPLACE PACKAGE valerr
2 IS
3 FUNCTION get RETURN VARCHAR2;
4 END valerr;
5 /
Package created.
SQL> CREATE OR REPLACE PACKAGE BODY valerr
2 IS
3 v VARCHAR2(1) := 'abc';
4
5 FUNCTION get RETURN VARCHAR2
6 IS
7 BEGIN
8 RETURN v;
9 END;
10 BEGIN
11 dbms_output.put_line ('Before I show you v...');
12
13 EXCEPTION
14 WHEN OTHERS
15 THEN
16 dbms_output.put_line ('Trapped the error!');
17
18 END valerr;
19 /
Package body created.
SQL>
SQL>
SQL>