Retrieving current session id from a plugin

[Starina]

Hi.

I'd like to know if there's a way to programmatically get current window session id (sid). Right now I can only get either main or private session via appropriate API.

Thanks in advance.

 

[Marco Kalter]

You would have to query it:

select sys_context('USERENV','SID') from dual

 

[Starina]

How do I execute a query using window session context?

 

[Marco Kalter]

Hmm, I see that this is not possible yet. I have added this to the list of enhancement requests. At the moment is is not possible to get the session id of the current window.

 

[Starina]

I hope to see it in near future. Thanks.