Dear Eddy S n Kiki K Thank's a lot, sekarang sudah teratasi masalahnya
Terima kasih Bakry --- Edy Sumaryoto <[EMAIL PROTECTED]> wrote: > Kalau berdasarkan errror ORA... Sepertinya ada 2 > kasus. > 1. Karena field/variable yg kurang panjang. > 2. Karena field/variable yg akan di set dengan > nilai/valuenya berbeda > datatypenya. > salam, > edy-- > > > On 9/7/05, Kiki Kuswara > <[EMAIL PROTECTED]> wrote: > > > > Coba di trace pakai exception > > > > Begin > > --Your code > > Exception > > When Others Then > > dbms_output.put_line(SqlErrM); > > End > > > > Semoga Membantu, > > > > Kiki Kuswara > > > > > Dear all, > > > > > > > > > Tolong ya....saya punya procedure yang bisa di > create > > > dan tidak ada errors tapi masih timbul error > seperti > > > dibawah ini. > > > Gimana ya.... > > > > > > pada akhir procedure saya tambahkan > > > > > > / > > > SHOW ERRORS; > > > exec RKBYA( '200506-00026', '200506-00026'); > > > select * from tablerptkenbya; > > > > > > untuk melihat hasilnya > > > > > > > > > > > > Hormat saya, > > > > > > bakry > > > > > > > > > ---- > > > > > > Procedure created. > > > > > > No errors. > > > > > > > > > BEGIN RKBYA( '200506-00026', '200507-00026'); > END; > > > > > > * > > > > > > ERROR at line 1: > > > ORA-06502: PL/SQL: numeric or value error: > character > > > string buffer too small > > > ORA-06512: at "BAKRY.RKBYA", line 266 > > > ORA-06512: at line 1 > > > no rows selected > > > > > > -- > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam > protection around > > > http://mail.yahoo.com > > > > > > > > > > > > -- > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: [EMAIL PROTECTED] > > > Website: http://indo-oracle.lizt.org (NEW) > > > ----------------------------------------------- > > > > > > Bergabung dengan Indonesia Thin Client User > Groups, > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > http://indo-thin.vze.com > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User > Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > removed] > > > > ______________________________________________________ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
