Re: Getting spatial data?

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

Re: ERROR : Could not connect: ERROR OCIEnvInit

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

Re: Is Perl-DBI Slow?

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

Re: Error while executing DBI module

2006-05-30 Thread John Scoles
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

Re: (Fwd) Just a quick question on the DBI perl mod

2006-05-24 Thread John Scoles
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

Re: DBD-Oracle.ppd

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

Re: DBD-Oracle.ppd

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

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

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

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

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

Re: DBD-Oracle.ppd

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

Re: Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()

2006-05-02 Thread John Scoles
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

Re: Increment a field value

2006-05-02 Thread John Scoles
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

Re: Oracle functions through DBI?

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

Re: DBD::Oracle install problems

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

Re: DBD:Oracle

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

Re: problem DBD-Oracle-1.17 linux enterprise AS

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

Re: Oracle Module

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

Re: Transactions: DBI vs. SQL

2006-04-05 Thread John Siracusa
On 3/25/06 6:24 PM, John Siracusa wrote: I expect the following two pieces of code to give the same result. One is SQL, fed directly to Postgres using the psql command-line tool, and the other is Perl code using DBI. Before I file this as a bug in DBD::Pg, I want to make sure it's

Re: Problem on Solaris 8 64-bit.

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

Re: DB2.pm for Perl 5.8 needed

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

Re: Transactions: DBI vs. SQL

2006-03-26 Thread John Siracusa
: invalid done_begin turned off - rollback= 1 at new.pl line 38 -John

Re: Problem with perl 5.8.8 with Oracle 9.0

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

Re: Slash-Error in script while Installing DBD-Oracle 116 on Active-State-Perl 5.8

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

Re: DBD::Oracle error when switching between utf8 and non-utf8

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

Re: DBD::Oracle error when switching between utf8 and non-utf8

2006-03-06 Thread John Scoles
5.8 DBI 1.48 Oracle Inastantclient Linux32 10.2.0.1 I will also check it on windows later today. The only thing that I noticed was that I have export NLS_LANG=.WE8ISO8859P15 set in my profile. John

Re: DBD::Oracle error when switching between utf8 and non-utf8

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

Re: DBD::Oracle error when switching between utf8 and non-utf8

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

Re: DBD::Oracle error when switching between utf8 and non-utf8

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

Re: Can't connect to Sybase Rep server

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

Re: Problems with Oracle 8 and 9

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

Re: DBD::Oracle and Oracle 8

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

ANNOUNCE: DBD::Oracle 1.17

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

Re: DBD::Oracle and Oracle 8

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

Re: Column names have spaces in them!!!

2006-01-31 Thread John Scoles
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

Re: dbi::errstr error.

2006-01-27 Thread John Scoles
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

Re: DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06

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

Re: have problems in intalling dbi module

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

Re: bind varray as in or inout param

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

Re: help me with this error

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

Re: DBI 1.48 connection failure to MS SQL

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

Re: DBD::Oracle and 10g

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

Re: DBI 1.48 connection failure to MS SQL

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

Re: Convenience function selectall_hasharrayref

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

Re: DBI 1.48 connection failure to MS SQL

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

Re: How many rows can be fetched using DBD::Informix?

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

Re: install DBD-Oracle win32

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

Re: DBD::Oracle and 10g

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

Re: DBD::Oracle problem

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

Re: Install DBI/DBD on 64 bit linux (eagle64)

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

Install DBI/DBD on 64 bit linux (eagle64)

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

ANNOUNCE: Rose::DB::Object 0.601 released

2006-01-01 Thread John Siracusa
/ * Documentation on CPAN: http://search.cpan.org/dist/Rose-DB-Object/ -John --- 0.601 (01.01.2006) - John Siracusa [EMAIL PROTECTED] * Fixed some incorrect deep join tests. * Reduced the number of Postgres database connections used in the test suite in order to avoid hitting Postgres's

Re: UNKNOWN OCI STATUS 1804

2005-12-30 Thread John Scoles
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.

Re: select placeholder

