Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Following is an example where users can define a DEFAULT parameter which makes it as optional, the user can then call the procedure or the function without passing any value for the default parameters.
SET SQL_MODE=ORACLE; |
|
|
DELIMITER //
|
create or replace |
procedure default_values( |
p_parm1 varchar2,
|
p_parm2 varchar2 default 'AAA', |
p_parm3 varchar2 default 'BBB' ) as |
begin
|
select param1, param2, param3; |
end default_values// |
|
|
DELIMITER ;
|