How to kill session in Oracle application express

Tags:
Oracle
Oracle Apex
SQL Query
I created a report through SQL query "select sid,serial# from v$session" with check boxes beside them. I want to kill session using sid,serial# of checked row by creating process in PL/SQL.


Software/Hardware used:
APEX
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You would usually do that from SQL Developer, SQL*Plus or some other similar tool, using a command like this:

alter system kill session '<SID>,<SERIAL#>';

If you want to do it from an application, you would need to create a stored procedure (owned by a user with the necessary privileges to kill sessions) that receives the SID and SERIAL# as parameterS.  Then you would need to grant the execution privilege on that procedure to the user running the app.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: