obj=31704 op='TABLE ACCESS FULL OBJ#(31704)
'
STAT #1 id=4 cnt=537911 pid=2 pos=2 obj=31705 op='TABLE ACCESS FULL
OBJ#(31705) '
Two full-table scans on tables with that many rows is usually a sign that
either the schema needs work, or that the optimizer has faulty statistics
for these tables.
--
Stephen Clouse
t
goes
to end-of-line.
Knowing those two things, I think you can figure out why your SQL is giving
such
bizarre results.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEG
se an Oracle 9 client. The error only
seems to occur when using an Oracle 10 client to talk to an Oracle 10 server.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.the
as well, and then change your
select to qualify the table name with the schema name:
SELECT * FROM schema.table
Note that you'll need proper privileges to select from the table (either
explicit SELECT privilege on every table or SELECT ALL TABLES).
- --
Stephen Clouse <[EMAIL P
ME needs to be set in whatever starts Apache (/etc/init.d/httpd,
apachectl).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Jan 30, 2004 at 12:35:53PM -, William Campbell wrote:
> Does anyone know whether DBD::Oracle uses blocking or non-blocking OCI?
It uses blocking OCI.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core T
en't tested UTF8, though. I'm actually not even sure how.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8
other CPAN modules).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE/MuvfA4aoazQ9p2cRAhS0AJ9r59FaKbtfz6sdwq7J2UzAwO6arQ
work with 9i?
DBD::Oracle works fine with 9i. What makes you believe it doesn't?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer/DBE, Core Technology Developer
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v
or are only sql
> statements supported?
Basically, if it's listed in the Oracle SQL Reference, you can use it via DBI.
So yes, ALTER SESSION, DATABASE, SYSTEM, etc. are supported. What isn't
supported are SQL*Plus-specific stuff (like STARTUP and SHUTDOWN).
- --
Stephen Clouse <[E
) into local memory upon execute.
To the list: is it possible that the DBD is calculating a ludicrous initial size
for RowCacheSize? Does MySQL even support a row cache? That is my only guess
here.
A high-level DBI trace might confirm that.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior P
SIGTERM +++
>
> What does the brk command do?
It extends the data memory segment for the process.
>Can I get more information as to why SIGTERM
> killed the script?
You are most definitely running out of memory.
- --
Stephen Clouse <[EMAIL PR
> what is going on? Could MySQL be timing out? Should I split up the table
> if it is over 2.5 million records (just do a limit in the SQL statement)?
If this is Linux, it sounds like the kernel OOM killer is sniping the process.
Hopefully you're not trying to hold all those records
with
locks like that -- you're likely hitting something for which Oracle triggers a
nowait lock behind the scenes.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE
's alert log, you'll likely find an ORA-600 that you'll need to
handle with Oracle support. ORA-3113 is Oracle's generic "I screwed up" client
error, and it usually goes along with a crash or segfault on the server side.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Se
but offers a separate OCI 8 version.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE99nDfA4aoazQ9p2cRAjKFAJwK/61AgQRM8Xe
at DBD-Oracle 1.13 would support array inserts.
>
> That was mostly wishful thinking.
I swear I'd heard something to that effect. Sorry, Tim.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/&g
ent of
9i?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9zD29A4aoazQ9p2cRApEWAJwKqMPD0MsIGqZjdPi4lkSk6fmzuACg3vdX
5ZPpX
t on the next release.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9xuPNA4aoazQ9p2cRAkOAAKD0tUf/14NsN/9QDCVCm8oy8Js6PwCgneLK
c9G2xB
le. Changes to attributes in
the new statement handle do not affect the parent database handle and
changes to the database handle do not affect existing statement han‐
dles, only future ones.
--
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Le
rsus a simple select. It certainly *feels* like a DBD::Oracle
problem but I sure don't see it.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Ve
urious to see the OCI calls involved.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9tg2gA4aoazQ9p2cRAqk0AJ9
qw( :ora_types );
And then changing your bind_param call to explicitly bind the parameter as type
ORA_CHAR, like so:
$argh->bind_param(2, ' ', { ora_type => ORA_CHAR } );
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Grou
.
The best solution is to edit the Makefile generated by Makefile.PL and change
all references to ORACLE_HOME/lib to ORACLE_HOME/lib32. This will get it to use
the 32-bit Oracle libraries instead.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ
st the prompt would negate the need for a manual edit
(unless they choose wrong, but that's not our problem :)
As another option, could we compile and link a small test program, ala GNU
configure?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
On Thu, Oct 10, 2002 at 04:36:19PM -0500, Stephen Clouse wrote:
> > oci8.c:1591: warning: passing arg 1 of `fprintf' from incompatible pointer type
>
> That's a warning, not a fatal error.
Although, speaking of those warnings...Tim, have you tried a high-level trace
w
8, Oracle 9, and perl 5.8
>
> error below:
> oci8.c:1591: warning: passing arg 1 of `fprintf' from incompatible pointer type
That's a warning, not a fatal error.
If the compile indeed failed, please post a complete log of the make output.
- --
Stephen Clouse <[EMAIL PR
FROM temp_table_one
WHERE temp_table_one.col_one = 'foo1'
);
> Any idea why we could do it in SQL*Plus?
Er, friendly SQL*Plus gnomes? :) Can't explain that one.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Gro
alled the Oracle Call
Interface component (it should be part of the Oracle Developer section, assuming
it hasn't changed from 9.0 to 9.2). If that doesn't work, try installing Pro*C
as well. One of those has the header files you need to build DBD::Oracle.
- --
Stephen Clouse <[EMAIL
have to post your message once.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9nsKIA4aoazQ9p2cRAgogAJ9TOw6G4jbufwCsufKe0prO5
ere until we execute
> the statement that prepares temp. table #2.
You're forgetting that Oracle triggers an implicit commit on any DDL statement.
The creation of the second table is causing your phantom commit. Try creating
both tables up front.
- --
Stephen Clouse <[EMAIL PROTECTED]
CLE_HOME} is missing or incorrect. Check it.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9jVzGA4aoazQ9p2cRAkOnAKDEEL9a81Xk
will fail in Oracle's case. If the order by
column is variable, interpolate it into the query string before preparing it.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.
e using placeholders anyway, regardless of the data length.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9WqzJA4aoazQ9p2cRA
original issue. The
best thing to do would be to just try it and see.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9WqQFA4a
, because there's no other way to
talk to the database, and you need something like DBI to do the talking. The
point the paper gets at is to expose a data-centric object model to the
application, and let the object worry about building and executing the proper
SQL.
Class::DBI is a good ex
t is (and always has
been) marked as experimental and subject to change.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8D
est version is 1.28.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9KeWuA4aoazQ9p2cRAi39AKDkrfaUpvbsks1GtF4go
correctly in the environment your
script is running in.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: Gn
Debian is not officially supported by Oracle, so some tweaking
may be necessary to get things completely working.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Versi
Gs the buffer must be preallocated. You must
set LongReadLen on the database handle before preparing the statement.
This is not necessarily the case with LOBs, but Oracle 7 lacks such luxury.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group
to append his own
stipulations for redistribution. After all, if you don't comply with his
wishes, you can't (legally) redistribute his code under *any* license.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiq
here is nothing here to clear up -- the program is doing exactly what you told
it to (namely, "print $sth").
Since you seem to be expecting this action to magically produce data from your
database, you may wish to consider reading more of the documentation before
continuing -- e.g., the
his seemed to be
the most application-independent method of solving it (that is, don't touch it
and let the application deal with it).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BE
patch attached. Do with it what you will.
--
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
Index: DBI.pm
===
RCS file: /home/cvs/p
u put a signal flare in the structure
you think is escaping deallocation, say:
$struct->{foo} = 'YOU HAVE A LEAK';
When the string reemerges in the Devel::Leak output, the problem becomes pretty
apparent :)
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer,
ptkdb. Occasionally, ptkdb will even drop me into Tk.pm, but that
> didn't appear to be happening here.
That probably confirms the above hunch.
> The main concern for me here is what I mentioned above - that I dumped into
> an END block for Oracle.pm and DBI.pm when I clearly shoul
at this point.
> Bareword found where operator expected at (eval 16) line 8, near "00351
> DBI"
The real problem appears to be a syntax error somewhere in your script.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <
t;execute(@data) or die log_message("ERROR executing insert:
If you're using placeholders, you have no reason to be using $dbh->quote. The
native driver will do the proper quoting when it binds the value.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordin
7;re
expecting an assignment to $user to go once the subroutine returns.
> if (defined($UserCache[$id])) {
^
This is an array, not a hash. Did you mean $UserCache{$id} ?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Pro
ile, please?
You need to install the OCI components of Oracle.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For
y without risk of causing the script to bail out on
> an error?
Don't turn RaiseError on, or wrap the statement in an eval.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGN
n't you mean $ENV{ORACLE_HOME}?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBPDsb0QOGqGs0PadnEQLVdQCfSeoEd9sVDcyIcvUYGGj73GM6qe8AnR
te a function-based index on LOWER(baz),
otherwise you'll likely be doing a full table scan every time you execute this.
Ick.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIG
Comments in patch should explain all. I've gone back through my dbi-users
backlog and looked at every `perl Makefile.PL -v` log I could find, just to
be sure about this before I submitted it. This behavior of the Oracle makefiles
seems to be consistent with any Oracle >8.0.5.
--
This tip courtesy of Tim Bunce:
use DBI qw(:sql_types);
$sth->bind_param(1, $value, SQL_CHAR);
The problem is that OCI "smartly" strips trailing blanks off a bind value of
type VARCHAR2. Explicitly casting it to a CHAR datatype avoids this
"intelligence".
- --
urns the current session's audit ID, which you can line up with the
audsid column in v$session.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN
o be an uncontrollable limitation of PG itself, in that
it forces a complete transaction rollback on any error. This is definitely the
Wrong Thing.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Try DBD::Oracle 1.12.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO9hTiAO
-users list.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO9eMDAOGqGs0PadnEQIcggCeJ0A5R0yEdUrHLLBnfQdMs7lOtZMAoKl6
sOicblXzJ3JeUuBhMHXorkkt
=H6m4
-END PGP SIGNATURE-
t by solving the human intelligence issues, *then* work on the Perl issues
(if there indeed are any).
Having said all that, is this really on topic for dbi-users?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.
L =
another NULL. And if someone actually answered nothing (''), that isn't NULL
(unless you're on Oracle -- I can hear the groaning already).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The I
e, '' gets treated as NULL, but that's their
fault. (I'd wager this whole thread stems from an Oracle user to start with :)
Perhaps they'll finally retire that broken behavior in version 10. Of course,
they said they were going to do it in version 8
- --
Stephen Cl
eating the zero-length string as
NULL, which ANSI explicitly says *not* to do...but that's another story.)
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.
better than perusing 400,000 lines of our application
code to change prepare to prepare_cached. prepare_cached calls prepare to
actually create the sth, so in our case prepare needs to do the Right Thing
when called from within itself.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Sen
Give me a day or
two.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO8smugOGqGs0PadnEQL+8gCgwhzaz+LF50wRsPWQMF/pOuh3s64Anic9
PswFJGFeo34frBHifw5aSXuB
=vvyk
-END PGP SIGNATURE-
nsider this a response to both
messages.) Feel free to use it as a template to rework things on your end.
--
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
DBI.pm
Description: DBI.pm
msg07239/pgp0.pgp
Description: PGP signature
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, Oct 13, 2001 at 08:59:13PM -0700, dane k wrote:
> What is the max size of LongReadLen ?
As much memory as your environment can allocate. See the docs for help in
figuring out the best size to set it to.
- --
Stephen Clouse <
$dbh.
Mind showing some code that demonstrates the problem? There's nothing in DBI
that reblesses the dbh, so it's hard to say what the problem is without being
able to reproduce it.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
not able to FETCH them later.
They work fine as long as I've been using them. Let's see some code.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATU
scalar is a
scalar whether it's in quotes or not, so you only need them if you're
interpolating a variable into a larger literal string (IOW they're not
necessary on the first parameter either). And if you're not interpolating (as
in the db handle), you need to leave them
character, and nothing works.
I can't say much without seeing some code, but if you're not using placeholders,
you should be. (The fact that you're attempting to escape the string suggests
you're not.)
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinat
launching programs.
BEGIN { print "ORACLE_HOME = $ENV{ORACLE_HOME}\n" }
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PG
.
Funny you should ask :) Our two flagship products (IQ Coordinator and IQ
Developer) are built entirely on DBI, Oracle, and Apache/mod_perl. It's an
awesome combination. Unfortunately the marketdroids seem to have taken over our
Web site and divested it of all useful information, but I can sha
nd the current transaction (and thus reset any transaction
settings you made).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO7I4rwO
g porting this newly developed version to a production server, and
> the following call to te dev db never reterns:
You might try an strace or truss to see if it's getting stuck in a system call
(and what call that is). It may give you a clue where the problem lies.
- --
Stephen Cl
DBD::Oracle?
If you installed the client, then you're probably still missing the Oracle Call
Interface component (which has all the necessary header files and such for
compiling). See if installing that does it.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Progra
e latest version of DBD::Oracle (v1.12) builds flawlessly
with Oracle9i.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO6pnlgOGqGs0Pa
method of escaping placeholders.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
Version: PGP 6.5.8
iQA/AwUBO5+K5gOGqGs0PadnEQIoPwCgkE11qZ3MAerLQVFcjbQU6603E7cAoLDS
t be done with Oracle (which is what he was trying). This is the
nature of their libraries and their network protocol. It has nothing to do with
DBI or Perl.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgro
work. Below is the code. Any help would be appreciated
Initiate the database connect in the child. You generally can't share database
connections across processes. You *definitely* can't share Oracle connections
across processes.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior
his is fixed in DBD::Oracle 1.12, which should be appearing at your nearest
CPAN mirror shortly, if not there already.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATURE-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Download DBD::Oracle 1.10 and try again. You're hitting the include parsing
problem that I spotted in 1.09.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.
n this function)
> > oci8.c:118: (Each undeclared identifier is reported only once
> > oci8.c:118: for each function it appears in.)
> > oci8.c:119: `OCI_DTYPE_INTERVAL' undeclared (first use in this function)
Those datatypes are missing in 9.0.1 as well. Glad they decided
n [insert Linux distribution
that isn't SuSE here], it works flawlessly. The workaround for such systems was
posted here recently; check the list archives.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgrou
> .pm line 200.
Make sure the Oracle libraries are in the library search path. On Linux the
best solution is to add $ORACLE_HOME/lib to /etc/ld.so.conf and run ldconfig.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The
;,NULL,'NULL');
`undef` is the proper way to insert NULL. The above is inserting the literal
string 'NULL'.
Try the following:
$sth->execute('HIGH','10.1.9.124',undef,undef);
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordi
thing of a hack (but I'm confident
enough that it's on our production servers -- it endured a day of rigorous
testing while I was weeding through the code to find the problem). I assume a
better fix will find its way into the next DBD::Oracle (I didn't see any related
changes
it only does it at
this point (there were about 20 successful sets before it hits this erroneous
one). I've attached the complete trace log (level 9) -- perhaps someone more
apt at staring at OCI calls can figure it out.
--
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
error.log.gz
PGP signature
truncated
from 100 to 100. DBI attribute LongReadLen too small and/or
^^^
LongTruncOk not set
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.co
available from the redhat ftp server.
Doh, I completely forgot about the Redhat port. I shall have to go injure
myself now.
Still, this sounds more like an issue with Bugzilla, not DBI. It would be
better suited for one of their lists.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Progra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Jul 17, 2001 at 10:21:13AM -0700, Blake Binkley wrote:
> I have Oracle 8.1.7 Client installed
Your first problem might be the fact that Bugzilla only works with MySQL.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Progr
simple oraperl
> script. The error message seems to be related to "DBD ERROR: OCIStmtExecute".
ORA-1 is a unique constraint violation. This would be a problem with your
application or your database schema, not with DBI.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Jul 02, 2001 at 11:34:42AM +0530, anshuman das wrote:
> Can't locate object method "connect" via package "DBI"
Did you `use DBI;` in your program?
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programme
#x27;ll probably also want to call the DBMS_RANDOM.INITIALIZE() procedure
beforehand to seed the generator.
BEGIN
DBMS_RANDOM.INITIALIZE(1234567890)
END;
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
---
saying "PLEASE KEEP THIS FOR YOUR
FUTURE REFERENCE". These people probably throw away instruction booklets on
household appliances, too.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
ents.
Use placeholders. Use placeholders. Use placeholders. Oh, and use
placeholders. See `perldoc DBI` for further information.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-BEGIN PGP SIGNATU
y
case, here are some suggestions that all have good Perl support -- try them and
stick with what you like.
emacs (or xemacs)
vim (or xvim)
UltraEdit (Win32 only)
NEdit
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group
local $dbh->{RaiseError};
> H This construct is recommended by DBI(3pm)
> }
>
> while (1) { flub(); };
This is a known bug in Perl proper with tied hashes (hint: DBI's internal
implementation is a tied hash). See the Known Problems section of `p
work on any other host.
Look up documentation on Apache's XBitHack directive.
This is not DBI-related (or even Perl-related, for that matter).
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.
1 - 100 of 133 matches
Mail list logo
