1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| SQL> CREATE FUNCTION TEST_PROC
2 (
3 ID IN NUMBER,
4 NAME IN VARCHAR2,
5 CREATION IN DATE,
6 PRICE IN OUT FLOAT,
7 NB OUT NUMBER
8 )
9 RETURN
10 NUMBER
11 IS
12 BEGIN
13
14 NULL;
15
16 END;
17 /
Fonction créée.
SQL> SELECT
2 POSITION "POS",
3 NVL(ARGUMENT_NAME, 'RETURN VALUE') "NAME",
4 IN_OUT "MODE",
5 DATA_TYPE "TYPE"
6 FROM
7 USER_ARGUMENTS a
8 WHERE
9 OBJECT_NAME = 'TEST_PROC' AND
10 DATA_LEVEL = 0
11 ORDER BY
12 POSITION;
POS NAME MODE TYPE
-------- --------------------- ---------- -----------------------
0 RETURN VALUE OUT NUMBER
1 ID IN NUMBER
2 NAME IN VARCHAR2
3 CREATION IN DATE
4 PRICE IN/OUT FLOAT
5 NB OUT NUMBER
6 ligne(s) sélectionnée(s).
SQL> |
Partager