hi all,

i noticed in vb.net that when declaring new connection objects it creates a new session. and sometimes it reuses an existing one.

is this an expected behavior?

in my application i created a global temporary table. in oracle, this acts like a table but session based. the behavior mentioned above is causing some issues with my temporary table as new sessions are being created and thus, i'm not able to get the desired data from the table.

i thought of using a global connection but not sure if this is the best way.

any suggestions?

thanks.