• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
1

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

Community Beginner ,
Oct 12, 2023 Oct 12, 2023

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.

Views

110

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources
Documentation