|
|
Archives of the TeradataForum
Message Posted: Tue, 23 Aug 2005 @ 19:06:59 GMT
Subj: | | Stored Procedure Integer Input Parameter Handling |
|
From: | | Kambhoji, Naveen Ram Prasanna |
Hi All,
I have defined one of the parameters in a SP as INTEGER. While calling the SP there could be possibility of sending the value as say '101,102'
(coma seperated integers ), Ideally SP should error out but unfortunately TD is concatenating 101 & 102 (101102) and storing it as Integer. I
dont find any usage of doing TD this way.
I dont want this to happen and the SP should error out in such cases. Can anyone suggest me a work around for this?
Thanks,
Prasanna K.
| |