My web application calls an Oracle function. The function uses dynamic SQL which is in part built by a parameter passed from the web application.
At times, the string parameter passed across is too long and I receive the following error:
[ORA-01704: string literal too long].
I tried changing the parameter type to CLOB and I still get the error.
I know I should be using bind variables but am not familiar with them and hope that one of you could assist me in editing my code to use bind variables:
My code is attached.