]
Sorry, after starting this thread, I dropped out for a while folks.
John, did you get to a satisfactory solution in the end?
Paul
-- Forwarded message --
From: John Scoles [EMAIL PROTECTED]
To: dbi-users@perl.org
Date: Mon, 9 Apr 2007 14:33:41 -0400
Subject: Re: :Oracle - Any
Just a few quick things
Instant client also requires the SDK download as well. Did you download that
Also make sure you have permission to make a symbolic link in the instant
client dir. This is also a requirement as Oracle has rebundeled the .so
files in an odd way.
cheers
David Hull [EMAIL
Sort answer Yes with a But..
Long answer No with a Maybe..
I guess it would depend on the DBD client you are using. Some are more
capable than others. For example with DBD::Oracle you can create a cursor
on the server sideg and then get that in clumps.
Give us the exact DBD clients you are
Do you have the path to your Oracle client in you Path statment??
Matthew Bygrave [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I have a slight problem with the installation of DBD::Oracle 1.19 using
the cygwin environment running on Win2003 R2 Standard edition sp1
machine.
::Oracle patch to set charset via connect attribute
On Mon, Apr 02, 2007 at 02:51:21PM -0400, John Scoles wrote:
From: Stephen J. Smith [EMAIL PROTECTED]
No problem. I'd be willing to make another patch that handles ncsid
and has a test case and documentation if you want.
That would be nice Thanks
If you have no objection I will add this to the new README.64bit.txt. I am
collecting there all sorts of info related to compily DBD::Oracle on 64 bit
boxes. Geting the Makefile.PL to work for 64 bit system is one of the jobs
penciled in for a later version of DBD::Oracle
- Original
Well no exact answer but I might be able to point you in the right
direction. Seems Solaris has been a problem for a while.
Have a look at these links
http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.16-on-solaris-9-and-oracle-9-client.htm
Oracle doesn't have this feature so DBD::Oracle doesn't either.
This has cropped up many times before So you can blame Oracle on that.
Thier logic (as it was explained to me) is
How could you get the number of rows you are going to fetch without
counting them all first?
or someting very
there before it
runs, So we might have to
1) prepare the SQL
2) upload the CLOB
3) bind
4) execute the statment.
I do not like this myself.
I will look at the Lob locators and see if I can work it out with that later
this week.
cheers All
John Scoles [EMAIL PROTECTED] wrote in message
news:[EMAIL
::Oracle that you were using before?
cheers
John Scoles
- Original Message -
From: Joe Torres [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Saturday, April 07, 2007 10:38 AM
Subject: DBD-Oracle-1.19 will not make nice
Hi All,
I am newbie using perl and perl modules, I need your
Sorry to be a Johnny come lately on this (pun intended)
I have been playing with this myself and like you chaps have come up with a
blank. End up with ORA-00942 error
I did spend some time to see how the python guys did it but as I can see
they just did it as a cursor which I think we can do
Do you know what version of DBD::Oracle and DBI you are using.
Looks like you are using an old version of OCI (Oracle Client) which may not
have/be compatiable with the present OCI Array Inteface
Try compileing and testing it against the Oracle instant cleint.
I you rally want to use a old
dimensions in an
Euclidean
space of (n+1)*(n/2)*(3*n+11) dimensions. -- Prof. John Nash
[EMAIL PROTECTED] / 0x43340710 / 517B C658 D2CB 260D 3E1F 5ED1 6DB3 FBB9
4334
0710
Thanks Stephen I will get that into the next release which should be comming
out around the end of April.
Stephen J. Smith [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Below is a patch that allows DBD::Oracle users to specify charset during
connect as follows:
$dbh =
- Original Message -
From: Stephen J. Smith [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Monday, April 02, 2007 1:42 PM
Subject: Re: DBD::Oracle patch to set charset via connect attribute
On Mon, Apr 02, 2007 at 12:04:23PM -0400, John Scoles wrote:
Thanks Stephen I will get
Hello,
I am interested in using the Perl DBI with Pervasive, but I don't find a
driver for it in your driver list in CPAN. Is there one available, or can I
use the ODBC driver?
Thanks,
John Barrientos
I would check the README.win32.txt it has good step by step instrucntion on
how to compile DBD for XP
Samant Kumar [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I am trying to install DBD Oracle from a very long time now. I cannot use
PPM as the systems in my company are
Hard to say for sure but it looks like Oracle Discoverer reset some of the
envionmnet varialbles or loaded a newer version of Oracle Client and or
removed some part of the client which somehow crunched your DBD::Oracle or
it has movered the TNS names or alike
one thing you cn do for me is
do you know which version of DBD::Oracle you are using and which OS you are
using. There are some known issues that comes up.
Can you send me some test sql as I have some time this week to work on it.
From: Praveen Erpineni [EMAIL PROTECTED]
To: dbi-users@perl.org
Subject: how to compile
Hi I have been doing a little work on this so here a few quick sugestions
1) Check and see if there are any patches for Oracle 10 that you have not
applied yet. I know of one patch thatcauses a OCI error that was fixed by a
late patch
2) check the default envionment values for the user
Jsut trying to get DBI and DBD::ORacle up and running on a new version of
Apache web server and I run into this error
9545: ModPerl::Registry: anonymous handlers not (yet) supported at
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/Apache/compat.pm
line 131.!
when I try a simple
On thing about the instant client is that it has to make a symbolic link to
compile correctly here
some thing like this
$ ln -s instantclient_10_2/libclntsh.so.10.1 libclntsh.so
If the user that is doing the compile doe not have permission to do this
link then you may get a failure like
That is a neat one.
Makes some sort of sense as you are telling OCI directly what is being put
into it. Rather that letting OCI figure out what is what.
Can you send me a empty table structure/SQL and test Perl code so I can
have a closer look into it.
I plan to be making another release at
Not sure what you mean by
The only different at this time is I install on
a full suite of Oracle servers are running
Does this mean you tried to complile and install while Oracel was running?
or are you compiling against an enterprize version of the client?
Pham, Tri [EMAIL PROTECTED] wrote in
Ok I Compiled it again on a Windows bos asme as before and it was OK
Just for your info Tim I have attached the output of the 'nmake tes't from
the 85gofer till the end.
Cheers John Scoles
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: Martin J. Evans [EMAIL PROTECTED
Well I had another carak with Windows and here are the results
Makefile.PL worked and it compiled fine with nmake.
Unfortunetly on the mnake test it hung on 85gofer.t and just spun its
wheels. I shut it down after 20 mins
Do you want me to do some degugging on 85gofer.t?
cheers
John Scoles
Well this time on windows no errors but it hangs here
t/85gofer.ok 1/0
and sometimes
t/85gofer.ok 11/0
and
t/85gofer.ok 13/0
again with RC7
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: Tim Bunce
most likly you have no 'scott/tiger' user on you db
try this
$dbh = DBI-connect(DBI:Oracle,a_db_user.@.a_db_name,a_db_password, {
AutoCommit = 0,RaiseError=1,PrintError=1 } ) or die $DBI::errstr\n;
- Original Message -
From: Terry Maragakis [EMAIL PROTECTED]
To:
most likly you are trying to compile DBD::Oracle to a 64 bit client. Try
pointing to the 32bit client:
- Original Message -
From: Anh Dao Nguyen [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Thursday, February 01, 2007 11:12 AM
Subject: Installation of DBD Oracle
Hello,
After
Hi not really aq problem with DBD::Oracle it is simply a permission problem
the Oracle has with the username and password that you chose to run your
test.
The user for this test must have permissions on system tables like v$session
etc. Try changing your test username/password to one with
It is John Scoles, John Scholes is my evil twin who knows how to program in
C correctly also a US TV actor.
I will see if I can root out the rest of those // today
Cheers
. Will
Martin Evans [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Pham, Tri wrote:
To DBI support,
I am
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 7:16 AM
Subject: (Fwd) Re: New Oracle Instant Client
- Forwarded message from [EMAIL PROTECTED] -
From: [EMAIL PROTECTED]
To: Tim Bunce
opps sorry about that empty
Looks like you are missing the sdk dir and sqlplus. You will need those as
well.
You do not have the manually set link the libclntsh.so link the make file
should do it for you.
I would start over again by removing all the instanct client suff and then
gettting
# perl -e 'system(exit 1;); print $? $!\n'
256
# perl -e 'system(exit 0;); print $? $!\n'
0
-Original Message-
From: Andy Hassall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 6:36 PM
To: 'Weaver John Cairns CONT NSSC'; dbi-users@perl.org
Subject: RE: :Oracle make test
How would I fix this issue?
Thank you for taking the time to look at this.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 7:21 AM
To: Andy Hassall
Cc: 'Weaver John Cairns CONT NSSC'; dbi-users@perl.org
Subject: Re: :Oracle make test
Your first pattern is correct. In the second one you cannot use bind in an
in statment like this as it connot correctly quote the params. Not sure if
this is an DBI thing or DBD::Orale OCI thing though
Anand . K . S . [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
This
Hi,
I am having problems with DBD::Oracle install any help would be appreciated.
I am running Solaris10 (1/06 Sparc) and Oracle 10g.
Thank you,
John Weaver
Please look at my log file attached
DBD.log
Description: Binary data
Hi,
I have more info and have included it the attachment provided.
Thank you for the help. This has been a real pain. I have install
DBD::Oracle many times, but in my new system, (Solaris10 (1/06 Sparc) /
Oracle 10g) I am having issues.
Thank you.
John Weaver
DBD.out
If I am not mistaken DBD will defualt to varchar2 for all placeholder unless
you tell it otherwise.
Check out Padded Char Fields and Placeholer Binding Attributes in the
DBD::Oracle POD.
In this case DBD might see this bind as number not a varchar (depeneds on
the exact NLS settings of you
I would say yes as DBD::Oracel 1.06 is about 13 revisoins out of date.
- Original Message -
From: [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Monday, January 08, 2007 11:04 AM
Subject: Problems using an old version of DBI to connect to a remote Oracle
10g database
Dear all,
We will need a little more to go on.
OS, Version of DBI, DBD and what is missing
- Original Message -
From: Chong, Wei-Ling [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Thursday, January 04, 2007 9:05 PM
Subject: RE: Perl lib version not match executable version
Anyone can help?
instruction on how to install DBD::Oracle in the
README.win32.txt file that is part of the DBD::Oracle tar follow that and
you should have no problems.
cheers
John Scoles
- Original Message -
From: [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Thursday, December 21, 2006 5:02 AM
Subject
Unfortunety I cannot say for 100% sure this will solve you problem as there
is no way to exactly match your system's setup. Oracle
version/patches/Oracle client system enviornment etc.
There were a large number of improvements in UTF encoding since 1.12 so my
only sugestion is for you to
If you can give me example table,the function and the SQL you are trying in
JDBC I will have a look at it.
Can you also tell me what OS, and what version of DBD::Oracle and Oracle you
are using.
Seems to me that the latest version of DBD::Oracle should be able to do
this.
bin zhou [EMAIL
Capacio, Paula J [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
From lurking around this mail list over the years,
I've seen numerous items relating to building
DBD-Oracle against a specific version of the Oracle
client software on *nix systems.
Natrue of the beast. DBD::Oracle uses
a funny warning in that it cannot find SQL*Plus.
Cheers
John Scoles
- Original Message -
From: Camara, Ronneil [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, December 12, 2006 1:12 PM
Subject: DBD::Oracle 1.19 failing to make
Hi,
I need some help. The make is failing as shown
It is concidered rather poor form it create you sql on the fly so while
my $sql='Select $field1, $field2 from test_table where $field1=$var1 and
$field2=$var2
is ok
you are opening yourself to a host of problems such as
1) hacking with SQL insertion
2) problems with using ' and if you field
Also you would leave your DB wide open to SQL insertion attacks if one could
do this soit is good that they don't.
Kevin Spencer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi guys,
I'm sure I'm missing something *very* obvious but this one has me
scratching my head. Using
is bad
URL:http://xahlee.org/UnixResource_dir/_/ldpath.html
John
[EMAIL PROTECTED]
they
should be on your 2.6 host.
John
[EMAIL PROTECTED]
I would have to agree with Ron on this that is it someting in your Oracle
that is going awry. Perhaps you are missing an index someplace.
Looking at the code trace you included there is nothing in DBD::Oracle 1.18
that has changed in what you are hitting since 1.16. Can you try using
John
?
You can download Oracle 10g for Solaris on x86 from
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
Kind Regards,
Prasad
Good luck!
John
Sadness is just another word for not enough coffee.--Wally, in Dilbert
Changes in DBD-Oracle 1.19 (svn rev 8002) 3rd November 2006
Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho
Jingleheimerschmidt and others
Fixed execute_array so it will not throw a Perl warning on undef values in
Tuples from John Scoles
Fixed execute_array so
upgrading to the instant client, Perl and DBD and
see if you can still connect.
cheers
John Scoles
- Original Message -
From: Eugene Krivdyuk [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: Sergey Brutsky [EMAIL PROTECTED]
Sent: Tuesday, October 31, 2006 6:23 AM
Subject: DBD::Oracle 1.07
[EMAIL PROTECTED]
Sent: Tuesday, October 31, 2006 7:41 AM
Subject: Re: DBD::Oracle 1.07 and selectall_arrayref
On 2006/10/31 Tue 06:59:18 , John Scoles wrote:
I doupt it. It is possiable but you would need to do alot of
programming.
With DBD 1.07 you are talking a version of the program in mid
(DBD ERROR:
OCIServerAttach) at test.pl line 31
If you try to compile DBD::Oracle you may see this error
*** Error code 139
make: Fatal error: Command failed for target `lib/Config.pod'
Hope this helps someone out-there
Cheers
John Scoles
In message [EMAIL PROTECTED], John Scoles writ
es:
Seems there is a bug in Oracle (What??? never happens?? yeah right!) the bug
number is 5389730. Seem that our friends
at Oracle forgot to add a flie to a makefile into the 10.2.0.2 Solaris x86
patchset :-). so parts are missing when you try
it
realy only requires a good deal of time to do the the downloads and then a
few mins to actually do the compile and install no knolege of C or even
programming is required just follow the docs.
Cheers
John Scoles
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I'm trying
to you :-)
best regards, John.
into this.
cheers
John Scoles
- Original Message -
From: Ronald J Kimball [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Friday, September 29, 2006 12:47 PM
Subject: Compiling DBD::Oracle 1.17 with LD_RUN_PATH
I had just built and installed DBD::Oracle 1.17, and I found that I
couldn't
use it unless
That sounds about right. Can you check this version of the file to see if it
works for you
http://svn.perl.org/modules/dbd-oracle/trunk/dbdimp.c
This would be the current code from subversion. It should be in UNIX
format. If not I will have to fix that
Cheers
John Scoles
- Original
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: Martin J. Evans [EMAIL PROTECTED]; dbi-users@perl.org
Sent: Thursday, September 28, 2006 8:05 AM
Subject: Re: DBD 1.18a make not working
First thing I would look at is LD_LIBRARY_PATH to make sure that is set
correctly
it is dbi:Oracle:
not DBI:Oracle
it is case sensitive.
cheers
John Scoles
- Original Message -
From: Christophe ANTOINE [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Friday, September 22, 2006 10:29 AM
Subject: DBI-connect Oracle on Windows, doesn't Work
Hello,
I have
is fortunetly still available at this mirror site
http://www.filewatcher.com/m/VCToolkitSetup.exe.32952488.0.0.html
download it and follow the instructions in the README.win32.txt and you
should be able to get it to compile
cheers
John Scoles
- Original Message -
From: Hameed Shahul-E4007Z
. Check with you DB admin
on which lob permission you have on the tables
# 2 is only a problem if you plan to use lobs.
Cheers
John Scoles
- Original Message -
From: Adriano Ferreira [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, September 13, 2006 10:03 AM
Subject
and follow the
instructions in the README.win32.txt.
cheers
John Scoles
Martin Gainty [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello Tim-
Errors on using DBD-Oracle installed via
ppminstall DBD-Oracle
error displayed is
The procedure entry point Perl_Glockhook_ptr could
No I do not think there is TAF support.
It is on the wishlist of things to add after we get exeecute_array working
correctly
Main problem I see is that somthing very Oracle like TAF is outside the
scope of DBI
cheers
- Original Message -
From: Andre Heine [EMAIL PROTECTED]
To:
You might want to follow the tutorial found in the README.win32.txt as you
can compile the latest version of DBD::Oracle it for the exact Oracle client
you are using.
More compilcated I know but it does work.
cheers
- Original Message -
From: mohanesha chandrashekar [EMAIL
- Original Message -
From: Karl Auer [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, September 06, 2006 9:20 AM
Subject: Re: Getting DBD::Oracle tests working
Success!
Thanks to help from you (and my DB admins getting a working scott/tiger
account going) I have finally
- Original Message -
From: Karl Auer [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, September 06, 2006 9:36 AM
Subject: Re: Getting DBD::Oracle tests working
On Wed, 2006-09-06 at 09:30 -0400, John Scoles wrote:
if you actually read the READMEs you will find that you can
Ok I will put it in the next version.
Most likely I will work on it next week so I can get a new version out at
the end of the month.
Cheers
John Scoles
- Original Message -
From: Karl Auer [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, September 06, 2006 10:08 AM
Subject
Ok I will put it in the next version.
Most likely I will work on it next week so I can get a new version out at
the end of the month.
Cheers
John Scoles
- Original Message -
From: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
To: John Scoles [EMAIL PROTECTED]; dbi-users@perl.org
::Proxy (at least it was in 0.2004; not sure it it's fixed in the
latest version).
You can work around it by setting $dbh-{AutoCommit} = 1 after your commit
or rollback.
best regards, John.
Tim Bunce [EMAIL PROTECTED] wrote on 04/09/2006 12:02:53:
I'd appreciate it, John, if you could file a bug report on rt.cpan.org
Ok, Tim, done. Ticket #21320.
best regards, John.
Title: RE: Problem with DBI make
Hi Tim,
I've just run make again and included the output
The system I'm trying to install DBI on is a hp-ux 11.11
And the version of perl installed is 5.8.7
John
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: 01
It sould work with perl 5.6.1 can't say for sure.
Most of the testing and developement has been done with Perl 5.8. but I do
not think it uses anything special controls from 5.8.
You may have to recompile both DBI DBD so they will work with your older
perl.
What is your OS and platform?
: warning: unused parameter `cv'
make: *** [Perl.o] Error 1
Thanks for any assistance given
John
BT Communications Ireland Limited
is a wholly owned subsidiary of BT Group plc
Registered in Ireland, Registration No. 141524
Grand Canal Plaza, Upper Grand Canal Street, Dublin, Ireland
Using Oracle in /home/kauer/oracle/instantclient
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open
shared object file: No such file or directory
I'm having trouble finding your Oracle version number... trying harder
Looking at the above means you did not load all of the
In message [EMAIL PROTECTED], Karl Auer writes:
9/9 skipped: Unable to connect to Oracle (ORA-12162: TNS:net service n
ame is incorrectly specified (DBD ERROR: OCIServerAttach))
You did not set TWO_TASK properly.
John
[EMAIL PROTECTED]
When that many test fail with DBD::Oracle the most likely cause is that you
do not have a correct ORACLE_USERID enviornment variable set.
Chech the readmes for this. they should answer your questions
Cheers
John Scoles
- Original Message -
From: Lincoln, Adym [EMAIL PROTECTED
Rajamanickam, Venkatesh [EMAIL PROTECTED] wrote in
message
news:[EMAIL PROTECTED]
Hi,
In my application, I am using perl version 5.6.1.
I am currently using Oracle 9i database and I am using DBI and DBD
modules for connecting the application to Oracle .
Current Configuration of DBI and DBD:
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
We have perl 5.6.0 installed here. Current version of DBI is 1.35 and that
of DBD::Oracle is 1.12.
Now I want to install DBI 1.5 and DBD::Oracle 1.17 so that I can connect
to Oracle 10g databases. Will it be a problem?
I
In message [EMAIL PROTECTED]
m, Loo, Peter # PHX writes:
$ ./testCon.pl
Segmentation Fault(coredump)
Lets see the output of pstack(1) for that core.
You may have stumbled upon an Oracle bug in the client libraries.
John
[EMAIL PROTECTED]
to file a
TAR.
By default, the demo's build 64-bit, if you're using the 32-bit
client libraries with a 32-bit Perl, then you'll need to adjust
the Makefile.
John
[EMAIL PROTECTED]
with it,
Oracle Support will be able to as well.
John
[EMAIL PROTECTED]
suspect you've stumbled upon a bug in Oracle's 32-bit libraries.
John
[EMAIL PROTECTED]
::Oracle 1.18.
Using DBI 1.50 (for perl 5.008007 on alpha-dec_osf) installed in
/usr/users/dwadmin/perl/lib/site_perl/5.8.7/alpha-dec_osf/auto/DBI/
Writing Makefile for DBD::Oracle
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 July 2006 5:42 AM
Thanks Jan this is very helpful. I will have a look at it this morning and
perhaps I can figure out if it is a bug in DBD or Oracle.
Cheers John Scoles
Jan Kasprzak [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I want to add a me too with a description to the messages
and RHEL I can test on.
Chers
John Scoles
- Original Message -
From: Brandon Maust [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, July 25, 2006 4:43 PM
Subject: Re: Segfault with DBD::Oracle 1.17 under mod_perl
To follow up on this in case others encounter a similar problem
not support it very well and I wanted to get the new version
out before I leave on summer vacation.
The plan is to add support for it with the next release some time in
October or November.
Cheers
John Scoles
- Original Message -
From: Steve Baldwin [EMAIL PROTECTED]
To: dbi-users
expanded support for LOB Locators from Jeffrey Klein.
Finally there are number of little fixes and an update or two to the
readmes.
please enjoy.
John Scoles
(Please note that it may take a little while for CPAN to update to the
latest version so if you need the latest code you can always use
Your bset bet would be to get Activeperl,
http://www.activestate.com/Products/ActivePerl/?psbx=1 it is free, Use thier
PPM and sarech and instlall DBI and DBD::Mysql. Things should work
perfectly after that.
Keith, Robert [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
DBI Team
Oh the top of my head I would say you do not have an oracle client to
compile against. or the client you have is lacking some parts. What is you
Oracle cleint you are trying tocompile against?
Tim Bunce [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
- Forwarded message from
Yes we have seen that one before there is an
open bug report for it here
http://rt.cpan.org/Public/Bug/Display.html?id=18012
can you fill in the rest of this table for
me
Perl: 5.8.8DBI: 1.5.1DBD::Oracle:
1.17OS: ?Oracle server: ?Oracle client: ?Oracle database
-1.18-RC3.zip
as we are close to releaseing a new version of DBD::Oracle
Cheers
John Scoles
- Original Message -
From: Rohit V Bhute [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, July 18, 2006 12:39 PM
Subject: DBD-Oracle 1.17 gives install_driver(Oracle) failed
I was using
Try binding like this
$sth-bind_param_inout(:pid_str,\$pid_str, {ora_type = ORA_CLOB});
read the section in the DBD::Oracle pod on Handling LOBs as well
cheers
John Scoles
- Original Message -
From: Prakash Inuganti -X (pinugant - Digital-X, Inc. at Cisco)
[EMAIL PROTECTED]
To: dbi
It memory serves me correctly I think any errors that are generated is
stored in the ArrayTupleStatus have a parse through that array to see it the
error is stored there.
- Original Message -
From: Martin J. Evans [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, July 04, 2006
rather that stopping at each one.
This being said if the DBD driver does not support an array interface DBI
simply mimics this behaviour by iterating though the array. Not real time
saving there it just follows the array interface model.
Cheers
John Scoles
- Original Message -
From
Your best bet (and fastest) would be to use
fetchall_arrayref()
like this
my $sth = $dhh-prepare(select * from my_countries);
$sth-execute();
my $reff_array = $sth-fetchall_arrayref();
then you can use $ref_array anyway you want without going back to the DB.
foreach my $row
501 - 600 of 919 matches
Mail list logo