How Oracle Global Temporary Table works in Appian

Hi,

I have created a GTT table(ON COMMIT PRESERVE ROWS) and mapped to Appian CDT, but the database session seems expired in couple of seconds. how to prevent the database session?

 

Thanks

Vinay

  Discussion posts and replies are publicly visible

Parents
  • Hello Vinay,

    I haven’t tried to use temporary tables before in Appian but It is interesting this use case, can you elaborate the use case and why you considered using a GTT.

    As part of your solution do you have a security/privacy constraint ? Do you have long data and then delete it ?

    Jose
Reply
  • Hello Vinay,

    I haven’t tried to use temporary tables before in Appian but It is interesting this use case, can you elaborate the use case and why you considered using a GTT.

    As part of your solution do you have a security/privacy constraint ? Do you have long data and then delete it ?

    Jose
Children
No Data