Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing Procedure with default parameters !!

460798Nov 9 2005 — edited Nov 9 2005
hi want a small help ...
I have a
procedure p1(p1 in number default 2, p2 in number default 3)
begin
:
:
:
end;

When the procedure will be called without passing parameters it will execute with default parameters.
That time I want to dispay message saying
" AS paramters are not passed, procedure is being executed with foll. default parameters:
Param 1 = 2
Param 2 = 3 "

Now issue is how do I capture this condition that , the parameters are being passed and it is using default parameters ?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2005
Added on Nov 9 2005
9 comments
1,833 views