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] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
