Thanks bgt,pay atas informasi nya. g udah coba n skrg g udah ngerti. kapan2 g mo bimbingannya lagi yah. thanks, Kris
pay <[EMAIL PROTECTED]> wrote: 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 > > > > > > > > > > -- -----------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 SPONSORED LINKS Database development software Database management software Database software Inventory database software Membership database software Citrix terminal server --------------------------------- YAHOO! GROUPS LINKS Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hpupbm8/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124982977/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
