teman-teman mohon pencerahannya dong. Saya mau tanya tentang exception pada function table, yang ingin saya tanyakan adalah saya ingin data yang tidak tertangkap dalam query karena tidak memenuhi where condition akan saya insert ke suatu table misal table error.
ini contoh script-nya function table yang saya punya: ====================================================== CREATE OR REPLACE FUNCTION Get_FX (p IN NUMBER) RETURN fkoreksi_tab PIPELINED IS BEGIN FOR i IN ( SELECT b.id_area,c.id_periode, COUNT(a.cust) jmlkwitansi,COUNT(DISTINCT a.cust) jmlcustomer,SUM(a.rppembayaran) Rppembayaran FROM Koreksi a, D_AREA b,D_PERIODE c WHERE "kondisi yang diharapkan" ==================== b.area= a.area AND a.periode = c.priode ============================= LOOP PIPE ROW (FKOREKSI_OBJ(i.id_area_pelayanan,i.id_periode_bisnis i.kwitansi,i.customer,i.pelanggan)); END LOOP; RETURN; END; / excepetion when "tidak memenuhi kondisi" didalam where caluse then insert into error sintax-nya serti apa yah? mohon pencerahannya doong. Salam, Burghan ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hmaivrg/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124096835/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/
