[indo-oracle] ?? procedure ganti password

[OLA]

teman-teman senior
aku memiliki procedure sbb

CREATE OR REPLACE procedure ubah_pass (vr_new in varchar2) is
    c_user     varchar2(30);
    i_cursor   integer;
    sqlstr  VARCHAR2(50);
    tCursor INTEGER;
Begin
    sqlstr := 'alter user sdm1 identified by '||vr_new||' ' ;
    tCursor := dbms_sql.open_cursor;
    dbms_sql.parse(tCursor, sqlstr, dbms_sql.NATIVE);
    dbms_sql.close_cursor(tCursor);
End ubah_PASS;
/

kenapa procedure ini tidak dapat merubah user ??
mohon pencerahannya



oLa 




[Non-text portions of this message have been removed]