| jayesh |
Posted: Jan 07, 2008 08:36:21 AM |
Total Post: 60
Joined: Jan, 2008
|
| how can i override procedure? |
|
|
 reza |
| Posted: Jan 07, 2008 09:20:03 AM |  |
|
Total Post: 18
Joined: Jan, 2008
|
While creating procedure .... write the code as:
--- CREATE OR REPLACE procedure_name
Then previous procedure will be just u asked for.
Thanx.
|
|
|
|
|
| jayesh |
| Posted: Jan 07, 2008 09:45:34 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
thanx. I m new in oracle so i was confused but u solved it so easily. Thanx
|
|
|
|
|
| Devesh |
| Posted: Jan 10, 2008 08:58:39 AM | |
|
Total Post: 29
Joined: Oct, 2005
|
It's just like a same as in C++...
If u create two procedure in a package sharing a same name, but different number of parameter.. then it is a called a procedure Overloading or Overriding.
Jayesh, there is a difference between overriding and overwriting got it.
|
|
|
|
|
| reza |
| Posted: Jan 11, 2008 10:27:59 AM | |
|
Total Post: 18
Joined: Jan, 2008
|
Thanx Devesh...
I got it cleared also.
|
|
|
|
|
| jayesh |
| Posted: Jan 20, 2008 04:35:26 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
ok its cleared now
its like overloaded package means one can use a same name for more than two procedures but with different parameteres.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
