Re: The code doesn't work in the package

Hi, Thank you for your help. Now it works. At 11:00 2001.12.16. -0800, you wrote: You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs. joe Csillag Zsolt wrote: Hi, The following code work as you can see below, but

The code doesn't work in the package

Hi, The following code work as you can see below, but if I put this code in a package ( a procedure in a package) then I got ORA-01031 insufficient privileges error. This is absurd for me because it's the same user (an administrator) that owns the package, tablespace, table and everything. From

Re: The code doesn't work in the package

You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs. joe Csillag Zsolt wrote: Hi, The following code work as you can see below, but if I put this code in a package ( a procedure in a package) then I got

Re: The code doesn't work in the package

Sorry, this is perfectly normal and makes sense when you understand the security implications. May I suggest the Concepts manual at tahiti.oracle.com? Also, if you go take a look at www.orafaq.com you will find an answer to this question, and being the lazy DBA that I am, it will save me some