If you don't have to manipulate any of the data then SQL*Loader is the way
to go. If you have to do any sort of manipulation of the data then it is
very difficult to use SQL*Loader. Personally I user perl to load my data
because I have to format some of the data and replace some of the values.
It
Yes. This also works.
Andrew
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: February 25, 2004 5:21 PM
To: Howell, Andrew
Cc: 'Tim Bunce'; '[EMAIL PROTECTED]'
Subject: Re: DBD:Oracle "perl Makefile.PL" problem
On Wed, Feb 25, 2004 at 04:29:06PM -0500, Howell, Andrew
I would always stick with the oracle tools for speed. Sqlloader behaves
strangely
Sometimes but unless you need to use perl for a specific reason I would
stick with
It.
Another option is to split the data into parts and run multiple parallel
loads. This
Depends on you hav
Two problems:
First, I tried:
my $measurementssth=$dbh->prepare("SELECT POLLENTRAP_ID, ALLER_ID, TYPE,
SPORES,FID, (SYSDATE-DATECOLLECTION) FROM $measurements_table WHERE
(SYSDATE-DATECOLLECTION) <15 ORDER by 6 LIMIT 1 ") ;
(trying to get the one line of data for which DATECOLLECTION IS clos
Why don't you try to debug this stuff in SQL*Plus before you go to DBI.
Issue 1 isn't really a DBI issue - it's an SQL issue.
Instead of "LIMIT 1" try adding "and rownum <= 1" to the where clause.
For the issue 2 - I'm not sure but it might be worth checking there are no
non-visible characters i
Here's a simple recipe to reproduce this:
my $dbh = DBI->connect(...);
print "overloaded\n" overload::Overloaded($dbh);
The error that comes out is:
can: handle 'DBI::db' is not a hash reference at dbi.pl line 9.
This is coming from DBI, because the Overloaded function looks like this:
> Why don't you try to debug this stuff in SQL*Plus before you
> go to DBI.
> Issue 1 isn't really a DBI issue - it's an SQL issue.
>
> Instead of "LIMIT 1" try adding "and rownum <= 1" to the
> where clause.
But remember that ROWNUM is assigned before any ORDER BY. So you have to
wrap it in
Hello,
I have been trying to extract data from a access.mdb file using perl5,
DBI-1.40, DBD-ODBC-1.07, unixODBC-2.2.7, and libmdbodbc.xx driver from
mdbtools. I have seen many sources and posts proclaiming the possibility
to avoid needing to define DSN's by connecting similar to the following:
m
[EMAIL PROTECTED] wrote:
Hello,
I have been trying to extract data from a access.mdb file using perl5,
DBI-1.40, DBD-ODBC-1.07, unixODBC-2.2.7, and libmdbodbc.xx driver from
mdbtools. I have seen many sources and posts proclaiming the possibility
to avoid needing to define DSN's by connecting si
>
>
> Jeff,
>
> I upgraded to perl 5.8.3 and installed both the DBI and the
> DBD::Oracle modules from your site. As you suspected, that
> did not fix the problem.
Unfortunately :(
> When I was running the dumpbin utility, I realized that in my
> previous email I mis-typed the error mes
> >
> > Jeff,
> >
> > I upgraded to perl 5.8.3 and installed both the DBI and the
> > DBD::Oracle modules from your site. As you suspected, that
> > did not fix the problem.
>
> Unfortunately :(
>
>
> > When I was running the dumpbin utility, I realized that in my
> > previous email I m
Hello,
Sorry if it is FAQ.
So called "Direct Pass" can be used by DBD::Oracle?
I ususally load data by my script made with DBI/DBD::Oracle.
But sometimes when the data is so big I wonder if I shoud use
my script or use SQL*LOADER.
I like Perl so much but I can't wait so lo
On Thu, Feb 26, 2004 at 12:29:29PM +1000, [EMAIL PROTECTED] wrote:
>
> I am sure this has been covered but I am a newbie to both DBI::Oracle and
> BLOBs. I have done a few Google searches and have found several useful code
> example on how to write to a BLOB datatype but nothing that shows me a
>
13 matches
Mail list logo