Default values of stored procedures

Is there any document/tutorial about using default values of In parameters of stored procedures of oracle / MS SQL ?

Hi you can use : paramname default value; Example.
EMPNO IN number,
DEPT IN varchar2 default 'CSE' ....


You can call the procedure using named notation. Example: procedure (empno => 20,dept => 'CSE') etc..

Thanks for taking time on my issue.

Quote:

---

Originally Posted by subrahmanyam.adapa

You can call the procedure using named notation. Example: procedure (empno => 20,dept => 'CSE') etc..

---

This notation surely works from SQLPlus in case of oracle.
But I want information about using this from Java.
I have already tried doing this through java as well..but my driver classes12.jar does not support named notation like setInt("param1",10)

..thanks.