| Functions parameter list [message #370041] |
Mon, 04 December 2000 14:22  |
Mohammad Syed
Messages: 18
Registered: November 2000
|
Junior Member |
|
|
Lets say i have the following function in a package:
FUNCTION test (A varchar := NULL,
B varchar := NULL,
C Date := NULL
D Date := NULL) RETURN NUMBER ;
Would it be possible to run the function like:
SELECT test(A,D)-- skip B and C
FROM dual;
or like below..???
SELECT test(A,,,D)-- skip B and C with comma delimiter.
FROM dual;
|
|
|
|
| Re: Functions parameter list [message #370052 is a reply to message #370041] |
Wed, 06 December 2000 14:13  |
Madhav Kasojjala
Messages: 42
Registered: November 2000
|
Member |
|
|
Hi,
You can do it but not exactly the way you wrote.
If you have a function test(A,B,C,D ) return number
then
you need call the function like this
I.
to call test(a,c)
test(a --> 100, c --> 20)
II.
to call test(a,b,c,d)
test(c--> 200, b --> 20 a --> 100, d--> 30)
or
test(100,20,200,30)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
