Re: Delphi Dataset to PL/SQL Package

From: Helmut Woess <user22@xxxxxxxx>
Date: Fri, 5 Oct 2007 12:31:31 +0200

Am 4 Oct 2007 03:30:50 -0700 schrieb pilmart:

Can the following be done, if so how

Obtain a dataset from Database (SQL Server) pass the contents of dataset (> 20000 recs) to a PL/SQL Package, PL/SQL Package then uses a bulk insert method to insert the contents of the dataset to a Table.

Any thoughts/Suggestions/links

Martin

You can access Oracle tables directly from SQ-Server:
http://www.sqlmag.com/Article/ArticleID/49687/sql_server_49687.html
or SQLServer-Tables directly in Oracle:
http://www.databasejournal.com/features/oracle/article.php/3442661
.... so there is no need for export and bulk insert :-)

bye,
Helmut
.

References:
- Delphi Dataset to PL/SQL Package
  - From: pilmart

Prev by Date: Re: Data transfer performance issue
Next by Date: Assign username/password to access file
Previous by thread: Delphi Dataset to PL/SQL Package
Next by thread: Assign username/password to access file
Index(es):
- Date
- Thread