Statement raise_application_error tsb diganti aja dengan keinginan bpk,
Missalnys lansung insert into table_name.
EXCEPTION WHEN OTHERS THEN
Insert into <table_name> values;
Alamsyah
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of Burhanudin
Sent: 16 Agustus 2005 15:14
To: [email protected]
Subject: RE: [indo-oracle] tanya exception
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
--
-----------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=12h4opd4p/M=362131.6882499.7825260.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124350538/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/
