How about DBI ? I am not sure of ORACLE, but i have used DBI<http://search.cpan.org/%7Etimb/DBI-1.615/DBI.pm>for mysql (similar kind of project), only connector will be different i believe.
Thanks, Chandrashekar On Tue, Nov 9, 2010 at 1:09 AM, Parag Kalra <paragka...@gmail.com> wrote: > >>I'm in the thinking stages of creating a table-load utility, which reads > a > tab-separated CSV file and inserts or updates rows in a >>relational table > (probably Oracle). I don't think that will be too hard, having used Perl > DBI/DBD modules in the past. > > Since you are planning to design your own table-load utility probably for > Oracle, I would like to share my own experience on this and would just > like > to add something to other aspects of your requirement. > > 1. First preference should always be SQLLDR (in direct mode probably) > provided you have Oracle client installed on the *Nix box. > 2. If you can't use SQLLDR in direct mode, you can definitely use Perl to > load the data. The challenge here is how optimize you can design your > utility. And the best way to upload the data using Perl DBI/DBD is to use > DBD::Oracle in array interface mode. Refer the following link for the bench > marking results: > > http://www.nntp.perl.org/group/perl.dbi.users/2010/05/msg34905.html > > > Cheers, > Parag > On Sun, Nov 7, 2010 at 4:16 PM, Chap Harrison <c...@pobox.com> wrote: > > > Hi folks, > > > > I'm in the thinking stages of creating a table-load utility, which reads > a > > tab-separated CSV file and inserts or updates rows in a relational table > > (probably Oracle). I don't think that will be too hard, having used Perl > > DBI/DBD modules in the past. What's different is that customers will > > transmit their files to a directory on a Linux server, using an FTP/SFTP > > client of their choosing, after which my utility needs to "notice" the > > arrival of the file, and initiate the table updating. > > > > Are there any Perl facilities, or modules, I should be considering for > > this? Or is this sort of problem typically solved with something as > > primitive as a daemon that periodically polls for changes to the > > directories? > > > > And - is there perhaps a name for this kind of design? (I mean, other > than > > "somewhat retarded" ;-) Kind of like "store-and-forward", but different? > > That would help my googling. > > > > I do appreciate any follow-up questions or suggestions.... > > > > Chap > > > > > > -- > > To unsubscribe, e-mail: beginners-unsubscr...@perl.org > > For additional commands, e-mail: beginners-h...@perl.org > > http://learn.perl.org/ > > > > > > >
