Re: ORA-00942 with OWM & copyForUpdate procedure

Try these:

Make sure the package owner has the appropriate permissions on the table.
Make sure you're using the fully-qualified table name, or the proper synonyms exist.

HTH

• Patrick Connors

"Robert" <country-Dance_at_t-online.de> wrote in message news:<agkv6o$bdq$00$1_at_news.t-online.com>...
> Hey all,
>
> we're using Oracle 8i Rel 3 on Solaris (SPARC) and Oracle Workspacemanager
> with some version enabled tables.
>
> The user getting this exception is not the table owner but has assigned the
> WM_ADMIN_ROLE and all grants on this table.
> The copyForUpdate procedure is used due to the table contains a BLOB column.
>
> The statements looks like: OWMpackage.copyForUpdate('tablename', 'ID=1234').
> The tablename is the original tablename.
>
> Any ideas to solve this problem ?
>
> TIA
>
> Robert
Received on Fri Jul 12 2002 - 13:30:41 CDT