GTE (Global Temporary Entity)

By Tan Kian Tiong on 16 Nov 2017

Create a private entity (per session basis) like Oracle's GTT. 

https://oracle-base.com/articles/misc/temporary-tables

Sometimes a user wants to insert in a temporary table that other user cannot see.

regards,

IB

You can store structures in session variables, so you don't really need a database entity for that.

Just be aware that storing too much data in session variables will make your app very slow.

clown18 Nov 2017

Thank you Leo,


Your solution works.

But as my experience in Oracle Form, that feature will help much, either in easier of code development or performance increase (less rows to select as it is private per session basis).

Not to mention other benefits that Oracle has described.


Best regards,

Ib