Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing tables in another schema from a package.

Re: Accessing tables in another schema from a package.

From: Vladimir A. Zaikin <vlad_at_hammer.ryazan.su>
Date: 10 Jun 1998 14:56:52 +0400
Message-ID: <AApKbGvmuS@hammer.ryazan.su> 





>The insert statement


>works fine alone in SQL+, logged in as the same user who tries to create the


>package below.




Hi,


If above is right, then user adb has select grant on dfo.cable.
Try DBMS_SQL (dynamic SQL) to execute this insert statement in procedure.



Vladimir Zaikin


Received on Wed Jun 10 1998 - 05:56:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US