This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
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
Assuming you're operating under UTF-8, every digit in every social security number that I'm aware of (granted, that's us only) can be represented in eight-bit bytes, therefore, I can't imagine a social security number exceeding a 32,000 bit limitation in the database. Here's use of a tokenizer: