Bisa pakai PRAGMA EXCEPTION_INIT, tapi harus dalam stored procedure.. jadi
tidak permanen..
SET SERVEROUTPUT ON;
DROP TABLE tes_error_00942;
CREATE TABLE tes_error_00942 (
field1 VARCHAR2(100) NOT NULL,
field2 VARCHAR2(100));
CREATE OR REPLACE PROCEDURE run_query (query VARCHAR2) IS
tidak_ada EXCEPTION;
jangan_null EXCEPTION;
PRAGMA EXCEPTION_INIT (tidak_ada, -00942); --- trap ORA-00942
PRAGMA EXCEPTION_INIT (jangan_null, -01400); --- trap ORA-01400
BEGIN
EXECUTE IMMEDIATE query;
EXCEPTION
WHEN tidak_ada THEN
DBMS_OUTPUT.PUT_LINE('Tidak Ada Tabelnya');
WHEN jangan_null THEN
DBMS_OUTPUT.PUT_LINE('Tidak Boleh Isi Null');
END;
/
Lalu panggil procedurenya:
- untuk dapetin error ORA -01400:Cannot Insert Null.. :
EXEC run_query ('INSERT INTO tes_error_00942 (field1,field2) VALUES (NULL,
''isi2'')');
- untuk dapetin error ORA-00942:Table or view not exist :
EXEC run_query ('INSERT INTO tabel_ngasal (field1,field2) VALUES (NULL,
''isi2'')');
Moga2 membantu.
Mungkin para master ada yang tau cara supaya custom message errornya bisa
diedit langsung di dictionary oracle databasenya?
regards,
Oscar
----- Original Message -----
From: ag3ng
To: [email protected]
Sent: Tuesday, March 13, 2007 10:56 AM
Subject: [indo-oracle] Re: Handle Error from English Language To Indonesia
Language
Hallo jadi gini Mas,
Saya lagi coba-coba buat kaya Query Browser,
Nah ketika misal terjadi human error dalam mengetik "SELECT * FROM
Kustomer" yang seharusnya "SELECT * FROM Customer" maka muncul pesan
pada level Server Oracle bukan dihandle oleh aplikasi VB(Saya buat
aplikasi pakai VB) adalah misal "ORA-00942 : Table or View Does not
Exist" menjadi "Sorry Bos table nggak ditemukan".
Saya udah coba buat Triggers manfaatin error number di database
SERVERERROR ON DATABASE tapi kesananya masih mentok belum dapat
solusi. Klo error numbernya udah nemu tapi manfaatinnya yang nggak
bisa. Bantuin donk rekan-rekan soalnya aku pengin custom error-error
yang sering muncul ke bahasa Indonesia semuanya.
THANKS YA UNTUK RESPONNYA.
SUKSES UNTUK KITA SEMUA.
BEST REGARDS
AGENG SETIAWAN
--- In [email protected], "Ane Oracle" <[EMAIL PROTECTED]> wrote:
>
> tabel atau view tidak ada/tidak ditemukan
>
> On 12 Mar 2007 18:40:25 -0700, ag3ng <[EMAIL PROTECTED]> wrote:
> >
> > Hallo Semua Apa Khabar?
> > Teman-teman Saya butuh bantuan nih. Saya mau ubah error dari orecle
> > yang dari bahasa Inggris ke bahasa Indonesia. Exp: Error Number
> > ORA-00942 : Table Or View does not exist ke bahasa Indonesia. Adakah
> > yang bisa bantu Saya?
> > SUKSES UNTUK KITA SEMUA
> >
> > Best Regards
> >
> > Ageng Setiawan
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
------------------------------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
MKD Group, www.mkdgroup.com
------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
