how to compare value in array
559169Jan 31 2007 — edited Jan 31 2007hello.
I'm creating a stored procedure which receives parameters in array.
The type of the parameter is declared as "is table of varchar2(2) index by binary_integer".
I receive the parameter just fine.
I want to see if there is any duplicated values in the parameter.
let's say, the values are:
arrValue(1) = 'ab'
arrValue(2) = 'bc'
arrValue(3) = 'cd'
arrValue(4) = 'ef'
arrValue(5) = 'bc'
since arrValue(2) and arrValue(5) are the same, I want to return error.
Can I do this without inserting those values into a temporary table?