Pak Julius.. mohon bantuannya. Saya pake Oracle 8.1.7. Nah sering kali kehabisan session. sehingga user jadi tidak bisa log on. jumlah session dan proses sudah saya besarkan yakni 505 untuk session dan 500 untuk Proses. Padahal Concurrent user saya gak lebih dari 200. Menurut Bapak apa yang harus saya lakukan? Spek Server 1. Database 8.1.7 2. Memory 2GB 3. HDD 6 * 40GB 4. Proc 3x3Ghz 5. Total SGA 1.2GB ----- Original Message ----- From: Yulius Wibowo To: [email protected] Sent: 17 February 2006 2:35 Subject: [indo-oracle] Re: buat master detail, tapi gak bisa save&insert... gimana?
Ada beberapa sebab: 1. Misal, mungkin saja anda telah menambahkan sebuah atau beberapa item di dalam block DEPT atau EMP, tetapi tidak/lupa diset sbg Non Database Item. 2. Atau, data yg anda masukkan tidak valid, misal terbentur masalah constraint. Cara mudah utk mengetahuinya adalah: Apabila anda mendapat error spt: FRM-40508: ORACLE error: unable to INSERT record maka yg harus anda lakukan adalah, pili menu Help -> Display Error. Lalu check error detailnya . Semoga membantu, CMIIW, Bowo --- In [email protected], fata hudaya <[EMAIL PROTECTED]> wrote: > > hallo... salam kenal semua... > > saya pemula di oracle, > saya sdng latihan buat master detail, mengunakan skema > SCOTT. table DEPT dan EMP. saya buat tombol > save,insert,delete dan exit di formnya. tapi kok gak > bisa nge-save ya? scriptnya : > --"SAVE" > > declare > v_simpan varchar2(20):=0; > begin > v_simpan:=show_alert('save'); > if v_simpan=alert_button1 then > commit; > end if; > exception > when no_data_found then > null; > end; > > > tapi malah muncul error, > > FRM-40508: ORACLE error: unable to ISERT record > > ada yang bisa kasih solusi ga? > o iya, ane bikinnya base table (DEPT-EMP). > > thnx all: > > > > ___________________________________________________________ > To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com > -- -----------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 SPONSORED LINKS Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "indo-oracle" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ =================================================== This Mail Scanned By Messaging Security Suite ================= Provided by IT Hardware ================= [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 <*> 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/
