Re: HELP!Oracle Store Procedure

On Fri, 15 May 1998 16:49:55 GMT, cosmogong_at_my-dejanews.com wrote:

>I tried the code you gave me. Oracle creates the package fine, but still give
>me the error:
>"ORADBA.table_name must be declared first"
>Do you know how to declare it?

You are referencing a table in a schema other than your own, to which you may have been given access rights through a role. But role privileges are *not* in effect during stored procedure execution. You can verify this in SQL*Plus: issue the statement 'SET ROLE NONE' and try whether you still can access this table. If not, you should have your DBA grant these privileges *directly* to you.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Fri May 15 1998 - 17:16:26 CDT