Hi all,
Let me give a gist of my situation. I am passing a comma delimited
String of SSNs (eg. 1234567890,0987654321,2345678901,3456789012)as a argument for a Stored procedure. But the problem is that, the parameter in Stored procedure can only accept a Max size of 32k. I have more probability that this String of SSN is more than 32k.
so my first question would be
1. How do i find the size of the string?
let me know what i did is right
int len = ssn.length();
int size_In_Bytes = len/1024;
2. Can anyone help me with a logic, about how to pass this string in pieces of less than 32k to the stored procdure, but at the same time making sure that SSN is passed completely.
I really appreciate an answer ASAP. Thanks in advance
Regards,
vikram