thx sudah benar sekarang
oLa imut ----- Original Message ----- From: "vinkymomo ." <[email protected]> To: <[email protected]> Sent: Monday, November 09, 2009 9:50 PM Subject: RE: [indo-oracle] ?? procedure ganti password > > coba tambahin execute immediate > > execute immediate 'alter user sdm1 identified by '||vr_new||' ' ; > > CMIIW, > eldienh > > To: [email protected] > From: [email protected] > Date: Fri, 9 Oct 2009 14:24:22 +0700 > Subject: [indo-oracle] ?? procedure ganti password > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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] > > > > > > > > > > > > > > > > > > > _________________________________________________________________ > Windows Live: Friends get your Flickr, Yelp, and Digg updates when they > e-mail you. > http://www.microsoft.com/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-id:SI_SB_3:092010 > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > __________________________________________________ Apakah Anda Yahoo!? Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam http://id.mail.yahoo.com
