Don't think this counts as a DBI question really as the best solution
would be to do it all in a single piece of SQL, rather than bringing the
data back for local processing. You're not clear in your description
whether you are looking for the same set of tag IDs for every product or
If there's a database link between the two databases, you could connect
to database A from Perl and execute a query against B over the DBLink
without doing a Perl connect to B.
On 01/10/2012 18:29, Jack Craig wrote:
Hi Folks,
I have an html / perl app running on host A,
i want to do a
On 26/06/2012 21:51, Richie wrote:
On 6/24/2012 6:25 AM, Martin J. Evans wrote:
https://rt.cpan.org/Ticket/Display.html?id=69059
Build fails on AIX 5.3 against Oracle Client 10.2.0.1 with rtld:
0712-001 Symbol OCIPing was referenced
I don't have access to AIX or an Oracle 10 and op gone
Just a thought - but how are you checking the update? Just after the
statement in the same Perl code or in a separate session?
Cheers
Martin
On 06/10/2011 23:04, Eirik Toft wrote:
Greetings, been a DBI user for years now working with stuff from
unixODBC, Oracle, MySQL, etc...etc...
So, the
I take it you are comparing like for like with the Plus or Developer
script? By that I mean, using bind variables as well. Or, have you
tried this piece of Perl with some hardcoded values? I just wonder if
it's the binding that's taking the time.
Cheers
(another) Martin
On 13/12/2010
there are various quotas in Oracle that could stop a query. However,
they do tend to kill the guilty session rather than just hang like
that. If your simple select ran multiple times for the same 10k block,
would it still hang?
Cheers
Martin
On 08/07/2010 17:07, Howard, Chris wrote:
If
It sounds to me as if you're running into something else. As far as I
know, the 2396 error should not be triggered during a select as the
connection is not 'idle'. Could it be that your select statement is
finishing more quickly than you thought and you're not picking it up?
If that was the
But, you can create function based indexes, which will avoid full table
scans.
Cheers
Martin
On 04/05/2010 17:01, Martin Gainty wrote:
Martin is correct
in oracle using functions on a where clause will automatically trigger FTS
(full table scans) which will slow your query down to a crawl
On 15/01/2010 11:52, Peter J. Holzer wrote:
[quoting rearranged into sensible order]
On 2010-01-15 17:15:04 +0800, Agarwal, Gopal K wrote:
Aplogies for the ambiguous question below. I'll explain it further.
I am connecting the Oracle DB with perl DBI. For short queries
(execution
Didn't see a reply to this one
You're right. 3113 and 3114 are usually as a result of the server
process crashing. You may have some useful information in the trace
files. There's a lot of potential causes for this error, so useless to
speculate on causes until you can get something
Kevin Spencer wrote:
Hi guys,
I'm sure I'm missing something *very* obvious but this one has me
scratching my head. Using DBI 1.52, DBD::mysql 3.0007, Perl 5.8.8,
MySQL 5.0.18.
.
Now, because I want use use placeholders instead, I attempt the
following:
my $SQL = EOSQL;
select
Ron Savage wrote:
On Mon, 12 Jun 2006 23:04:04 -0700, Jonathan Leffler wrote:
Hi Jonathan
We, I know Oracle has been criticized for taking up to 7 secs to
connect in a non-Win evironment, so I assume this is the same, just much worse.
Of course, it could indicate the Oracle
Robert Hicks wrote:
I have been handed a couple of requests to change some data. One is an
update on 3.6 million records and the other is two different deletions of
over 16 million rows of data. I need to be able to do these in batches as I
am told that Oracle will blow up if I do them in one
I usually use an additional single quote when I'm attempting to insert a
single quote. E.g. 'don''t'. Alternatively, if it gets too difficult
to read, I concatenate the appropriate ascii code (39).
SQL select 'don''t' from dual;
'DON'
-
don't
SQL select 'don'||chr(39)||'t' from dual;
ORA 3113 simply means that the server side process died unexectedly.
There may be some logs on the server side that will help resolve this issue.
Martin
Drozdowski, Catharine wrote:
Hi All,
I am using Oracle v9.2.0.6, Perl V5.8.4... I can find the version of the dbi if
needed... When I run
SIGNED MESSAGE-
Hash: SHA1
hello martin
sorry for the long delay...
Martin Hall wrote:
Can you use ALTER SESSION and set nls_language?
yes I can, but without the desired effect: changing it to e.g. GERMAN
just affects sort order (umlauts), date-format and so on and does not
affect
Can you use ALTER SESSION and set nls_language?
Martin
Hermann Schwaerzler wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hello
is it possible to change the character-encoding of the data one receives
from an oracle-DB at runtime? i.e. is it possible to have connections to
two
Well, I have to echo what others have said. The only reason I can think
of for using loops to do your delete is if you really want to save a
chunk of rollback segment. Even then, I would consider batching the
rows up into chunks that you could manage with predicates like BETWEEN
or IN.
Jean-Louis,
I would check with Oracle Support. This sounds like a known issue
on the database.
Martin
LEROY Jean-Louis wrote:
Hello,
the following program:
use strict;
use DBI;
my $dbh = DBI-connect(qw( dbi:Oracle: T3_JLL T3_JLL ), { PrintError
= 0 });
My Solaris setup has only got one oci.h in rdbms/public as does my
pretty much out of the box Windows installation.
Martin
Tim Bunce wrote:
On Wed, Nov 24, 2004 at 01:39:53PM +0200, Doru Petrescu wrote:
... Oracle 10.1.0.3 ...
in the end it turns out there are TWO oci.h files one in
If I've understood you correctly, this might be worth a try as an example...
select min(userid) from
(
select userid
from mhtemp a
where a.userid 3000
and 0 = (select count(*) from mhtemp b where b.userid = a.userid-1)
)
it survived a very quick test. Basically, the inner pair of selects
21 matches
Mail list logo