Re: Is it correct that execute_array does not raise/print an error

2006-07-04 Thread John Scoles
ss has run 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 -

Re: How to read CLOB return value of Stored Function in Perl

2006-07-06 Thread John Scoles
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 Cisc

Re: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17

2006-07-18 Thread John Scoles
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 c

Re: DBD-Oracle 1.17 gives "install_driver(Oracle) failed"

2006-07-18 Thread John Scoles
-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: Sent: Tuesday, July 18, 2006 12:39 PM Subject: DBD-Oracle 1.17 gives "install_driver(Oracle) failed"

Re: (Fwd) dbd-oracle-1.16

2006-07-20 Thread John Scoles
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 fro

Re: Error while running DBI with Perl and MySQL

2006-07-21 Thread John Scoles
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 Te

ANNOUNCE: DBD:Oracle 1.18

2006-07-24 Thread John Scoles
also 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 us

Re: ANNOUNCE: DBD:Oracle 1.18

2006-07-25 Thread John Scoles
e_array and named parameter binding is that the native OCI does 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 Messa

Re: Segfault with DBD::Oracle 1.17 under mod_perl

2006-07-26 Thread John Scoles
and RHEL I can test on. Chers John Scoles - Original Message - From: "Brandon Maust" <[EMAIL PROTECTED]> To: 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 probl

Re: ANNOUNCE: DBD:Oracle 1.18

