Link to home
Start Free TrialLog in
Avatar of tangocoder
tangocoder

asked on

procedure uses dbms_lob but get message needs to to be declared

What does this message mean?  Does the user I am logged into need to have execute privileges to use it in a procedure?  I tried to use sys.dbms_lob and I get the same message.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tangocoder
tangocoder

ASKER

Yes, I think that is the issue.  They always want to limit access of usage.  Thank you.
>>They always want to limit access of usage

That is a good thing.  Minimal permissions should be the standard.  You just need to understand what can and cannot be granted through a role.