Kepada Z bakry aq mo tanya usrimp_role ? nama schema atau nama role coba grant dengan sintax :
grant select, insert, update, delete, references, alter, index on mstpengeluaran to nama_schema_yg_akan_menggunakan_table; Semoga bermanfaat. Linda On 8/16/05, Z Bakry <[EMAIL PROTECTED]> wrote: > Dear Andrew E.K > > Terim kasih atas reply-nya. > Saya sudah tambahkan nama schema-nya tapi masih error, > lalu juga saya drop dan create ulang public synonim > table bersangkutan, dan juga tes select * from > mstpengeluaran (table yang kena error) dapat > menampilkan datanya. > > Bagaimana ini ya....mungkin ada hal lain yang > menyebabkan error ga ya.... > > Terima kasih > Bakry > > --- "Andrew E.K." <[EMAIL PROTECTED]> wrote: > > > Mungkin anda bisa coba menambahkan nama Schema nya > > jg > > untuk table tersebut.Ex: > > Finance.[Table_name](terkadang ini saya gunakan jika > > terjadi hal seperti ini) atau anda mungkin bisa > > buatkan public synonim nya untuk memudahkan > > pengaksesan table. Dan pastikan user yg akses > > procedure tersebut dapat hak akses ke table > > tersebut. > > Semoga membantu :) > > > > Andrew > > > > --- Z Bakry <[EMAIL PROTECTED]> wrote: > > > > > Dear all, > > > > > > Saya punya procedure seperti di bawah ini yang > > > melakukan collect data dari beberapa table dan > > > disimpan pada tabel tablerptkenjam. > > > Tetapi saya selalu mendapatkan error ORA-00942, > > > walaupun saya telah melakukan grant terhadap tabel > > > yang bermasalah tetap saja serror tersbut timbul. > > > Bagaimana cara penyelesaiannya untuk error > > > ORA-00942. > > > Bagian yang error saya berikan tanda >>>>>> untuk > > > menunjukan table yang dikatakan error. > > > > > > Tolong ya..... > > > > > > > > > Terima kasih > > > > > > Bakry > > > > > > > > > -------------------------PROCEDURE > > > > > > CREATE OR REPLACE PROCEDURE CON_FUC1( IDPROSES1 > > > VARCHAR2, IDPROSES2 VARCHAR2, NOBL1 VARCHAR2, > > NOBL2 > > > VARCHAR2 ) IS > > > > > > v_idproses varchar2(20); > > > v_idproses2 varchar2(20); > > > v_nobl varchar2(20); > > > v_idprosesDO varchar2(20); > > > v_nocontainer varchar2(50); > > > v_partai1 varchar2(12); > > > v_partai2 varchar2(12); > > > v_pelayaran varchar2(50); > > > v_mtuang varchar2(11); > > > v_mtuang2 varchar2(11); > > > v_kursjaminan varchar2(16); > > > v_kursjaminan2 varchar2(16); > > > v_nilaijamin decimal(15,2); > > > v_nilaijamin2 decimal(15,2); > > > v_freedemurage date; > > > v_tglkblCON date; > > > v_SP2 date; > > > v_EIR date; > > > v_krgnilaijamrp decimal(15,2); > > > v_krgnilaijamus decimal(15,2); > > > v_kurskembali varchar2(10); > > > v_pengembalian varchar2(15); > > > v_banktunairp decimal(15,2); > > > v_banktunaius decimal(15,2); > > > v_bankgiro decimal(15,2); > > > v_nogiro varchar2(30); > > > v_idtranskeluar varchar2(15); > > > V_KET varchar2(50); > > > Q INTEGER; > > > v_SQLSTAT varchar2(5000); > > > v_TIDPORSES2 varchar2(20); > > > v_TNOBL1 varchar2(20); > > > v_TNOBL2 varchar2(20); > > > v_CARA varchar2(20); > > > > > > > > > BEGIN > > > > > > --INSERT DATA > > > BEGIN > > > > > > DECLARE > > > > > > CURSOR c_inputKJ IS > > > select A.PPSI_IDProses, A.PPSI_NoBL, > > > B.DPK_NoPK, D.DBL_JML, D.DBL_UKURAN, > > > C.mst_namapersh, E.MP_MtUang, > > > E.MP_Kurs , E.MP_JmlPemb , F.PDO_TGLBATASFTD, > > > H.DEIR_RETURNDATE, > > H.DEIR_TGLRPT, > > > G.DSP2_TGLRPT, H.DEIR_CUSTAMOUNTRP, > > > H.DEIR_CUSTAMOUNTUS, > > > H.DEIR_KETERANGAN > > > from PPSI A, > > > DPETIKEMAS B, > > > MASTER C, > > > DBL D, > > > >>>>>> mstpengeluaran E, > > > PAMBILDO F, > > > DSP2 G, > > > DEIR H > > > where A.PPSI_IDProses = B.DPK_IDProses > > > and > > > D.DBL_IDProses = A.PPSI_IDProses > > > and D.DBL_IDPelayaran = C.mst_id > > and > > > E.MP_IDProses = A.PPSI_IDProses > > > and F.PDO_IDPROSES = > > A.PPSI_IDProses > > > and A.PPSI_IDProses = G.DSP2_IDPROSES > > > and A.PPSI_IDProses = > > > H.DEIR_IDPROSES > > > and E. MP_KDBIAYA = '000000000022' > > > and ( A.PPSI_IDPROSES between > > > IDPROSES1 and IDPROSES2 ) > > > or ( A.PPSI_NOBL between NOBL1 and > > > NOBL2 ) ; > > > > > > BEGIN > > > > > > DELETE FROM tablerptkenjam ; > > > OPEN c_inputKJ; > > > LOOP > > > > > > FETCH c_inputKJ INTO v_idproses, > > v_nobl, > > > v_nocontainer, v_partai1, > > > v_partai2, v_pelayaran, v_mtuang, > > > v_kursjaminan, v_nilaijamin, v_freedemurage, > > > v_tglkblCON, v_SP2, v_EIR, > > > v_krgnilaijamrp, v_krgnilaijamus, > > > v_ket ; > > > > > > EXIT WHEN c_inputKJ%NOTFOUND; > > > > > > INSERT INTO tablerptkenjam ( IDPROSES, > > NOBL, > > > NOCONTAINER, PARTAI1, PARTAI2, > > > PELAYARAN, MTUANG, KURSJAMINAN, > > > NILAIJAMIN, FREEDEMURAGE, TGLKBLCON, > > > SP2, EIR, KRGNILAIJAMRP, > > > KRGNILAIJAMUS, KET ) > > > VALUES ( v_idproses, v_nobl, > > > v_nocontainer, v_partai1, > > > v_partai2, v_pelayaran, v_mtuang , > > > v_kursjaminan, v_nilaijamin, > > > v_freedemurage, v_tglkblCON, > > v_SP2, > > > v_EIR, v_krgnilaijamrp, > > > v_krgnilaijamus, v_ket ); > > > > > > END LOOP; > > > CLOSE c_inputKJ; > > > COMMIT; > > > > > > END ; > > > END; > > > > > > --UPDATE DATA > > > BEGIN > > > > > > DECLARE > > > > > > CURSOR c_inputKJ2 IS > > > select > > A.PPSI_IDProses,E.MP_MtUang, > > > E.MP_Kurs , E.MP_JmlPemb, > > > E.MP_CARA, E.MP_NOGIRO > > > from PPSI A, > > > >>>>>>>> mstpengeluaran E, > > > tablerptkenjam B > > > where E.MP_IDProses = A.PPSI_IDProses and > > > A.PPSI_IDProses = B.IDPROSES > > > and E. MP_KDBIAYA = '000000000032' > > ; > > > > > > BEGIN > > > > > > OPEN c_inputKJ2; > > > LOOP > > > > > > FETCH c_inputKJ2 INTO v_idproses, > > > v_mtuang, v_kursjaminan, > > > v_nilaijamin, v_CARA, v_NOGIRO ; > > > > > > EXIT WHEN c_inputKJ2%NOTFOUND; > > > > > > update tablerptkenjam set banktunairp > > = > > > v_nilaijamin > > > where IDPROSES = > > > rtrim(v_idproses) and rtrim(v_CARA) = 'Tunai' ; > > > update tablerptkenjam set kurskembali = > > > v_mtuang > > > where IDPROSES = > > > rtrim(v_idproses) and rtrim(v_CARA) = 'Tunai'; > > > update tablerptkenjam set bankgiro = > > > v_nilaijamin > > > === message truncated === > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.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 > > > 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! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hfj4u63/M=362329.6886308.7839368.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124185965/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> -- -----------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/
