Hi there
I use an ordinary
$sth-execute();
but it seems to take ages to search, creating or updating a post.
Is this problem due to the sqlstatement or is it a known problem with a
perl DBI interface?
I run Oracle 7.3.3 on an AIX 4.2 with roxen as webserver.
--
MVH
Michelle
Hi,
Without seeing your sql statement(s) and how your database is setup
there is only so much that one can infer as to the problem. It could be
cause by your database, or even your network if the other databases are on
slow network. I've a oracle 8i database with over 10 millions rows in
many
How often is the data changed ? Is it required to be 'real time' ? If
not, then perhaps you could use a snapshot rather than a big query ?
have you tried using indexes as well ?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 June 2001 14:29
To:
Can you provide an example?
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 09:17
To: [EMAIL PROTECTED]
Subject: Slow execution
Hi there
I use an ordinary
$sth-execute();
but it seems to take ages to search, creating or updating a
I created a procedure and it can be run on sql command line.
Then, I put it in a perl program like this:
$dth = $dbh-prepare(exec syn_act_uso)
or die Couldn't prepare statement: . $dbh-errstr;
my $success = $dth-execute();
unless ($success) { die Couldn't exec efmsdbo.syn_act_uso: .
I think it is:
$dbh-prepare(qq{
BEGIN
syn_act_uso;
END;
});
-Ursprüngliche Nachricht-
Von: Xiaoping Gu [mailto:[EMAIL PROTECTED]]
Gesendet am: Dienstag, 12. Juni 2001 15:56
An: [EMAIL PROTECTED]
Betreff: How to execute a stored procedure by using DBI?
I created a procedure
This is not a DBI question.
There's no reason that DBI would take any more
time than the same query in SQL*Plus. Try the query there, get
a query execution plan, see if you have missing indexes, need to
create indexes, etc.
-Original Message-
From: Michelle Gerfort [mailto:[EMAIL
Did you look at 'perldoc DBD::Oracle' ?
-Original Message-
From: Xiaoping Gu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 6:56 AM
To: [EMAIL PROTECTED]
Subject: How to execute a stored procedure by using DBI?
I created a procedure and it can be run on sql command line.
Then,
Hi,
Please read the documentation on DBD-Oracle. To execute a stored
procedure do the following:
$sth=$dbh-prepare(q{
BEGIN
syn_act_uso;
END;
});
Michael
On Tue, 12 Jun 2001, Xiaoping Gu wrote:
Date: Tue, 12 Jun 2001 09:55:42 -0400
From: Xiaoping Gu [EMAIL
Marty == Marty Keane [EMAIL PROTECTED] writes:
Marty The end result in oracle is that I have the entire result set
Marty in memory and can skip around, back and forth (so-to-speak)
Marty through the data. I've used fetchall_arrayref with a foreach
Marty loop in the past with perl/dbi but I
I have develped the following set of subroutines using functions from the
DBI library:
$dbh = DBIv::OpenConnection($server, $database, $uid, $password) ;
DBIv::CloseConnection($dbh) ;
$rh_results = DBIv::SelectQuery($dbh, $query) ;
Strange one here to pass by everyone:
Oracle 8.0.5.1.1 server
Perl 5.00503 (on both alpha-dec_osf and Solaris)
DBI 1.14
Take an Oracle table FOO, with a single field BAR which is a CHAR(8).
Most everything in that field BAR is 8-characters long, but there are a
couple that are 5 characters
Nope -- doesn't work either. (I had neglected to mention... we had tried
that, too.)
-Rick
On Tue, 12 Jun 2001, Wilson, Doug wrote:
Maybe it is binding as a number. Try:
$sth-bind_param(1, $value, { TYPE = SQL_CHAR });
before the execute instead of putting $value in the execute;
Trying to get the oracle module to work and running into the java/patch
error I tried using the LD_PRELOAD
solution, but for a variety of reasons I found it unsadisfactory.
However I've had luck with adding the following
at the top of my program:
use DynaLoader;
DBD::Oracle trims the trailing spaces by default.
try this select * from bar where bar = rpad(?, 8).
or
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbh = DBI-connect( dbi:Oracle:, user/passwd, ,
{RaiseError = 1} ) or die $DBI::errstr;
$dbh-{ora_ph_type} = 96;
Well, we know it SHOULD work, but ya never know till you try :)
Just trying to narrow down the problem.
or match '12345 %'?
What if the value stored is '12345nullnullnull'
-Original Message-
From: Scott T. Hildreth [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 3:04 PM
To: Doug
I'm not sure, but isn't a char(8) always '12345 ', in Oracle?
oh well,
$dbh-{ora_ph_type} = 96; or
$sth-bind_param(1, $fld, {ora_type =96});
will work for sure..well they should :-)
On 12-Jun-01 Wilson, Doug wrote:
Well, we know it SHOULD work, but ya never know till you try :)
Hi there,
On Tue, 12 Jun 2001, Mark Vandenbroeck wrote:
There seems to be some confusion and even incorrectness in this trail. Let's get
some things straight :
Thanks for setting me straight!
73,
Ged.
Hi,
I have an Oracle database which has some foreign
language strings in it. I'm trying to do a select
select * from db where field like 'access%';.
I want the select to return data which have
'access' as well as 'access with any accented
characters in it'. Does Oracle have any option
Hi all,
ORA-3113 means that the client process (DBD in this case) lost it's
connection with the server process.
This can be caused by network problems, but most often it's because the
server process crashed unexpectedly. In that case, it always leaves a
tracefile behind (in user_dump_dest),
I think I saw something a month or so ago on this, but I cannot locate it
now...
I'm not sure if this could be answered here, but when I try to make a
freestanding app of dbiproxy it compiles fine and includes all the proper
Modulesbut then I get the following error message when attempting
Study unpack() in 'perldoc perlfunc'.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: Anurag Minocha [EMAIL PROTECTED]
Make sure your ORACLE_HOME and LD_LIBRARY_PATH are set correctly.
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Simon Mailhot
Sent: 6/12/01 9:04 AM
Subject: Compiling DBD::Oracle
Hello Perl-DBI users,
I am running Apache 1.3.20 with
Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1. BTW, I am
also using the latest oracle client libs (8.17) if this makes any
difference; as well, I am using perl 5.005.
--eric
Ged Haywood wrote:
Hi there,
On Mon, 11 Jun 2001, Eric Kolve wrote:
I recently upgraded to DBI 1.18
Hi again,
On Tue, 12 Jun 2001, Eric Kolve wrote:
Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1.
I seemed to get on better by removing NLS_LANG and ORA_NLS33 from
my environment altogether.
BTW, I am also using the latest oracle client libs (8.17) if this
makes any difference;
Hi all,
There seems to be some confusion and even incorrectness in this trail. Let's get
some things straight :
* There is nothing wrong with NLS_LANG. In fact, it is extremely useful in an
international setting. Your value is fine.
* ORA_NLS33 is obsolete in 8.1.7 and should not be
Hi there,
On Mon, 11 Jun 2001, Eric Kolve wrote:
I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts
with mod_perl, I get the following error:
DBD::Oracle::db rollback failed: Error while trying to retrieve text for
error ORA-03113 (DBD ERROR: OCITransRollback) at
27 matches
Mail list logo