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