Skip to Main Content

Database Software

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!

DBMS_XDB.CREATEFOLDER Access denied error

BalajiChellappaJun 18 2008 — edited Jun 19 2008
Hi,
I am trying to create folder in XML DB using procedure call DBMS_XDB.CREATEFOLDER.
It works fine when I run the command using PL SQL block.
---------------------------------------------------------------------------------------
declare
l_Bln boolean;
begin
l_Bln := DBMS_XDB.CREATEFOLDER('/images/themes/sfatest');
if l_Bln then
dbms_output.put_line('Folder Created');
else
dbms_output.put_line('Folder NOT Created');
end if;
COMMIT;
end;
/
-----------------------------------------------------------
But it gives me access denied error if I try to run the same inside a procedure.

CREATE OR REPLACE PROCEDURE TT AS
l_Bln boolean;
begin
l_Bln := DBMS_XDB.CREATEFOLDER('/images/themes/sfatest');
if l_Bln then
dbms_output.put_line('Folder Created');
else
dbms_output.put_line('Folder NOT Created');
end if;

COMMIT;

end;
/
----------------------------------------
exec tt;
ORA-31050: Access denied
ORA-06512: at "XDB.DBMS_XDB", line 316
ORA-06512: at "SFA.TT", line 4
ORA-06512: at line 1


USER from which I am running this procedure has the XDBADMIN role.
I am using Oracle 11g/ PL SQL Gateway. I don't know how to configure ACL for this situation.
Can anyone help me please?
Thanks
Balaji Chellappa
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2008
Added on Jun 18 2008
6 comments
3,769 views