Re: Kill session from PL/SQL

Dear all,

Problem now solved.
Many thanks indeed.

Norman.

>> lose the semi-colon. the procedure should have:

>> DBMS_SQL.PARSE(C3, 'alter system kill session '|| USERID,
>> DBMS_SQL.NATIVE);
>> RESULT := DBMS_SQL.EXECUTE(C3);

>> the owner of the procedure will need the ALTER SYSTEM privelege
granted to them
>> directly.
Received on Tue Jul 27 1999 - 11:22:12 CDT