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 ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h0ockn1/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124446780/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/
