execute procedure over dblink
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Fri, 25 Apr 2008 10:50:49 -0500
Message-ID: <BLU108-W33626F9419D59A32C787FF97DD0@phx.gbl>
Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A
Date: Fri, 25 Apr 2008 10:50:49 -0500
Message-ID: <BLU108-W33626F9419D59A32C787FF97DD0@phx.gbl>
I have a dblink from db A to db B. I am inserting data into tables in db A from db B by selecting. The link works fine.
I have just put a procedure in db B and I am trying to execute the procedure from db A , but I am getting an "insufficient privileges" error. What am I missing?
thanks.
Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 25 2008 - 10:50:49 CDT