Issues using move_qt_pkg package for ebs r12.1.3
Hello Experts,
OS platform - OEL 5.11
EBS version - 12.1.3
DB version - 12.1.0.2
As part of moving some queue tables to reclaim space from APPS_TS_QUEUES, I am facing below error -
11:39:35 SQL> exec move_qt_pkg.move_queue_table('ASO','ASO_ORDER_FEEDBACK_T','APPS_TS_QUEUES','APPS_TS_QUEUES')
BEGIN move_qt_pkg.move_queue_table('ASO','ASO_ORDER_FEEDBACK_T','APPS_TS_QUEUES','APPS_TS_QUEUES'); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.MOVE_QT_PKG", line 226
ORA-06512: at "APPS.MOVE_QT_PKG", line 105
ORA-06512: at line 1