So use of the "rows" method or "$DBI::rows" with
"SELECT" statements is not recommended.
One alternative method to get a row count for a
"SELECT" is to execute a "SELECT COUNT(*) FROM ..."
compilation environment in Windows and built
your Perl from source there.
- --
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/AwUBOvtzkgOGqGs0Pa
ions. You will always get the last value returned to your current
transaction, even if the sequence has moved on at the global level. There is
no race condition like you describe.
In short, use currval -- it is your (much simpler) friend.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Pro
> BEGIN failed--compilation aborted at Makefile.PL line 14.
>
> Any suggestions would be greatly appreciated.
Reinstall perl. Your installation has been severely damaged.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. &
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.
ounds like you're
initiating a database connection for each client connection, and most kernels
can't handle setting up and tearing down that many TCP sockets per second. If
most client transactions are simple and brief, pooling and reusing connections
will be a definite win.
- --
Steph
How bad if site is really heavy traffic??
> heavy traffic means almost 2 - 2.5 million hits a day???
If the database is on the local machine why are you using a TCP socket at
all? Use the Unix domain socket it creates for you instead. This should be
what it uses by default if a specific IP
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
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
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
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/>
#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/>
---
-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
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 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
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
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
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
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
;,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
> .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
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
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
-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.
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-
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
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
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
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
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
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
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
.
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
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
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
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
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.
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
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
-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-
-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
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.
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
$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
-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 <
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
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-
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
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/>
---
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
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".
- --
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.
--
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
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
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
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
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
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
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. <
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
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,
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
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
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
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
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
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
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
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
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
, 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
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
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
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.
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
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]
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
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
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
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
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
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
.
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
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
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
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
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
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
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
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
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
'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
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
> 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
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
) 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
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
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
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
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
1 - 100 of 133 matches
Mail list logo