Tapi kebutuhan saya adalah yang kena exception mau di insert kedalam satu table. Terimkasih atas tanggapannya, kok sepi yang jawab yah biasanya rame banget yang jawab.. Regards,
Burghan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alamsyah Sent: Monday, August 15, 2005 2:28 PM To: [email protected] Subject: RE: [indo-oracle] tanya exception Mungkin membantu coba pakai statement di bawah EXCEPTION WHEN OTHERS THEN raise_application_error(-20000,sqlerrm); Alamsyah -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 15 Agustus 2005 14:07 To: [email protected] Subject: [indo-oracle] tanya exception 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 -- -----------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 Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h18h6qg/M=362131.6882499.7825260.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124187229/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
