Home » SQL & PL/SQL » SQL & PL/SQL » using API's in datafile conversion
using API's in datafile conversion [message #231844] Wed, 18 April 2007 10:09 Go to next message
Messages: 19
Registered: August 2006
Location: Chennai
Junior Member

hi all,

can anybody tell me, how can i use API's to insert data's from a flatfile to HRMS base table.

im in a process of inserting some datas from a flatfile to HRMS base table. In this case, the hrms basetable is PER_ALL_PEOPLE_F. since, there're no interface tables exist in hrms, we got to use only API's.so, i need to know how can we use APIs to insert data into the base table.

any help will be greatly appreciated.


Re: using API's in datafile conversion [message #231846 is a reply to message #231844] Wed, 18 April 2007 10:18 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no idea with application part of this (API used etc).
Generally, you can use sql*loader to load the data from a flat file into the database tables
use external table (may not be applicable in your case).
Search the forum. If you still prefer to use your native methods (API) post in appropriate forum.

Previous Topic: Grouping problem by year
Next Topic: ORA-01858: a non-numeric character was found where a numeric was expected
Goto Forum:

Current Time: Sat Jul 22 10:14:39 CDT 2017

Total time taken to generate the page: 0.22913 seconds