We have to develop a standard form of stored procedure to accept multiple values from front end and store it in a table in a database.
Normally, this would be possible using a comma separated value string variable. The split up of string would be carried out on oracle side and values would have been inserted. However, this frequently crops up the trailing "," issue.
Is there any better method to accept multiple values in a stored procedure? Can VARRAYS be used to accomplish this ... knowing that any number of such values can be received from front end for storage?
Can anyone point us to the right code sample or idea?
Thanks in advance.