Copy link to clipboard
Copied
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.
Have something to add?