-DESCRIBE LOGIN dengan cek dg INSERT statement di bawah. -Periksa apakah ada trigger pada tabel login. -Coba ganti IF JUM = 0 THEN dengan IF SQL%ROWCOUNT=0 THEN
ferry sends. ----- Original Message ----- From: "Kris Lie" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 26, 2005 7:54 AM Subject: [indo-oracle] Query error : Unable insert record > hi,all > > g lagi mentok untuk save data dengan query insert. > g selalu disajikan error > '40508 :Oracle Error: Unable to Insert Record.' > padahal di property nya g juga udah set insert allowed YES. > please saran nya. > > g udah buat code nya untuk menyimpan data login pegawai seperti ini: > DECLARE > V_ID LOGIN.ID%TYPE; > V_PASS LOGIN.PASS%TYPE; > V_JBTN LOGIN.JBTN_ID%TYPE; > V_PGW LOGIN.PGW_ID%TYPE; > V_STATUS LOGIN.STATUS%TYPE; > JUM NUMBER; > BEGIN > V_ID := :LOGIN.ID; > V_PASS := :LOGIN.PASS; > V_JBTN := :LOGIN.JBTN_ID; > V_PGW := :LOGIN.PGW_ID; > V_STATUS := :LOGIN.STATUS; > IF (V_ID IS NULL) AND (V_PASS IS NULL) AND > (V_JBTN IS NULL) AND (V_PGW IS NULL)AND (V_STATUS IS NULL) THEN > MESSAGE('SILAHKAN MASUKAN SEMUA DATA DIATAS'); > RAISE FORM_TRIGGER_FAILURE; > ELSE > SELECT COUNT(*) INTO JUM FROM LOGIN WHERE ID = V_ID; > IF JUM = 0 THEN > INSERT INTO LOGIN VALUES (V_ID,V_PASS,V_JBTN,V_PGW,V_STATUS); > MESSAGE('PEOSES INPUT SUKSES'); > ELSE > UPDATE LOGIN SET ID = V_ID, PASS = V_PASS, > JBTN_ID = V_JBTN, PGW_ID = V_PGW,STATUS = V_STATUS; > MESSAGE('PROSES UPDATE BERHASIL'); > END IF; > COMMIT; > END IF; > EXCEPTION > WHEN NO_DATA_FOUND THEN > MESSAGE('PROSES SELECT GAGAL'); > WHEN VALUE_ERROR THEN > MESSAGE('KESALAHAN NILAI'); > END; > > > > > > > > > -- > -----------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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/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/
