| procedure overload [message #57825] |
Wed, 09 July 2003 11:02  |
Eugene
Messages: 44
Registered: August 2001
|
Member |
|
|
Hi all,
I have a situation where I'd like to call the same proc but pass different parameters into it. I have two cursors producing different results. I am passing a record returned by the cursor into a procedure. How can user the same procedure, but to pass a record from another cursor into it. Could someone point me to the right direction or send me an example.
Thaks,
Eugene
|
|
|
|
| Re: procedure overload [message #57847 is a reply to message #57825] |
Thu, 10 July 2003 14:46  |
kochunni
Messages: 17
Registered: May 2003
|
Junior Member |
|
|
Create a package with different procedures with the same name and diffrent parameters.
CREATE OR REPLACE Package test is
PROCEDURE aa
( a IN Number,
b IN number,
c IN number,
d OUT NUMBER
);
PROCEDURE aa
( a IN Number,
b IN number,
c IN number,
d OUT NUMBER,
e in number);
end test;
/
Hope this should work.
kochunni
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
