Dear aria, Selain dibuatkan public synonymnya, maka table tersebut juga harus di grant ke schema A. grant insert, delete, update, select on CAR to B ; semoga ini bisa membantu menyelesaikan masalahnya. Regards, JimmyG
a_r_i_a <[EMAIL PROTECTED]> wrote: Hi, Terimakasih atas responya. Saya sudah buat menjadi b.CAR tetapi masih terjadi error yang sama. On 6/29/05, agus winarta <[EMAIL PROTECTED]> wrote: > Anda harus menyebutkan dulu schema yang memilki object tabel yang > bersangkutan. dalam kasus ini, table CAR adalah milik schema b, maka pada > select statement anda harus menulis b.CAR > > SELECT count(*) > INTO p_sip > FROM b.CAR ------------------------> letak error > WHERE IDPEL = NUMA > AND EST = 'SIP02'; > > semoga membantu... > guswi > > > a_r_i_a <[EMAIL PROTECTED]> wrote: > Para Master, > > Tolong donk. Saya punya schema a & b. > Dischema a terdapat tabel REC dan di b terdapat table CAR. > Ketika saya buat trigger didalam schema a table REC, terjadi error > PLS-00201: identifier 'b.CAR' must be declared, trigger seperti dibawah ini > > CREATE OR REPLACE TRIGGER "a".TR_SIP3_REC > AFTER UPDATE OF EST_ACT ON REC > FOR EACH ROW > DECLARE > p_sip numeric(1); > > BEGIN > SELECT count(*) > INTO p_sip > FROM CAR ------------------------> letak error > WHERE IDPEL = NUMA > AND EST = 'SIP02'; > END; > / > > > Mohon pencerahanya > > Regards, > Aria > > > -- > -----------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 > > > > SPONSORED LINKS > Database development software Database management software Database software > Inventory database software Membership database software Citrix terminal > server > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! Sports > Rekindle the Rivalries. Sign up for Fantasy Football > > [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.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 Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [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.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/
