Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing tables in another schema from a package.
>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