Kelime Seçme Ayırma IN , OUT , IN OUT kullanımı

Metindeki kelimeleri ayirmak için örnek bi kod.

PROCEDURE split_name

(

phrase IN VARCHAR2, FIRST OUT VARCHAR2, LAST OUT VARCHAR2

)

IS

FIRST := SUBSTR(phrase, 1, INSTR(phrase, ' ')-1);

LAST := SUBSTR(phrase, INSTR(phrase, ' ')+1);

IF FIRST = 'John' THEN

DBMS_OUTPUT.PUT_LINE('That is a common first name.');

END IF;

END;

/

IN	OUT	IN OUT
The default	Must be specified	Must be specified
Passes values to a subprogram	Returns values to the caller	Passes initial values to a subprogram and returns updated values to the caller
Formal parameter acts like a constant	Formal parameter acts like an uninitialized variable	Formal parameter acts like an initialized variable
Formal parameter cannot be assigned a value	Formal parameter must be assigned a value	Formal parameter should be assigned a value
Actual parameter can be a constant, initialized variable, literal, or expression	Actual parameter must be a variable	Actual parameter must be a variable
Actual parameter is passed by reference (a pointer to the value is passed in)	Actual parameter is passed by value (a copy of the value is passed out) unless NOCOPY is specified	Actual parameter is passed by value (a copy of the value is passed in and out) unless NOCOPY is specified

kaynak http://download.oracle.com/docs/cd/B12037_01/appdev.101/b10807/08_subs.htm#i4107in out örnekleri burada çok güzel açiklanmiş.
http://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm