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

Home -> Community -> Usenet -> c.d.o.misc -> Re: calling a stored procedure from a stored procedure

Re: calling a stored procedure from a stored procedure

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 12 May 2007 12:02:12 +0200
Message-ID: <f243ah$70g$1@news2.zwoll1.ov.home.nl>


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

RU schreef:
> On Thu, 10 May 2007 08:58:26 -0700, DA Morgan wrote:

>> You don't have explicit permissions granted to execute the package.

>
> spot on. thanks very much.
>
> RU

The mantra is:
set role none
when developing stored procedures.

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

iD8DBQFGRZCkLw8L4IAs830RAizeAKCYMaXAAQgJ2EYMIzgAFk0IUD41LACeNyWk J3zCo1OmUGgLu9DsAHfjWlA=
=EOE5
-----END PGP SIGNATURE----- Received on Sat May 12 2007 - 05:02:12 CDT

Original text of this message

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