ORA-00942 with OWM & copyForUpdate procedure

From: Robert <country-Dance_at_t-online.de>
Date: Fri, 12 Jul 2002 00:06:57 +0200
Message-ID: <agkv6o$bdq$00$1@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 Thu Jul 11 2002 - 17:06:57 CDT