You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

calling SQL Loader from Peoplecode

1 reply [Last post]
krispsoftpro's picture
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 09/01/2008
Posts: 6

Hi,

We are upgrading tools and Application of application of Peoplesoft and we are also moving to oracle 10g from db2. In one of the customized application engine peoplecode we have used load command on "DB2" to load Data from flat file to PS Table. Now I am wondering what is similar command in oracle. Also I heard that we can achieve this using SQL loader but I don’t have idea how to call SQL loader from people code. How to call SQL loader from peoplecode also please let me know if there is any alternate.

saiyedparwez's picture
saiyedparwez (not verified)
Re: calling SQL Loader from Peoplecode

Create a procedure and call that procedure or you can call a unix script or similar thing and use Exec funtion to call that script in Synchronous mode.
The script will load the data.
Thanks
Saiyed