Coba ganti RAISE_APPLICATION_ERROR (-20000,'Data yang anda masukkan Salah');
RAISE_APPLICATION_ERROR (-20001,'Data yang anda masukkan Salah'); ferry. ----- Original Message ----- From: "Purwandi" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, June 01, 2005 10:36 AM Subject: [indo-oracle] Raise_Application_error > Hello.. > > > Saya punya trigger pada table TEST > > CREATE OR REPLACE TRIGGER "TRIG_002" BEFORE INSERT OR > UPDATE ON APPS.TEST REFERENCING NEW AS NEW OLD AS OLD FOR > EACH ROW > BEGIN > IF :NEW.A>10 THEN > RAISE_APPLICATION_ERROR (-20000,'Data yang anda > masukkan Salah'); > END IF; > END; > > Pertanyaan saya : > > 1.Pada saat saya insert/update table dari sebuah FORM, kok > message > 'Data yang anda masukkan Salah' tidak muncul di form > ...?? dan yang muncul malahan > 'FRM-40508: ORACLE error :unable to INSERT record' > > 2.Kalau saya insert lewat sqlplus timbul mesage : > > ERROR at line 1: > ORA-20000: 'Data yang anda masukkan Salah > ORA-06512: at "APPS.TRIG_002", line 3 > ORA-04088: error during execution of trigger > 'APPS.TRIG_002' > > Padahal saya maunya cuma muncul "ORA-20000: 'Data yang > anda masukkan Salah", Gimana caranya.....???? Tolong > pencerahannya.............. > > > Thx > > poer > > > ============================================================================ ============ > Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa Timur. > Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN (467826) > ============================================================================ ============ > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > 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.blogspot.com ----------------------------------------------- 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/
