| Stored Procedure Optional Parameters [message #123465] |
Mon, 13 June 2005 11:36  |
liux99
Messages: 29
Registered: June 2005
|
Junior Member |
|
|
I have a stored procedure check_data (no parameters) and this stored procedure was called by several applications.
Now one application want to pass two parameters into this stored procedure, I don't want other applications get affected by this change, my question: is there a feature like Optional Parameters in oracle stored procedure? How does it look like? Thanks for your education.
|
|
|
|
| Re: Stored Procedure Optional Parameters [message #123477 is a reply to message #123465] |
Mon, 13 June 2005 12:33  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
The DEFAULT clauses on the parameters will allow this procedure to be called with no parameters, with just one (p_parm1) parameter, or with two parameters.
create or replace procedure check_data
(p_parm1 in varchar2 default null,
p_parm2 in number default null)
is
begin
if p_parm1 is null then
...
else
...
end if;
end; |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
