Re: dynamis sql UPDATE statement with join

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 19 Jun 2007 20:04:39 +0200
Message-ID: <f595rn$soh$2@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

ciapecki wrote:
> On 19 Jun., 15:56, ciapecki <ciape..._at_gmail.com> wrote:
>>> "ORA-00942: table or view does not exist ORA-06512" >>> Grants through role perhaps?

>
> It seems one needs to have a direct privilege not through the role:
>

Just what Carlos told you.

Next time, when you try to mimic the behavior while logged on as user, issue the 'set role none' statement first.
If everything runs fine after that, chances are it will run as pl/sql.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGeBq3Lw8L4IAs830RArx/AKCdxoRVvFb0QLWM3pdrd6fM1awFDgCfXgTf ORsfhiIsiEAwUAr06PcwyNU=
=LbU6
-----END PGP SIGNATURE----- Received on Tue Jun 19 2007 - 13:04:39 CDT