Download Oracle HRMS Implementation Guide

Transcript
procedure change_age
(p_name
in
varchar2
,p_age
in
number
;
Calling by ’Named Notation’:
begin
change_age
(p_name => ’Bloggs’
,p_age => 21
);
end;
Calling by ’Positional Notation’:
begin
change_age
(’Bloggs’
,21
);
end;
Using Default Parameter Values
When calling an API it may not be necessary to specify every parameter.
Where a pl/sql default value has been specified it is optional to specify a
value.
If you want to call the APIs from your own Forms 4.5 code, then all
parameters in the API call must be specified. You cannot make use of the
pl/sql declared default values because the version of pl/sql in Forms 4.5
does not support this.
Default Parameters with Create Style APIs
For APIs which create new data in the HR schema, optional parameters
are usually identified with a default value of null. After validation has
been completed, the corresponding database columns will be set to null.
When calling the API, you must specify all the parameters which do not
a have a default value defined.
However, some APIs contain logic to derive some attribute values.
When you pass in the pl/sql default value the API determines a specific
value to set on the database column. You can still override this API logic
by passing in your own value instead of passing in a null value or not
specifying the parameter in the call.
Technical Essays
A – 47