PLSQL Advices

When you need to load a binary file which is in a client computer to the database in Oracle Forms. You can take advantage of WebUtil library which has many utilities to work with client files. In this post I'll show how to load a XML file(in the client computer) in a database table with Oracle Forms, then we will convert the xml file into relational data. Note: To follow this tutorial you must have configured the Weblogic server to enable file transfer. Let's start: 1. Open the webutil.olb file: 2. Attach the webutil.pll to the forms module 3. Open the webutil.olb and copy the object group WEBUTIL to the module's object groups tag:   With this I have the module ready to use the Webutil functionalities. 4. This is the module I'll use in the example, the first button contains the function to raise a window to get the file path and the second one contains the procedure to load the file to the database. Let's see how to use this. 5. Here the code for get the file pa...