Declaring local variable as CLOB / nCLOB
577460Jun 8 2007 — edited Apr 16 2010This is related to my last thread posted a day before.
I am passing an OUT parameter in my Oracle package to return a long character string. String is that long that I need to use CLOB datatype for the OUT parameter.
As OUT parameter is being used , I need to declare a variable with the same name at SQL prompt. It works as long a steh character string passed to the OUT parameter is not big. But, If I pass bigger string it gives me below error.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1
Kindly advise how to resolve the issue and how to use CLOB datatype for OUT parameter.