Dear rekan indo-oracle !
saya membuat script berikut di PL/SQL (oradev 6i)
tapi kok error terus di exception pertama
dgn error:
1. ORA-00911 : invalid character
2. ORA-06512 : at "SYS.DBMS_SQL_.......
fact:
1. sy sudah grant role DBA
2. grant object previliege EXECUTE dari package
SYS.DBMS_SQL.
berikut scriting nya
terima kasih atas bantuan dan sarannya
declare
v_Cursor number;
v_KillString varchar2(1000);
v_NumRows integer;
v_Version number;
Begin
--Open the cursor for processing
v_Cursor:=DBMS_SQL.OPEN_CURSOR;
-- Assign kill statement
v_KillString:='alter system kill session ''' || :SID
|| ',' || :SERIAL# || ''';' ;
--parse and execute kill statement
begin
DBMS_SQL.PARSE(v_cursor,v_KillString,1);
v_NumRows :=DBMS_SQL.EXECUTE(v_Cursor);
--exeception pertama
exception
when others then
ltf_mssg(sqlerrm,'E',true);
end;
exception
when others then
DBMS_SQL.CLOSE_CURSOR(v_Cursor);
ltf_mssg(sqlerrm,'E',true);
end;
__________________________________________________________
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
