Re: How to invoke export/import or sql loader?

"alederer" <alederer_at_gmx.at> wrote in message news:40559a53_at_e-post.inode.at...

> Is there a possibility to invoke and control the export/import or the
> sql*loader utility via api calls from a c++ application.

You can always call them as external processes using a piped command or system(), standard C/C++ library.

> E.g. in db2 there is the db2api sqluload to control a load of a table.
> Is there a dbms package which can help?

In 9i you don't even need a package: SQL will let you read from a flat file with a SELECT statement.

Writing to a file from PL/SQL requires use of the "utl_file" package.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam