Code Listing 2: Creating Repository folders, using the Resource API

create user &1 identified by &2 
default tablespace ...
temporary tablespace ...
/
grant connect, resource, dba, xdbadmin to &1
/

declare
  result boolean;
begin
  begin
    result := dbms_xdb.createfolder('/home');
  exception
    when others then null;
  end;    

  dbms_xdb.deleteresource('/home/&1',dbms_xdb.DELETE_RECURSIVE_FORCE);

  result := dbms_xdb.createfolder('/home/&1');
  result := dbms_xdb.createfolder('/home/&1/questions');
  result := dbms_xdb.createfolder('/home/&1/surveys');
  -- etc...
end;
/

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy