Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

CHAPTER 3 XML Database Repository > Creating Resources

Creating Resources

When loading documents via FTP, HTTP, or WebDav to XML DB Repository, we are creating XML DB Repository resources. In addition to this approach, creating XML DB Repository resources in SQL.

In Oracle XML DB, the following PL/SQL functions/procedures can be used to create/delete XML DB Repository resources:

Image  DBmS_xDB.createResource() This function creates a new XML DB file.

Image  DBmS_xDB.createFolder() This function creates a new folder.

Image  DBmS_xDB.existsResource() This function checks whether a file exists in XML DB Repository. Normally, you need to check if a file exists before creating a new one.

Image  DBmS_xDB.deleteResource() This procedure deletes an existing XML DB Repository resource.

The following example creates a folder and a file in XML DB Repository (create_resources.sql):


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint