hi suvashish
the table is a global tempporary table and thescript s below.
CREATE GLOBAL TEMPORARY TABLE TEMP_TRANSD1
(
BT_OPTION VARCHAR2(6),
BT_BRANCH VARCHAR2(6),
BT_TRNO VARCHAR2(15),
BT_PROCESSDT DATE,
BT_UNITS NUMBER(20,3),
BT_AGENT VARCHAR2(16),
BT_PURRED VARCHAR2(8),
BT_ACNO VARCHAR2(16),
BT_SEQNO NUMBER(4)
)
ON COMMIT PRESERVE ROWS;


thnks