2005-12-12 Thread John
Capacio, Paula J wrote: John wrote: Can anyone see the error in the following code. It has to do with the placeholder in the select statement. Substitution fails to occur at the $sth1-execute... statement script dies at while (my $rowref If I replace the placeholder with a literal

Re: select placeholder

2005-12-11 Thread John
nothing. John -Original Message- From: John [mailto:[EMAIL PROTECTED] Sent: Saturday, December 10, 2005 10:40 PM To: dbi-users@perl.org Subject: select placeholder Hi Can anyone see the error in the following code. It has to do with the placeholder in the select statement

Re: select placeholder

2005-12-11 Thread John
John wrote: Ian Harisay wrote: Try SELECT * FROM a1 WHERE custnum = ? Thank you Ian and Ted That is not the problem, I had previously used a single = and went to == when it didn't work, tried again this morning - still doesn't work. SQLite documentation says either is acceptable

select placeholder

2005-12-10 Thread John
) == 0; $sth1-execute($custnum) or die couldn't execute... . DBI-errstr; while (my $rowref = $sth1-fetchrow_arrayref) { ($asset, $custnum, $branch, $customer, $address, $town, $postcode) = @$rowref; [/code] -- Regards John McMahon [EMAIL PROTECTED]

Re: Trying to install Oracle DBD and getting errors

2005-12-07 Thread John Scoles
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

RE: is there a bind_hash()?

2005-12-02 Thread Moon, John
Subject: is there a bind_hash()? Hi all, Is there a CPAN module out there that implements something like bind_hash() from this article: http://www.perl.com/pub/a/2001/03/dbiokay.html My searches aren't coming up with anything. Basically I'm looking for something like this snippet:

Re: What's the best free DB for a web-based app?

2005-12-01 Thread John Scoles
that might be important for your decision like recoverability, scalability and flexibility. HTH! GL! Rich -Original Message- From: John Armstrong [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 7:02 PM To: dbi-users@perl.org Cc: cgiapp@lists.erlbaum.net Subject: What's the best free

RE: [cgiapp] Best free DB for a web-based Perl app response results...

2005-12-01 Thread John Armstrong
Jesse Erlbaum - thanks much for your very insightful comments - we stand corrected - we're back in the MySql camp!!! - John Armstrong - Sacramento

Re: is there a bind_hash()?

2005-12-01 Thread John Siracusa
(and probably a teeny bit faster) like this: $sth-bind_columns([EMAIL PROTECTED]@fields}); -John

Re: What's the best free DB for a web-based app?

2005-12-01 Thread John Siracusa
, partitioned or otherwise, that that they can actually do useful work with, I'd like to hear about it... :) -John

Re: What's the best free DB for a web-based app?

2005-11-30 Thread John Armstrong
. Tim Bunce [EMAIL PROTECTED]To: John Armstrong [EMAIL

Re: Problem with Oracle 10.2 and Perl dbd/dbi interface

2005-11-30 Thread 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,

What's the best free DB for a web-based app?

2005-11-29 Thread John Armstrong
Hi - I'm soon to be doing a Perl app on the Internet, that'll need database. We want the db to be as free as possible, but still fully multi-user (web-based). Would the best route be MySql on Linux? Random access files? Something else? We want no licensing obligations (no Oracle, Sequal Server,

ANNOUNCE: Rose::DB::Object 0.51 released

2005-11-21 Thread John Siracusa
0.51 (11.20.2005) - John Siracusa [EMAIL PROTECTED] * Added auto-initialization of relationships. * Added loader. Rose::DB::Object now has a loader. (I don't really like that name, but Class::DBI::Loader seems to have set terminology expectations, so there you have it.) RDBO can auto

Re: Compiling dbd-oracle on hpux64

2005-11-18 Thread John Scoles
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

ANNOUNCE: Rose::DB::Object 0.50 released

2005-11-17 Thread John Siracusa
tutorial: perldoc Rose::DB::Object::Tutorial It's not a replacement for the reference-style documentation, but it does give a nice overview of the major features, and how best to use them. -John --- 0.50 (11.17.2005) - John Siracusa [EMAIL PROTECTED] * Added optional lazy-loading

Re: DBI/DBD::mysql: Detecting InnoDB?

2005-11-13 Thread John Siracusa
it, anyway. -John

RE: Executing PL/SQL packages in Perl

2005-11-09 Thread Moon, John
-Original Message- From: logesh kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 6:37 AM To: dbi-users@perl.org Subject: Executing PL/SQL packages in Perl Hi all, Can anybody tell me how to execute a PL/SQL package from Perl through a small example? Thanks

DBI::Statement parsing

2005-10-26 Thread John Cougar
else's experience also? Code frag below sig. Cheers and ta if you can help, John. ___ +-- --++ | John V Cougar __/ / | Voice: +61 2 6208 1683 | | System Engineer / / /\ DBA

RE: SQL::Statement parsing

2005-10-26 Thread John Cougar
issue was NOT a criticism, only an observation, and I will contributed patches as requested ... chat to you offline about this, dude! Thanks heaps for your efforts, Jeff. Keep up the great work. Regards, John. PS On the Structure.pod, it says users should instantiate a parser and pass

Re: Help: Oracle 10G installtion screwed up my perl

2005-10-21 Thread John D Groenveld
PERL5LIB in the bat file which invokes our Perl script. I'm not a DOS expert, but I think the syntax is @set PERL5LIB= Happy hacking, John [EMAIL PROTECTED]

Execute failed: ORA-01026: multiple buffers of size 4000 in the bind list (DBD: oexec error)

2005-10-05 Thread Moon, John
{$is} * 1) or MyDieBatch('Execute failed: ' . DBI-errstr,__LINE__,89); $item_nbr++; } John W Moon Systems Project Analyst Enterprise Information Technology Services (EITS) Department of Management Services 4030 Esplanade Way, Suite 260G Tallahassee, Fl 32399-0950 Office: (850)922

Re: Subclassing the DBI - any good examples?

2005-09-26 Thread John Siracusa
no sense in trying to predict why people will want to subclass. Just make sure it's straightforward, and let the actual instances of subclassing bloom... :) -John

ANNOUNCE: Rose::DB::Object 0.75 released

2005-09-19 Thread John Siracusa
0.075 (09.19.2005) - John Siracusa [EMAIL PROTECTED] * Added support for many to many relationships to Manager's with_objects and require_objects parameters. * Corrected a bug that could cause missing sub-objects when using the Manager's with_objects and require_objects

Problem with placeholder

2005-09-15 Thread Moon, John
but it is not appropriate in all case... Please suggest an appropriate method for the above. Thank you in advance for any help. John W Moon Systems Project Analyst Enterprise Information Technology Services (EITS) Department of Management Services 4030 Esplanade Way, Suite 260G Tallahassee, Fl 32399-0950

ANNOUNCE: Rose::DB::Object 0.074 released

2005-09-15 Thread John Siracusa
Some big changes this time: 0.074 (09.15.2005) - John Siracusa [EMAIL PROTECTED] * Repurposed the with_objects Manager parameter to do explicit LEFT OUTER JOINs instead of implicit inner joins. * Added require_objects Manager parameter to fill the old role of the with_objects

ANNOUNCE: Rose::DB::Object mailing list created

2005-09-07 Thread John Siracusa
] -John

Re: Memoizing non-place-holding sql statements to place-holding

2005-08-22 Thread John Siracusa
/DB/Object/M etadata.pm#allow_inline_column_values It's a bit of a pain, but until DBD::Informix becomes smart enough to detect this on its own (if that's even possible) it's something that has to be handled by the programmer (or, in my case, by the programmer's library :) -John

Re: DBI v2 - The Plan and How You Can Help

2005-08-17 Thread John Siracusa
On 8/17/05 5:39 AM, Tim Bunce wrote: On Tue, Aug 16, 2005 at 03:58:54PM -0400, John Siracusa wrote: I think it'll take years, and much actual production experience building Perl 6 modules before the community learns what works and what doesn't for a Perl 6 API (let alone implementation). So

Re: DBI v2 - The Plan and How You Can Help

2005-08-16 Thread John Siracusa
works best in Perl 6. I'm just saying that maybe DBI, which took the bullet in Perl 5 to some degree, is under no obligation to do so again. (This assumes that we'll have some way to use Perl 5 DBI within Perl 6 to tide us over, of course...) -John

