Dear Kris Lie, bisa jadi tabel Emp tersebut belum ada, untuk mengujinya kamu masuk aja dulu ke Sql Plus terus ketik perintah: Desc Emp, oya jangan lupa pada saat connect username, psw dan hostringnya sdh benar. kalo field2nya ada berarti tabel itu sudah ada.
tanda : di form menandakan sebagai Block semoga membantu pay ----- Original Message ----- From: "Kris Lie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, August 19, 2005 3:19 PM Subject: [indo-oracle] error 201 oracle developer > hi,all.g pemula nih. > g lg belajar buat procedure di oracle developer. > trus g ikutin tutorial untuk create procedure untuk menghitung > jumlah memeber seperti ini: > > procedure hitung_member(masuk in number, keluar out number) is > temp number; > begin > select count(*) > into temp > from EMP <<<< > where EMP.DNO = > (Select EMP.DNO from EMP where EMP.NO = masuk); > end; > > tapi selalu muncul error di baris <<<<. error nya > 'ERROR 201: Identifier 'EMP' must be declare'. > gmana sih solusinya? > > trus tanda ':' yang sering dipake tuh, maksudnya apa sih? > cth: > 'select last_name > into :emp.last > from emp where dept.id = :emp.id' > > thanks b4 > > > > > > > > > -- > -----------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 --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h4esn8a/M=362329.6886308.7839368.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124856417/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> -- -----------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/
