Calling Oracle stored procedure having insert statement into a temporary table does not work

[me@Adobe]

We have a stored procedure in Oracle which has an insert statement into global temporary table. But , calling this stored procedure from ColdFusion application throw error saying "Object no longer exists". 

Procedure definition looks like below,

INSERT INTO DSB.TT_SP_bill_getBillInfo_Device
SELECT DISTINCT 100, 'test', 'test', 'test', 1,'test','test', 10,
1,0,1, 0,1,0 from dual;

Apprecite your help debug the error.