We have written a select query which accepts different parameter from UI. One of the parameters accepts comma separated values as parameter. Ex emp id, User can pass values for p_emp_id as 100,102,300,400.
Everything is fine as long as user passes 5- 10 values as parameter.
Once user passes 30-40 values as comma separated, we are getting below error with status code as 414. How do we fix this?
Error - 414 Request-URI Too Large
Sample Query -
SELECT * FROM emp
WHERE ( least(:p_emp_id) IS NULL
OR emp_id IN (
SELECT
regexp_substr(:p_emp_id, '[^,]+', 1, level)
FROM
dual
CONNECT BY
regexp_substr(:p_emp_id, '[^,]+', 1, level) IS NOT NULL
) )