Re: DBI v2 - The Plan and How You Can Help

2005-07-21 Thread John Siracusa
At 8:24 PM + 7/21/05, Terrence Brannon wrote (on poop-group): At 7:05 AM -0400 7/19/05, John Siracusa wrote: I use a module (Rose::DB) that parses and formats db-specific column values for me: various kinds of dates, SETs, arrays, all the crazy db-specific data types that are a pain

Oracle 10g binary_float format

2005-07-18 Thread John Legato
does at Oracle and it looks like some special connection handling needs to be setup. In the short term I am using TO_NUMBER to pull the values out. I'd like native support though, Oracle claims that using binary_float yields large performance gains. John

Re: Oracle schema comparison

2005-06-23 Thread John Watson
check out TOYS (Tool for Organizing Your Schemas) http://www.impacttoys.com John Watson Steve Sapovits [EMAIL PROTECTED] 06/16/05 11:11AM Does anybody know of any good tools (free or otherwise) for comparing two Oracle schemas? I'd want to be able to compare tables, indices, sequences, etc

RE: Finding out the type expected for a placeholder

2005-06-13 Thread Moon, John
From: Jones Robert TTMS Contractor [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 12:17 PM To: dbi-users@perl.org Subject: RE: Finding out the type expected for a placeholder On Mon, Jun 13, 2005 at 02:28:41PM +0100, Avis, Ed wrote: Michael A Chase wrote: I'd like to find out

Oracle client and DBD::Oracle

2005-03-19 Thread John
Hi to all Has anyone tried to install DBD::Oracle with success while Oracle Client is installed? In my case oci.h and some other headers were not found and i ultimately enforced to install the whole database server for the job. Is there any known trick about that?

MySQL::Backup question

2005-03-11 Thread John
Hello Has anyone tried the MySQL::Backup module with sucess? I tried, but the export didn't go well.

Re[2]: MySQL::Backup question

2005-03-11 Thread John
From: Peter L. Berghold [EMAIL PROTECTED] To: John [EMAIL PROTECTED] Date: Friday, March 11, 2005, 5:57:53 PM Subject: MySQL::Backup question Friday, March 11, 2005, 5:57:53 PM, you wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John wrote: Hello Has anyone tried the MySQL

RE: Win98 - DBD-Oracle install issue

2004-12-18 Thread John Berry
-Oracle.ppd Error: No valid repositories: Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error) Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error) I Will try to upgrade to Oracle 8i meanwhile. thanks --john --- Jeff Urlwin [EMAIL PROTECTED] wrote

