Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dynamis sql UPDATE statement with join

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US