Salah pada saat deklarasi: > SQL> variable dEtd varchar2; > SQL> variable vError varchar2;
SEHARUSNYA SQL> variable dEtd varchar2(100); -- length-nya harus ada SQL> variable vError varchar2(100); -- length-nya harus ada CMIIW, Bowo --- In [email protected], "Albertus" <[EMAIL PROTECTED]> wrote: > > Hallo teman-teman.Aku mohon pencerahannya.Saya punya 2 > server database.Satu server buat coba-coba dan satu lagi > buat operasional.Dan saya ada satu prosedure package.Waktu > saya execute di server coba-coba tidak ada masalah.Tetapi > waktu saya jalankan di server operasional kok muncul error > sepert dibawah ini : > > SQL> variable iQtyOut number; > SQL> variable dEtd varchar2; > SQL> variable vError varchar2; > SQL> exec > PackSDAHPHO.ProcSdAhpCekStock ('06141KRS505',1,:iQtyOut,:dEtd,:vError); > BEGIN > PackSDAHPHO.ProcSdAhpCekStock ('06141KRS505',1,:iQtyOut,:dEtd,:vError); > END; > > * > ERROR at line 1: > ORA-06502: PL/SQL: numeric or value error: character > string buffer too small > ORA-06512: at line 1 > > Apa teman-teman bisa kasih saya solusi atau masalahnya ada > dimana ya?Aku jadi bingung deh.Atas bantuan dan > informasinya saya ucapkan terima kasih. > > > Regards > > > Tiong > ===================================================================== =================== > Ikuti Kuis Ramadhan bersama TelkomNet Instan dari 12 Oktober s.d 2 Nopember 2005 di > http://www.plasa.com/jatim > dan dapatkan hadiah setiap minggunya ! (khusus Jawa Timur) > ===================================================================== =================== > -- -----------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/
