IDS 9.40.FC8 and Stored Procedures

This may be a silly question but here goes. As V9 can have multiple Stored Procedures with the same name but with a different number of arguments what happens when you call a stored procedure with (say) 8 arguments, 4 of which have a default, and you only supply the other 4. How does IDS find it? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live' Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb

Colin Dawson wrote: > This may be a silly question but here goes. > > As V9 can have multiple Stored Procedures with the same name but with a > different number of arguments what happens when you call a stored > procedure with (say) 8 arguments, 4 of which have a default, and you > only supply the other 4. How does IDS find it? The number of arguments is only part of the selection process. The types of the arguments are also compared to the signatures of all of the specific routines and implicit casts are taken into account to select the best fit. Sometimes the engine cannot select just on that matches, then you'll get an error. Art S. Kagel

Colin Dawson wrote: > This may be a silly question but here goes. > > As V9 can have multiple Stored Procedures with the same name but with a > different number of arguments what happens when you call a stored > procedure with (say) 8 arguments, 4 of which have a default, and you > only supply the other 4. How does IDS find it? The number of arguments is only part of the selection process. The types of the arguments are also compared to the signatures of all of the specific routines and implicit casts are taken into account to select the best fit. Sometimes the engine cannot select just on that matches, then you'll get an error. Art S. Kagel