traffic.
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
, if that makes a difference.
do a Google search for MDBtools. UNIX utilities for reading the innards of
..mdb files ;)
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
this
command 'crle' to add the path-to-oracle-libraries to the dynamic library
link path. 'crle' is analogous to 'ldconfig' on Linux machines.
or, add the path-to-oracle-libraries to the LD_LIBRARY_PATH environment
variable.
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
this issue.
I think you have to rebuild Oracle.pm to link against the 8i
libclntsh.so.
Or, keep your Oracle8 OCI library somewhere and use LD_PRELOAD or similar
so that Oracle.pm links to it instead of the updated client library.
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
was detected. maybe this problem migrated
to M$? and that's their fix?
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
it. I must have some kind mental
block. If I could get a working example hopefully the light will come
on. This will eventually work with a html Form. Thanx
wrap it inside an eval {}
---
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
ORACLE_HOME=/opt/oracle/8.1.7
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=
export NLS_LANG=american_america.we8iso8859p1
export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
very slowly.
Anyway aroundu know of.
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
manually?
I've found a sort-of solution, and it's not an alarm.
$sth = $dbh-prepare (SELECT * FROM table_to_check FOR UPDATE NOWAIT);
$rv = $sth-execute;
$sth-finish;
if ($rv != 0E0) {
return undef;
}
# do the update down here
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
be awakened) happens when the firewall falls down and
connectivity to Oracle is lost.
However, in this case, I am certain that the firewall is OK, as using
SQL*Plus to connect to the server works fine..
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-finish;
print STDERR Update finished!\n;
alarm (0);
};
if ($@) {
print STDERR Error: $@\n;
} else {
$dbh-commit;
}
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
well, seems I emailed too soon, timing out stuck Oracle sessions seems to
have been discussed a lot on DBI-dev.. (but with no neat resolution)
is there any news in this regard?
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
On Fri, 22 Feb 2002, Sterin, Ilya wrote:
...
Yes, just insert into a BLOB field. You might also want to think about
keeping it on disk (it's faster) and just keeping a path to file reference
in db.
if it's in BLOB, you can also use InterMedia Text to index it! =)
--
Orlando Andico [EMAIL
with the new J2EE 1.3.1 FCS release from Sun, using
green threads (this is how I got LimeWire working on RH7.x).
But then again I have better things to do.. =) still chugging along with
8.0.5.0.0 =)
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
, and PERL 5.003.
$dbh-do(SET TRANSACTION USE ROLLBACK SEGMENT U7);
seems to work for me..
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP
On Thu, 12 Jul 2001, Perl DBI wrote:
..
yes. i already tried it.
in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you
can better control delimiters and stuff) and DBD::RAM. =)
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK
that I've noticed when you
do large SELECTs in Oracle, the execute takes forever. When the execute
completes, a torrent of data comes in. So my conclusion that Oracle
executes the whole query first..
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version
from a 10-million-row table..
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
--END
DBD::Oracle. i don't suppose you're in violation of your license if you
just use the Linux Oracle client side.
i think. but i shouldn't consider myself authoritative on that.
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GE d(-) s
..
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
--END GEEK CODE BLOCK--
.
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
--END GEEK CODE BLOCK--
. This will eliminate the warning.
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
--END GEEK CODE
SAP would probably do better than
PostgreSQL...
--
-
Orlando Andico [EMAIL PROTECTED] POTS Phone: +63 (2) 848-2893
Mosaic Communications, Inc.GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity
o Informix Universal Server.
-----
Orlando Andico [EMAIL PROTECTED] POTS Phone: +63 (2) 848-2893
Mosaic Communications, Inc.GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
24 matches
Mail list logo