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/