Problem in PL/SQL Procedure

[nkakrani]

Dear Friends..

Hi

Can anyone help me.. I am executing one procedure and getting following error.

Character string buffer too small.

Can anyone guide me what does it means...


thanks
naresh

BEGIN dbmon; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ORCL.TEST", line 164
ORA-06512: at line 1

[shawish_sababa]

you probably use dbms_output. what tou eed to de isto increase your duffer size.
"set server output on"
"size 1000000"
and run your proc again

[bhavanikri]

Hi,

There are two situations. When you are sending variables out of this SP, size of the variable receiving the data out side should be equal to the size of the data sending and vice versa.

Not only that, check out all the sizes of all the variables in your procedure.

Hope this may clear your problem.

Cheers....

Murali