RE: Win98 - DBD-Oracle install issue

2004-12-17 Thread John Berry
to get DBD access? thanks John Andy Hassall [EMAIL PROTECTED] wrote: The ORACLE_HOME environment variable value (C:/ORAWIN95) is not valid. As well as the other advice you have received, the above rings warning bells. Which version of Oracle are you running? The above looks suspiciously

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread John Berry
to the latest activestate. I see you are installing from 5.8.3, when you only have 5.8.0 (from the perl -v you sent). Were the instructions not clear enough to match? Jeff -Original Message- From: John Berry [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 9:02 AM

RE: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-16 Thread John Berry
`man perl' or `perldoc perl'. If you have access to the Internet, point your browser at http://www.perl.com/, the Perl Home Page. Any clues, regards --john Jeff Urlwin [EMAIL PROTECTED] wrote: Hi Sam, Sorry for cross posting, was trying to get some solution faster. No other intentions. New

Re: cross-posted FAQ question [was: Win98 - DBD-Oracle install issue]

2004-12-15 Thread John Berry
@perl.org/msg23109.html Could you please point me to the right fix. thanks --john --- Sam Vilain [EMAIL PROTECTED] wrote: John Berry wrote: I am trying to install DBD-Oracle-1.16 along with DBI-1.46 DBI was installed successfully, but got errors intalling the DBD-Oracle-1.16. John, Two

Win98 - DBD-Oracle install issue

2004-12-13 Thread John Berry
Hi, I am trying to install DBD-Oracle-1.16 along with DBI-1.46 DBI was installed successfully, but got errors intalling the DBD-Oracle-1.16. C:\Perl\DBD-Oracle-1.16perl Makefile.pl Log: *** You're using Microsoft Visual C++ compiler but the LIB and INCLUDE environme nt variables are not

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-08 Thread John Siracusa
On 12/7/04 5:40 PM, Tim Bunce wrote: On Tue, Dec 07, 2004 at 04:40:51PM -0500, John Siracusa wrote: That's what DBI wrappers do, and I have one of those too. But my DBI wrapper reads its connection information for each logical data source from a hash. Then there's a build_dsn() method

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-07 Thread John Siracusa
of it as an exploded version of a DSN string. DSN strings can be very different, and so too can the exploded versions. -John

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-07 Thread John Siracusa
that for me, I could just pass a reference to my connection info hash directly to DBI-connect() and then remove the build_dsn() code from my wrapper. -John

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-02 Thread John Siracusa
the various DSN formats for the database types I deal with...and I like it that way :) -John

Re: DBI/DBD on 9i with Solaris 9

2004-11-12 Thread John D Groenveld
$ head -1 my_script $ myperl my_script John [EMAIL PROTECTED]

<    2   3   4   5   6   7   8   9   10   >