I am collecting and writing a new version of the Makefile.pl for Oracle 10
XE I was just wondering if I could get a copy of your version of your
makefile and any instaltion notes you might have. I am working with Tim
Bunce on this project.
Cheers John Scoles
Can you tell us which version of perl you are running and wether it is 10.2
personal, enterprise or standard or is it just the client?
Marty Martindale [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
There is a problem in Oracle 10.2 that surfaces after you install the
latest
Perl,
Not to add any more fuel to this flame but 10XE works fine with DBD::Oralce
at least for windows.
Rich Jesse [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Wow, that's a tough one. It really depends on what you want/need from
your database. What's your recoverability liability? How
Your DBI 1.38 is a rather old. The current version is something like 1.49.
You might want to start by getting and installing the latest version of DBI.
Is there any reason you have to use 1.38?
I have also had good sucess using Activeperl and PPM. You may want to try
that product as well.
You
If you are using a Windows enviorment this may also be caused by not putting
the path to the oracle_home in windows format. If you are in Linux/unix you
might want to check you .profile for the user running the program it may not
have the correct home anme.
I am trying to compile Oracle:DBD for a full Oracle 10g install on a Redhat
64 bit linux (egle64) and I am wondering if anyone has ever gotten the
following
So far I have gotten the Makefile.PL to work
but when I do the make command I get this
/app/oracle/working/raj/DBD-Oracle-1.16 make
rm -f
Didn't have this error myself but I found something similar
So you might want to try this
changed the line
$DBD::Oracle::VERSION = '1.16';
in Oracle.pm to
$DBD::Oracle::VERSION = '1.06';
Worth a try.
Cheers
Shaw, Gary [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi there,
Has
, worked fine.
cheers!
Tim Bunce [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Jan 04, 2006 at 12:16:07PM -0500, John Scoles wrote:
I am trying to compile Oracle:DBD for a full Oracle 10g install on a
Redhat
64 bit linux (egle64) and I am wondering if anyone has ever gotten
Peter J. Holzer wrote
or selectall_arrayhashref?
Anyway, I rather frequently find that the most natural way to
represent a query result is an array of hashes: Each row is hashref, but
the the rows are in an array(ref) so that the order is preserved, and
the columns can be accessed by name.
Claire Lee wrote
I didn't recompile. What I did was just use the script to try to
connect. Do I need to recompile? How do I do it? Thanks.
Jing
There are a number of tutorials on the web for this. If you tell me what
sort of operating system you are using I might be able to point you in the
I do not think there is any maximum # of rows. As I have have use queries
with it well over 35k rows. It would be dependant on the size of fields in
each row and the amount of memory you have.
In this case I think you query is simply running out of memory.
Try using a cursor in your SQL or use
I have seen similar when there is a space in a path someplace.
Could that be it?
Check to ensure you do not have a space in you Perl dir.
Christopher T. Brown [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I am running the install DBD-Oracle command on my WIN machine with the
Thomas Porschberg Wrote
Thanks for your reply !
On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote:
Yes there is a newer Makfile.pl You might want to try that.
I used a newer one. But the same result. Compilation is ok,
but the tests fail.
One other quick suggestion id to set
Opps me bad typo in the cut and paste. I hate computers. Yest the '.' is
needed.
Andy Hassall [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Yes there is a newer Makfile.pl You might want to try that.
One other quick suggestion id to set
NLS_LANG=WE8ISO8859P15
This is
Claire Lee wrote
I'm on Windows XP. Forgive my ignorance, can you
explain why DBI:ODBC needs to be recompiled? Why do
you think this may be the problem? I've always thought
I can download a module and use it. Never thought a
later DBI version will be incompatible with an older
one. Thank you for
Claire Lee wrote
Downloading the latest DBD::ODBC does solve the
problem. Thank you very much.
Your welcome
Cheers
John Scoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Claire Lee wrote
I'm on Windows XP. Forgive my ignorance, can you
explain why DBI:ODBC needs
The latest version of the README.win32.txt for DBD.Oracle has a faily
detailed tutorial on how to compile a DBD modual on windows.
http://svn.perl.org/modules/dbd-oracle/trunk/README.win32.txt
It is for DBD:Oracle but is should work much the same for DBI::Mysql
I have searched around a bit and have no real answer for you. A much
earlier post (2004) on this list said
You have probably worked this out by now, but what you are trying to do
is not directly possible with the current version of DBD::Oracle. If
you are returning a VARRAY, there are some ways
Rusek Sebastian-ASR046 [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
HI,
I did according to the instruciton: http://www.esoftmatic.com/DBI/.
But I found the problem as in title :
install_driver(Oracle) failed: DBD::Oracle object version 1.15 does not
match bootstrap parameter 1.06
have a look at this file
http://svn.perl.org/modules/dbd-oracle/trunk/README.win32.txt
it has very detailed instructions on how to install DBD:Oracle on windows.
Though not for DBI the steps 5 through 11 will show you hao to configure
your C++ enviroment
try
$sth-execute() or die Unable to insert the value: $dbi::errstr\n;
rather than
$sth-execute()||die Unable to insert the value: $dbi::errstr\n;
I took the liberty of rewriting part of your code a little so it is more
readable and it is using params. This is a much more secure way to do CGI
Ugg!!
first coice is to rebuild the table
second choice
I found that wrapping the offending field name in [ ] worked with ODBC and
OLE but I am not sure how this will workd with DBI?
something like this
SELECT * FROM taskhours_per_date WHERE [EMPLOYEE NAME] = 'NAME HERE'
might work
I am going to spend a little time on this one later today. I will try to set
up a simialr enviornment but I think you will have to get an old version or
the Oracle client and Oracle installer to get it to work.
Michael Kebe [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello DBI
After over 14 months a new release of DBD::Oracle is ready!
DBD::Oracle 1.17 has been released.
From Tim Bunce:
: With this release of DBD::Oracle John Scoles at The Pythian Group
(http://www.pythian.com)
: is taking on the role of lead maintainer - with my support and gratitude.
: So I guess
Glad you solved it.
Michael Kebe [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Install Oracle 9 and build DBD::Oracle using that.
Now it works! Thank you very much!
But I have one remark. I built it with the step by step guide by John
Scoles (README.win32.txt). But at step 16
Might be a problem with you TNSNAMES.ORA files or something like that. If
your DBD is reading from one there should be no problem reading another
even a different version it is just a matter of changing you connection
string
for eample
$db = DBI-connect('dbi:Oracle:','[EMAIL
Hard to say for sure it could be one of a number of things. First what are
the details on your system version of perl and DBI and DBD:Oracle here are a
few things to check
Some causes could be
1) You have not installed
Interesting I will see if I can recreate it. You can also report this bug
here
http://rt.cpan.org/Public/Dist/Display.html?Status=ActiveName=DBD-Oracle
and we can track it.
Cheers
John Scoles
Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED] wrote in
message news:[EMAIL PROTECTED
Scoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Interesting I will see if I can recreate it. You can also report this bug
here
http://rt.cpan.org/Public/Dist/Display.html?Status=ActiveName=DBD-Oracle
and we can track it.
Cheers
John Scoles
Garrett, Philip (MAN-Corporate) [EMAIL
Opps Forgot to add
DBD:Oracle 1.17
John Scoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Interesting I will see if I can recreate it. You can also report this bug
here
http://rt.cpan.org/Public/Dist/Display.html?Status=ActiveName=DBD-Oracle
and we can track it.
Cheers
Just ran the same test in the windows environment and the test did fail as
follows
t\rebind_nchar..skipped
all skipped: Unable to encode utf8
I will have to look into it further in windows anyway,
cheers
John Scoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED
-unicode/2003-12/msg00013.html
I will still poke around with it though.
By the way my database is set up for USASCII
Cheers
Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED] wrote in
message news:[EMAIL PROTECTED]
-Original Message-
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Monday
You can try installing the latest version. 1.17. Check out the readme for
win32 it should give you all the information.
cheers
John Scoles
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Dear dbi-guru's,
after having not used dbi for more than one year, I a trying to use perl
This is can be a number of things but it is definitely a configuration
problem of some sort as Oracle has some environment variables that are
critical,
so check your LD_LIBRARY_PATH, ORACLE_HOME, and NLS_LANG paths
These values may not be set for the user attempting to run the app.
Check with
Since you are in windows you might want to just to use Activeperl and ppm to
get the latest version which I think is
' DBD-DB2 [0.76] DBD-DB2'
- Original Message -
From: Bergners, Andrei [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Friday, March 31, 2006 10:01 AM
Subject: DB2.pm
give a
rough opinion.
cheers
John Scoles
Alan Burlison [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Garrett, Philip (MAN-Corporate) wrote:
If you run:
LD_DEBUG=libs perl -MDBD::Oracle -e1
You'll see what paths the dynamic linker is searching for the Oracle
libs
If you have changed your Oracle client then you will have to at least
recompile DBD:Oracle for that client. If you are working with 10g client
then I would suggest upgrading to Oracle:dbd to 1.17
cheers
Rolando Arquiza [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
We are running
John Scoles
Oscar Gomez [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
i have this error when i made interface program perl with oracle 10g
trough
DBD module.
DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments:
[kpofdr-long], [], [], [], [], [], [], [] (DBD ERROR
You do not need an Oracle Database installed.
However, you at least need an Oracle client installed on the same box. This
is the Oracle_home that DBD:Oracle wants.
Cheers
John Scoles
***
The information contained
Using DBI 1.40 (for perl 5.006001 on sun4-solaris) installed in
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DB
That version of DBI is over 2 years old so I doubt it will work with
DBD::Oracle 1.17. You might want to try upgrading your DBI first.
MIKE VANOLE [EMAIL PROTECTED]
Yes one can quite simply at least for a Stored procedure as for a function
you may have to wrap it in some SQL first.
my $db=;
my $db = DBI-connect();
my $desc = 'Comments from user ';
my $desc_out =;
my $sql=begin insert_comment(:p_id ,:p_desc,:p_desc_out); end;;
my $c=$db-prepare($sql)
There are some critical patches for 9.2.0.7 . Have you installed them?
This might clean up your problem.
One other though have you rebuilt your DBD::Oracle with 9.2.0.7?
Tobin Stelling [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
My coworkers and I have a question
Not really a good list for that. Try an SQL list but here is one answer
update table.x set field.x=field.x+1
No doubt there are hundreds of other ways to do this.
- Original Message -
From: Akpome Akpoguma [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Tuesday, May 02, 2006 9:40 AM
With all the different versions of the Oracle Client out there you will have
to compile DBD::Oracle for the client you want to use so a PPM may not work
anyway.
You best bet is to get the source then compile and install it to the client
you are using.
cheers John Scoles
- Original Message
Cheers.
John Scoles
- Original Message -
From: Chen, Andrew [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, May 10, 2006 5:09 PM
Subject: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17
The following test is failing during make test:
[EMAIL PROTECTED] DBD-Oracle
Funny I do not get that. When I use PPM
Can you run the settings , Target and repository commands and show the
results to?
Robert Hicks [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Reidy, Ron wrote:
Not according to this:
http://ppm.activestate.com/BuildStatus/5.8.html
There is the difference I do not have the rep
[1] theoryx
can you do a rep describe on it for me?
- Original Message -
From: Robert Hicks [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Friday, May 12, 2006 1:17 PM
Subject: Re: DBD-Oracle.ppd
John Scoles wrote:
Funny I do not get
before the build this may fix it.
I will try to recreate your system exactly next week if I can find a spare
DB around here to play with.
Cheers John Scoles
- Original Message -
From: Chen, Andrew [EMAIL PROTECTED]
To: John Scoles [EMAIL PROTECTED]; dbi-users@perl.org
Cc: Furman, Michael
and see if you have any
special features set on you DB.
I have seen this most often with people trying to log in as the SYS user
you may want to try a different user.
cheers
John Scoles
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Sent
Looks like the DBD:Oracle module was not compiled correctly for your
current Oracle client or DBD:Oracle did now install correctly or is not
installed.
You will most likely have to recompile and reinstall the latest version of
DBD::Oracle.
Can you tell us what version of DBI, DBD:Oracle, Oracle
compare for yourself
http://www.xs4all.nl/~hmbrand/dpws2006/prfo.html
- Original Message -
From: Reidy, Ron [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; dbi-users@perl.org
Sent: Wednesday, June 14, 2006 1:17 PM
Subject: RE: Is Perl-DBI Slow?
No true. The DBD::Oracle module essentially is
What version of DBI and DBD:Oracle are you using and which Oracle client.
You may have to upgrade you DBI and DBD::Oracle to the latest version. This
can be done though PPM.
- Original Message -
From: Sundeep Maini [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, June 14, 2006
it as a BLOB. (Tomorrow is my
DBD::Oracle day so I may get to look at it)
cheers John Scoles
- Original Message -
From: Todd Chisholm [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Thursday, June 22, 2006 1:54 PM
Subject: Getting spatial data?
Hi all,
I'm trying to get some sdo data
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
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
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
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
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
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
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
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
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
::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
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
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
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?
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
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
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:
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
. 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
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
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
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
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
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
(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
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
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
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
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
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
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
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
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
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?
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,
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
1 - 100 of 514 matches
Mail list logo