Has anyone had the 942 error with jdbc and 8.1.5/8.1.6?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sun, 11 Nov 2001 13:14:17 GMT
Message-ID: <3bee786e.2274967@news>

I've been getting this one with these releases.

Metaclick says it's fixed on 8.1.7, but does anyone know for sure if it is so?

It happens straight away if you define REF CURSOR as the return for a PL/SQL function, owned by other user than the one you're connected to.

Via synonym. Apparently, the cursor is opened as the logged on user instead of the owner of the package (I'm running in default PL/SQL mode), leading to PL/SQL returning the 942 (table or view doesn't exist).

TIA for any feedback.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sun Nov 11 2001 - 07:14:17 CST