| jayesh |
Posted: Jan 07, 2008 10:10:58 AM |
Total Post: 60
Joined: Jan, 2008
|
| can i write parameter name while calling a procedure. |
|
|
 reza |
| Posted: Jan 07, 2008 12:01:29 PM |  |
|
Total Post: 18
Joined: Jan, 2008
|
This link may help you...
http://www.techonthenet.com/oracle/procedures.php
Thanx.
|
|
|
|
|
| jayesh |
| Posted: Jan 08, 2008 08:38:37 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
Thanx for the link but my query is regarding calling a procedure and not while creating a procedure. I repeat my question can i write parameter name while calling a procedure.
|
|
|
|
|
| raja |
| Posted: Jan 08, 2008 11:49:25 PM | |
|
Total Post: 2
Joined: Nov, 2007
|
yes jayesh u can call a procedure by specifying parameter name
example : create procedure add_sal(sal IN NUMBER) as
....
BEGIN
...
END ;
u can call the above procedure in two ways
add_sal(2000) ;
add_sal(sal=>2000) ;
|
|
|
|
|
| jayesh |
| Posted: Jan 09, 2008 05:14:52 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
