dh, Untuk throw exception di trigger, sementara ini saya belum tahu. Tapi saya lebih sering mengolahnya di sisi coding di tools programming misal form builder disini saya coba contohkan triggernya. -------------------------------------------- CREATE OR REPLACE TRIGGER "TR_BIU_MYTABLE" BEFORE INSERT OR UPDATE ON MYTABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF LENGTH(:NEW.KOLUM) > 65 THEN raise_application_error(-200011,'Cannot Insert/Update because greater than 65 character'); END IF; END; ------------------------------------------- Pada saat akan insert/update field KOLUM, maka akan di check dulu apakah > 65. Kalau iya, maka akan keluar error message di form dan database akan otomatis melakukan rollback. Untuk di form builder biasanya message akan keluar sesuai dengan yg di coding. smoga membantu, edys--
On 9/9/05, Edy Sumaryoto <[EMAIL PROTECTED]> wrote: > > Kalau di form builder 6i. di field properties --> maximum length aja di > set 65. > Pada saat user input pasti akan dibatasi. > > > On 9/9/05, hs4n <[EMAIL PROTECTED]> wrote: > > > > hi, > > > > cara ini kan tetap saja menerima input > 65 cuma nanti waktu di > > insert/update ke dbasenya dia akan mensubstring 65 karakter saja. ini > > kan bisa masalah buat usernya? entah apakah usernya input pake gui > > atau sql biasa. > > > > kenapa gak di alter table saja? > > > > btw, saya pengen nanya, apakah di trigger bisa throw exception ya? > > kalo bisa apakah berarti semua operasi di rollback? > > > > thx > > > > --- In [email protected], Edy Sumaryoto <[EMAIL PROTECTED]> > > wrote: > > > Mungkin bisa diakalin di pasang di trigger table before insert/update > > > Ini contohnya nama table MYTABLE dan nama column KOLUM. > > > semoga membantu > > > salam, > > > edys-- > > > ------------------- contoh script--------------------- > > > > > > CREATE OR REPLACE TRIGGER "TR_BI_MYTABLE" BEFORE INSERT ON MYTABLE > > > > > > REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW > > > BEGIN > > > -- SEBELUM INSERT DIBATASI MAX 65 > > > :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) > > > END; > > > > > > CREATE OR REPLACE TRIGGER "TR_BU_MYTABLE" BEFORE UPDATE ON MYTABLE > > > > > > REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW > > > BEGIN > > > -- SEBELUM UPDATE DIBATASI MAX 65 > > > :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) > > > END; > > > > > -------------------------------------------------------------------------- > > > > > On 9/7/05, Kiki Kuswara <[EMAIL PROTECTED]> wrote: > > > > > > > > Balik tanya nih, > > > > > > > > Kasusnya di form atau secara dml (sql Plus)? > > > > > > > > Salam, > > > > > > > > Kiki Kuswara > > > > > > > > > Dear all, > > > > > > > > > > Langsung aja saya punya problem dimana saya punya table salah satu > > > > > kolomnya sudah di set max lenght 225 char. tapi Sekarang ini > > saya mau > > > > agar > > > > > isi kolom tersebut max 60 char. Kira-kira ada yang tau ga gimana > > caranya > > > > > saat user isi kolom tersebut lebih dari 60 maka user tidak bisa > > ketik > > > > > lagi > > > > > > > > > > Thanks banget ya buat bantuan teman2 semua > > > > > > > > > > Salam, > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > -----------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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
