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 > > > > > > > ------------------------ 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/
