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