Re: Error in calling procedure

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 25 Jun 2004 20:23:51 +0200
Message-ID: <j7rod0pf7lsg45vq3oukfhdvu78enm1con@4ax.com>

On 25 Jun 2004 06:27:09 -0700, mzamuner_at_ateikon.com (Marco Zamuner) wrote:

>Any ideas?

Your approach is, sorry to say so, just horrible. The pl/sql job is completely superfluous as there is execute immediate in 8i
Also you must either have *direct* privilege to grant object privelege *NOT* through a role, or create the procedure with authid current_user.

This question has been asked over and over and over again. I wonder why people always post it again right away, instead of searching Google prior to posting

NB: If your procedure would have had error trapping, you would have been getting ora-1031 insufficient privileges. Please always trap errors in procedures.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jun 25 2004 - 13:23:51 CDT