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