Re: EXECUTE IMMEDIATE statement FAILS

xylem (me_at_icq@xxxxxxxxxxx) wrote:
: Hi all,

: My procedure below is failing to provide the desired result and I've
: failed to track down what is the cause. The procedure is supposed to
: dynamically grant roll on objects to users. I've tested the cursor SQL
: and it's working fine. However, sql_stmt is failing. When I run the
: procedure I get the following error:

: Warning: Procedure created with compilation errors.

: SQL> sho err
: Errors for PROCEDURE G_R:

: LINE/COL ERROR
: -------- ----------------------------------------------------
: 35/3 PL/SQL: Statement ignored
: 35/50 PLS-00302: component 'VIEW_NAME' must be declared

You probably have access to 'VIEW_NAME' only thru a role.

The role will allow you to access the object interactively , but it will
not allow you to compile code that needs to access the object.

Your username itself needs to be granted access to the object to compile
code that accesses the object.


.

Relevant Pages

  • Re: Ucase function - Compile error - Cant find project or library
    ... "Andrew Faust" wrote: ... >> The Compile is failing on a Ucase statement. ...
    (microsoft.public.vb.general.discussion)
  • Re: In SMS_INVENTORY_DATA_LOADER I have message 2721
    ... Check the mofcomp log file %windir%\system32\wbem\Logs\mofcomp.log. ... That should give you a clue as to what is failing to compile. ... The failing MOF file has ...
    (microsoft.public.sms.admin)
  • Re: In SMS_INVENTORY_DATA_LOADER I have message 2721
    ... That should give you a clue as to what is failing to compile. ... MOF file syntax. ...
    (microsoft.public.sms.admin)
  • Re: c doubt
    ... but the condition is failing always even array size is greater than ... zero. ... The code you have posted does not compile. ... What you have posted here is so incorrect in so many ways that it ...
    (comp.lang.c)
  • print binary
    ... i try to compile code below but my compiler is failing. ... how to correct fault? ... int val,npow; ...
    (comp.lang.c)