Backup with transportable tablespace method and procedure

Hi expert,

I'm new in pl/sql oracle.

We have weekly backup with with transportable tablespace method and procedure.

Yesterday we got error while alter tablespace to read only.

ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "MISPROD.GET_TS_NAME", line 19

ORA-06512: at line 1

In the SP, we define the varchar to the max value (32767)

curr_tsx varchar2(32767);

Here the complete logs:

Process start :  Sat Aug 29 21:16:18 WIB 2020

Start Altering tablespace to read only

BEGIN misprod.get_ts_name; END;

*

ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small@