Sairam Nimmagadda

Recently , I had to use SQL*Loader for Oracle R12. Faced some issues, but finally got it sorted out. First things first. What do we need? 1) Data file: Can be .csv, txt etc. Here in my case it was .csv file. I had to place the file on the application server. The location is one that has been set up for saving data files. 2) we need a Control file for the SQL*Loader utility to load the data into the database. Structure of the Control file. --/****************************************************************************** --    NAME:        myfile.ctl --    PURPOSE:     Description -- --    REVISIONS: --    Ver         Date          Author            Description --    ---------   ----------    ---------------   ------------------------------------ --    1.0         Date Sai Nimmagadda     Created this package.   --******************************************************************************/ --Options (SKIP=2) Load data INFILE * APPEND INTO

BI Publisher Installation on Windows7 Recently i tried to install the latest version of BI Publisher (XML Publisher 11.1.1.6) Desktop on my PC which has Microsoft Office 2007 and  i have been facing issues with it. The error says it needs JRE version higher than 1.6 So after doing some research i came to know we need to install the JDK 7 to get this issue resolved. So if your PC is Windows 7 64 bit, then we need to download the JDK for windows 64 bit and install this. After we install the JDK7 successfully, then try installing BI Publisher  Sometimes we might get into Macros settings issue. For this please run the following commands in your command prompt as admin or with admin rights. For 64-bit operating systems, type the following: Regsvr32 "C:\Windows\SysWOW64\MSCOMCTL.OCX" For 32-bit operating systems, type the following: Regsvr32 "C:\Windows\System32\MSCOMCTL.OCX"