Re: PLS Error Oracle ATP database 19c

From: Ethan Post <post.ethan_at_gmail.com>
Date: Thu, 2 Jul 2020 12:29:10 -0500
Message-ID: <CAMNhnU13mPubOKttfgmtZOzBLQTkBOcNQa6E8ePiqRFu4w+y4w_at_mail.gmail.com>





Update here.

This does work with 'admin' user. I am sure it used to work with other users. Tried granting execute any procedure to one of the users via 'admin', grant allowed, did not fix issue.

May try to create a new DB later and see what happens there.

On Thu, Jul 2, 2020 at 9:38 AM Ethan Post <post.ethan_at_gmail.com> wrote:

> Shouldn't this work?
>
> I had an oracle apex page call break (that used to work) which was using
> special "#owner#." prefix on a call and it started throwing PLS-00302
> errors. Removed it and it started working again. There are no synonyms or
> other objects called my_unique_proc and statzilla is the owner and user
> executing.
>
> [image: image.png]
>



--
http://www.freelists.org/webpage/oracle-l


Received on Thu Jul 02 2020 - 19:29:10 CEST

Original text of this message