Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error in grant execute to public on package

cocoOct 26 2011 — edited Oct 26 2011
Hi,
I have a package that works with my user but when I try grant execute on this package I get
  
declare
      v_id number;
     begin
          v_id := liste_pkg_lista.liste_lista_func(9);
        dbms_output.put_line(v_id);
end;
SQL> /
9

PL/SQL procedure successfully completed.

SQL> grant execute on liste_pkg_lista.liste_lista_func to public;
grant execute on liste_pkg_lista.liste_lista_func to public
                                 *
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
can you tell me how to grant execute on it to public?

Thank you
This post has been answered by sb92075 on Oct 26 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2011
Added on Oct 26 2011
2 comments
2,814 views