| black |
Posted: Aug 30, 2007 02:18:40 AM |
Total Post: 14
Joined: Aug, 2007
|
hi friends,
defn of proc and fun?diff bet proc and fun |
|
|
 nadeem |
| Posted: Aug 30, 2007 07:03:07 AM |  |
|
Total Post: 15
Joined: May, 2006
|
Following is the major diff.
func can accept and return the value , whereas proc only can accept the value.
nadeem
|
|
|
|
|
| Mohammed Taj |
| Posted: Aug 30, 2007 09:03:56 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
, whereas proc only can accept the value.
1. both users. please don't use IM SPEAK !!!
2. procedure also return value.
Regards
Taj
|
|
|
|
|
| nadeem |
| Posted: Sep 01, 2007 01:03:34 AM | |
|
Total Post: 15
Joined: May, 2006
|
Hi Taj,
So, please giude . What diff. is ?
Thanks,
nadeem
|
|
|
|
|
| urmi |
| Posted: Sep 07, 2007 06:12:24 AM | |
|
Total Post: 10
Joined: Jan, 2007
|
1. You can create a procedure when u want to store a series of action for the later execution.
1. U can create a function when u want to compute and return a value.
2. Procedure : execute as apl/sql statement
2. Function: Invoke as part of an expression.
3. Procedure :Do not contain RETURN clause in the header.
3. Function: MUST contain RETURN clause in the header.
4. Procedure : Can contain RETURN STATEMENT .
4. Function: MUST contain at least one RETURN STATEMENT.
5. Procedure : stored procedures can not be called from SQL STATEMENTS.
6. Function: Stored functions are callable from SQL STATEMENTS. (with some restrictions).
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
