Archives of the TeradataForum

Message Posted: Tue, 23 Aug 2005 @ 19:06:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>