Jan Dubois wrote:
On Wed, 14 Apr 2010, Martin J. Evans wrote:
As ActiveState do not release development builds (no criticism
intended) I am looking at producing a ppm for people to try.
Note that everyone can also just compile the module for themselves
with ActivePerl:
cpan
Shlomi Fish wrote:
Hi newbie01,
On Monday 19 Apr 2010 12:21:45 newbie01 perl wrote:
Hi all,
I need to convert a lot of UNIX scripts into Perl. Most of them uses the
UNIX's EOF/EOL functionality. These scripts are mostly used to connect to
Oracle databases. At the moment, installing a DBI is
Howard,
Please confirm that your TNS_ADMIN variable is set to the correct location in
the perl script.
Thanks
-Mike
From: Howard, Chris howa...@prpa.org
To: dbi-users@perl.org
Sent: Mon, April 19, 2010 9:42:16 AM
Subject: Problems with external password
I am using DBIx::Recordset to access a directory with CSV files, and
the method DBIx::Database-AllTables seems to return just an empty
hash reference.
2010/4/19 Robert Roggenbuck rrogg...@uni-osnabrueck.de:
Did you tried it with an absolute path to f_dir?
It doesn't seem to change anything,
On Wed, 14 Apr 2010, Martin J. Evans wrote:
As ActiveState do not release development builds (no criticism
intended) I am looking at producing a ppm for people to try.
Note that everyone can also just compile the module for themselves
with ActivePerl:
cpan
Hi,
I'm using DBI 1.608, DBD::Oracle 1.23, OCI from 10.2.0.2. I'm trying to select
a CLOB having prepared my select using ora_pers_lob = 1. I've also got the
following options set on my DB handle:
LongReadLen = 100 * 1024,
LongTruncOk = 1,
Without DBI you are very limited in what you can do.
You might want to take a time machine back and give Oraperl a go
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm
Old and unmaintained but at least I think you can run it without dbi
cheers
John
Hi all,
I need to convert a lot
No you are not missing 64k seems to be the limit for that interface with
Clobs and it is a Historical Oracle limit not Perl limit.
in DBD::ORacle 1.24
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oracle.pm#Simple_Fetch_for_CLOBs_and_BLOBs
I say the following
For CLOBs and NCLOBs the
If you are trying to connect to both at the same time using two different
wallets I am afraid you are out of luck.
Seems once a SQLNET.ORA file is read it is 'READ' and cannot be reloaded so
only one wallet can be used at a time.
It will take the first valid one it finds and use that.
James Hooker wrote:
Thanks for the info John.
The following statement is the part confusing me:
However if you CLOB is longer than this and also larger than the
'LongReadLen' than the 'LongReadLen' in chars is returned.
Funny thing took me a while to figure this one out at well. Has to do
some confusion on the oracle documentation
http://www.scribd.com/doc/21329014/Oracle10g-Develop-PLSQL-Program-Units-VOL2
which states
CLOB Datatypes is for single byte character stream
NCLOB is multibyte character stream based upon byte length of the supplied
database character set
Only one wallet is involved, and one connection.
The Oracle Client issue might be in play. I think
the case where wallet is not working right may
have been compiled against an Oracle 8 client.
It is a pretty old installation.
Is there any way to tell which client is in use?
-Original
Yes you can find out with ORA_OCI
use DBD::Oracle qw(:ora_types);
print DBD::Oracle::ORA_OCI
I think will work
Cheers
John
Only one wallet is involved, and one connection.
The Oracle Client issue might be in play. I think
the case where wallet is not working right may
have been
Thanks for the info John.
The following statement is the part confusing me:
However if you CLOB is longer than this and also larger than the 'LongReadLen'
than the 'LongReadLen' in chars is returned.
For my example the CLOB is longer than LongReadLen (which in turn is longer
than 64K). So
As I suspected the one that doesn't work with wallet
is using Oracle 8.1.7.0 client.
I have some preparatory work to do before I can change that,
but I suspect it is the problem.
Chris
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Tuesday, April 20, 2010
8.1.7.0 is a later version of the 8 client I would have to check the change
logs to see if wallet mad it in by there.
Seems a pretty good bet that this is your problem. I checked DBD::Oracle
codebase and the change need to do Wallet type authentication was added in
version 1.15 so your
On Apr 20, 2010, at 3:49 AM, John Scoles wrote:
Without DBI you are very limited in what you can do.
You might want to take a time machine back and give Oraperl a go
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm
Old and unmaintained but at least I think you can run it without
Bruce Johnson wrote:
On Apr 20, 2010, at 3:49 AM, John Scoles wrote:
Without DBI you are very limited in what you can do.
You might want to take a time machine back and give Oraperl a go
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oraperl.pm
Old and unmaintained but at least I think
18 matches
Mail list logo