folks,

is there any way of determining the number of parameters passed to a
stored procedure, and if more than expected are passed what they are?


Thanks in advance.

Tom...

tom (AT) themurphyhouse (DOT) fsnet.co.uk (tom) wrote in message news:<2bcb0752.0402180446.4b62a6bb (AT) posting (DOT) google.com>...

Not in ASE. Additional parameters are simply ignored.

One can create one additional parameter with a default value.
If the proc is called with any other value raise
a "too many parameters passed" error in that case.

-bret

bret (AT) sybase (DOT) com (Bret Halford) wrote in message news:<34c88f2b.0402181216.13ea7541 (AT) posting (DOT) google.com>...
Actually, thinking about it, I find I need to amend my answer.
If you write the procedure so it takes up to the maximum number
of parameters, and all the parameters in excess of what is "expected"
have a default value, then you can indeed determine what was passed
in for all the extra parameters, simply by examining them. I doubt
this is really a desirable approach, though, except perhaps for
some very unusual troubleshooting occasions.

-bret