2006-07-28 Thread John Scoles
LAG) $(USRFLAGS) > [$(GFLAG) -O3 -fast -fp_reorder -U_FASTMATH -O3 -fast -fp_reorder > -U_FASTMATH $(GEMC_FLAGS) -std1 -DOSF1 -DA_OSF -readonly_strings -ieee > -noansi_alias -D_INTRINSICS -DARCH_EV56 -arch ev56 -tune ev6 $(QACCFLAGS) > -I/u01/app/oracle/product/8.1.7/rdbms/d

Re: DBD-Oracle-1.18/err_unicode/err_twolongstr.msg

2006-07-28 Thread John Scoles
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

Re: Oracle 10G Connectivity with DBI and DBD in UNIX

2006-08-28 Thread John Scoles
>>""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 Configu

Re: DBD-Oracle Compatibility

2006-08-28 Thread John Scoles
<[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?

Re: DBI::PurePerl and DBD::Oracle...

2006-08-29 Thread John Scoles
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 PR

Re: Compatible version with Oracle10g - VERY URGENT

2006-09-01 Thread John Scoles
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? ""Sa

Re: Getting DBD::Oracle tests working

2006-09-01 Thread John Scoles
"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 th

Re: Problem in intsalling DBD-Oracle on Windows 2000

2006-09-06 Thread John Scoles
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 PROT

Re: Getting DBD::Oracle tests working

2006-09-06 Thread John Scoles
- Original Message - From: "Karl Auer" <[EMAIL PROTECTED]> To: 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 managed to instal

Re: Getting DBD::Oracle tests working

2006-09-06 Thread John Scoles
- Original Message - From: "Karl Auer" <[EMAIL PROTECTED]> To: 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

Re: Getting DBD::Oracle tests working

2006-09-06 Thread John Scoles
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: Sent: Wednesday, September 06, 2006 10:08 AM Subj

Re: Getting DBD::Oracle tests working

2006-09-06 Thread John Scoles
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" <

Re: Oracle TAF with DBD::Oracle???

2006-09-07 Thread John Scoles
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

Re: DBD-Oracle ?

2006-09-12 Thread John Scoles
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 ppm>install DBD-Oracle error displayed is The procedure entry p

Re: [perl #40331] Installation of DBD 1.18

2006-09-13 Thread John Scoles
. 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: Sent: Wednesday, September 13, 2006 10:03 AM Sub

Re: Help needed for DBD-Oracle Installation in Windows 2003

2006-09-14 Thread John Scoles
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 S

Re: DBI->connect Oracle on Windows, doesn't Work

2006-09-22 Thread John Scoles
it is dbi:Oracle: not DBI:Oracle it is case sensitive. cheers John Scoles - Original Message - From: "Christophe ANTOINE" <[EMAIL PROTECTED]> To: Sent: Friday, September 22, 2006 10:29 AM Subject: DBI->connect Oracle on Windows, doesn't Work Hello, I ha

Re: DBD 1.18a make not working

2006-09-28 Thread John Scoles
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

Re: DBD 1.18a make not working

2006-09-28 Thread John Scoles
- Original Message - From: "Martin Gainty" <[EMAIL PROTECTED]> To: "Martin J. Evans" <[EMAIL PROTECTED]>; 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 The second th

Re: Compiling DBD::Oracle 1.17 with LD_RUN_PATH

2006-09-29 Thread John Scoles
. cheers John Scoles - Original Message - From: "Ronald J Kimball" <[EMAIL PROTECTED]> To: 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'

Re: DBD::Oracle and Oracle 8 "AGAIN"

2006-10-04 Thread John Scoles
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

Re: DBD::Oracle and Oracle 8 "AGAIN"

2006-10-04 Thread John Scoles
lisence for the code and the person/s receiving it also have a valid lisence. This does not count for the instant client as permission is granted to use it freely. I will be looking into the matter a little more deeply this is just my first look at it. Cheers John Scoles ""J

Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread John Scoles
What exactly did you remove? - Original Message - From: "listmail" <[EMAIL PROTECTED]> To: Sent: Friday, October 13, 2006 1:41 PM Subject: [Fwd: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home] I simply removed the extra cc reference and ran it manually then ran make again

Re: compiling DBD-Oracle 1.16 against an Oracle 9i 64bit home]

2006-10-13 Thread John Scoles
ok that look like a bug of some sort. I will see if I can change the makefile.pl for monday. Cheers John Scoles - Original Message - From: "listmail" <[EMAIL PROTECTED]> To: "John Scoles" <[EMAIL PROTECTED]> Cc: Sent: Friday, October 13, 2006 2:37 PM S

Bug with Oracle 10.2.0.2 for Solaris 64bit

2006-10-19 Thread John Scoles
identifier specified (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

Re: DBD::Oracle 1.07 and selectall_arrayref

2006-10-31 Thread 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: Cc: "Sergey Brutsky" <[EMAIL PROTECTED]> Sent: Tuesday, October 31, 2006 6:23

Re: DBD::Oracle 1.07 and selectall_arrayref

2006-10-31 Thread John Scoles
ot;Sergey Brutsky" <[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

ANNOUNCE: DBD::Oracle 1.19

2006-11-03 Thread John Scoles
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 it

Re: Insert/Update performance issues with Oracle 10gR2 + DBI + DBD::Oracle

2006-11-08 Thread John Scoles
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 DBD::Oracl

Re: bind_param oddity?

2006-11-22 Thread John Scoles
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.

Re: DBD Oracle: multiple statements in a single execute?

2006-11-28 Thread John Scoles
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 fie

Re: DBD::Oracle 1.19 failing to make

2006-12-13 Thread John Scoles
funny warning in that it cannot find SQL*Plus. Cheers John Scoles - Original Message - From: "Camara, Ronneil" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 12, 2006 1:12 PM Subject: DBD::Oracle 1.19 failing to make Hi, I need some help. The "make"

Re: Would you please do me a favor?

2006-12-20 Thread John Scoles
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 P

Re: DBD-Oracle and Oracle versions

2006-12-20 Thread John Scoles
""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::Oracl

Re: regarding installing dbd-oracle

2006-12-21 Thread John Scoles
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: Sent: Thursday, December 21, 2006 5:02 AM Subject: reg

Re: utf8 encoding problem

2006-12-21 Thread John Scoles
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 insta

Re: Perl lib version not match executable version

2007-01-05 Thread John Scoles
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: Sent: Thursday, January 04, 2007 9:05 PM Subject: RE: Perl lib version not match executable version Anyone can help? Thanks. __

Re: Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread John Scoles
I would say yes as DBD::Oracel 1.06 is about 13 revisoins out of date. - Original Message - From: <[EMAIL PROTECTED]> To: 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, Appreciate if someon

Re: determining Oracle bind types

2007-01-17 Thread John Scoles
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 Oracl

Re: Positively Archaic Versions of DBI and DBD::Oracle

2007-01-19 Thread John Scoles
You can send me the code for DBD::Oracle if you want. I can load into to subversion http://svn.perl.org/modules/dbd-oracle and have people can have access online from there. They would be under the tags dir. cheers - Original Message - From: "Jonathan Leffler" <[EMAIL PROTECTED]> To:

Re: bind variable problem

2007-01-23 Thread John Scoles
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 pr

Re: DBD::Oracle make test problems again

2007-01-23 Thread John Scoles
Seems to have compiled ok perhaps your Oracle user account you are using for your tests dose not have enough priviliages/rights or something like that. Try an install with out the test and then see it it works? - Original Message - From: Weaver John Cairns CONT NSSC To: 'dbi-users

Re: (Fwd) Re: New Oracle "Instant Client"

2007-01-24 Thread John Scoles
- Original Message - From: "Tim Bunce" <[EMAIL PROTECTED]> To: 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 <[EMAIL PROTECT

Re: (Fwd) Re: New Oracle "Instant Client"

2007-01-24 Thread John Scoles
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 t

Re: DBD::Oracle installation failed

2007-01-26 Thread John Scoles
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

Re: DBD::Oracle-1.19 installation errors

2007-01-30 Thread John Scoles
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 syst

Re: Installation of DBD Oracle

2007-02-01 Thread John Scoles
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: Sent: Thursday, February 01, 2007 11:12 AM Subject: Installation of DBD Oracle Hello, After installing DBI, I tr

Re: DBD Oracle connection problem

2007-02-02 Thread John Scoles
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: Sent

Re: ANNOUNCE: DBI 1.54 RC6 - including cool new DBD::Gofer stateless proxy

2007-02-20 Thread John Scoles
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

Re: ANNOUNCE: DBI 1.54 RC6 - including cool new DBD::Gofer stateless proxy

2007-02-20 Thread John Scoles
Well 85gofer.t ran this time but the results are not encouraging see attached. I also attached the 85gofer.t I used so you can check to see if I used the right one. - Original Message - From: "Tim Bunce" <[EMAIL PROTECTED]> To: "John Scoles" <[EMA

Re: ANNOUNCE: DBI 1.54 RC7

2007-02-20 Thread 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: Cc: "Tim Bunce" <[EMAIL PROTECTED

Re: ANNOUNCE: DBI 1.54 RC7

2007-02-21 Thread John Scoles
Well on windows I got All tests successful, 22 tests and 260 subtests skipped. Hooray!!! on to RC8!! Just for your info Tim I am on Windows XP Home Edtion SP2 using Visual C++ Toolkit 2003 and activeperl version 5.008008 Cheers John - Original Message - From: "Tim Bunce" <[EMAIL PR

DBI 1.54 RC8 Windows XP testing results

2007-02-22 Thread John Scoles
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:

Re: (alleged-)Null-Operation speeds up DBD::Oracle by factor 25

2007-02-27 Thread John Scoles
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 t

Re: DBD::Oracle-1.19 installation error

2007-02-27 Thread John Scoles
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]> w

Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch won't install

2007-03-08 Thread John Scoles
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 this.

Ok this time I am stumped

2007-03-09 Thread John Scoles
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 con

RE: how to compile DBI/DBD

2007-03-15 Thread John Scoles
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: Subject: how to compile DBI/DBD Date: Thu

RE: how to compile DBI/DBD

2007-03-15 Thread John Scoles
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 that

RE: BIG Problems after installing Oracle Discoverer

2007-03-17 Thread John Scoles
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 ta

Re: Cannot Install DBD ORacle in Win Xp

2007-03-26 Thread John Scoles
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 co

Re: Problem compiling DBD-Oracle

2007-04-02 Thread John Scoles
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 Orac

Re: 24implicit_utf8.t fails when compiling DBD-Oracle-1.19

2007-04-02 Thread John Scoles
Actullly I think this was a bug in the Oracle client it has been croping up every once and a while but only with specific client versions.. I have been working on it and plan to do a little more this week Thanks for the leads on this. "Jim Ursetto" <[EMAIL PROTECTED]> wrote in message news:[

Re: DBD::Oracle patch to set charset via connect attribute

2007-04-02 Thread John Scoles
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 = DB

Re: DBD::Oracle patch to set charset via connect attribute

2007-04-02 Thread John Scoles
- Original Message - From: "Stephen J. Smith" <[EMAIL PROTECTED]> To: 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 th

Re: Looking for help with odd DBD::Oracle::db prepare behavior

2007-04-03 Thread John Scoles
Hard to say whitout seeing your origninal Perl code that strips out the '-' Just a quick suggestion is to use scalar() (should force them to be a number) around each befor you add the ','. Getting in staments like this working in DBD::Oracle is one of my little pet projects if I ever get any

Re: DBD::Oracle crashes non-deterministic

2007-04-03 Thread John Scoles
If you are getting " DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) " errors on 10 it is a know a bug in Oracle. http://forums.oracle.com/forums/thread.jspa?messageID=1668176 - Original Message - From: "Kai Schwermann" <[EMAIL PROTECT

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

2007-04-05 Thread John Scoles
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 a

Re: DBD-Oracle-1.19 will not make nice

2007-04-07 Thread John Scoles
::Oracle that you were using before? cheers John Scoles - Original Message - From: "Joe Torres" <[EMAIL PROTECTED]> To: 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 assis

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

2007-04-09 Thread John Scoles
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]&

Re: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build

2007-04-11 Thread John Scoles
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 http://research.imb.uq.edu.au/~

Re: :Oracle function

2007-04-11 Thread John Scoles
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 co

Re: DBD::Oracle Install Fails on Gentoo Linux

2007-04-12 Thread John Scoles
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 Mess

Re: DBD::Oracle patch to set charset via connect attribute

2007-04-13 Thread John Scoles
7 12:12 PM Subject: Re: DBD::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 c

Re: perl dbi memory error?

2007-04-16 Thread John Scoles
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

Re: DBD:Oracle-1.19 Can't load Oracle.dll

2007-04-16 Thread John Scoles
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 machin

Re: Make failure on DBD-Oracle-1.19 "lclntsh: not found" -- Solaris 10

2007-04-17 Thread John Scoles
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"" <[E

Re: :Oracle - Any advance on inserting CLOB to XMLTYPE?

2007-04-24 Thread John Scoles
te in message news:[EMAIL PROTECTED] > 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-

Re: DBI AND DBD-ORACLE

2007-04-27 Thread John Scoles
Looks like windows has locked some files. You will have to either 1) record where the files are on the disks 2) reboot your box and see if you can uninstall 3) if you cant then try to delete them through explorer 4) if this fails open a dos window and delete them using good old dos erase 5) if

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testing with RH lunix Red Hat Linux 3.2.3-54 and perl 5.8 Ran Perl Makefile.PL but with this warning *** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments. *** Note: The optional PlR

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Well just had another crack at it with a little more success I checked my ENV variable and I had LANG=en_US.UTF-8 set I removed this from my ENV and the Makefile.PL make and make test all worked as expected ""John Scoles"" <[EMAIL PROTECTED]> wrote in mess

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows XP Home Edition 2002 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. "Tim Bunce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You can download it from > >http://homepage.mac.com/tim.bunce/.P

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Server 2003 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. "Tim Bunce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You can download it from > >http://homepage.mac.com/tim.bunce/.Public/perl/

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Vista Home Edition Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. "Tim Bunce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You can download it from > >http://homepage.mac.com/tim.bunce/.Public/per

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Opps forgot to note that all my Windows testing was done with the latest version of ActivePerl "Tim Bunce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > You can download it from > >http://homepage.mac.com/tim.bunce/.Public/perl/DBI-1.55-RC3.tar.gz > > =head2 Changes in DBI 1

Re: proliferation of error messages

2007-05-04 Thread John Scoles
What are the messages??? - Original Message - From: "Mary Anderson" <[EMAIL PROTECTED]> To: Sent: Friday, May 04, 2007 1:04 PM Subject: proliferation of error messages Hello all, My perl cgi script which runs dbi is generating error messages to the logs just about everytime db

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
. cheers John Scoles - Original Message - From: "ramesh thangamani" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: Wednesday, May 09, 2007 3:09 AM Subject: Clarification on DBI module Hi, Can you please clarify my doubts regarding DBI perl mod

Re: Clarification on DBI module

2007-05-09 Thread John Scoles
correctly as it is written by the way. You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. - Original Message - From: ramesh thangamani To: John Scoles ; dbi-users@perl.org ; [EMAIL PROTEC

Re: DBI - DBD with Oracle 10g on Windows XP

2007-05-10 Thread John Scoles
I just did the same yesterday for XP using the readme README.win32.txt so you should have no problems if you follow it. ""Tzekov, Ianko"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi, You can install ActivePerl (I have made it with 5.6, but I think it will work with 5.8 too)

Re: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000

2007-05-22 Thread John Scoles
Are you using IIS7? - Original Message - From: "Fi Dot" <[EMAIL PROTECTED]> To: Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 21, 2007 4:42 PM Subject: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000 Hi All! Recentl

Re: Memory leak, DBI 1.55 + DBD::ODBC 1.13 + MS SQL 2000

2007-05-22 Thread John Scoles
Ok that elliminates one source of the problem. cheers - Original Message - From: "Fi Dot" <[EMAIL PROTECTED]> To: "John Scoles" <[EMAIL PROTECTED]> Cc: ; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECT

<    1   2   3   4   5   6   >