Oracle stored procedure input string with variable length/field
Posted on 2007-03-23
I need to use a stored procedure to check the input from frontend with various number of accounts (1, 2, or 40) and check EACH of these accounts in th e Oracle database table to see if they are valid or not and give out warning if the account is not valid. What will be the best way to handle this? Shall the input be in one string with accounts numbers seperated with comma or pipe, or it's better to get the accounts in seperate lines (one account in each line)? And, with either method, how to loop through each account to check in the tables and give out status for each account?