in and out parameters

2002-11-22 Thread Carlos Barroso
Hy there. Can someone please tell me if DBD::Oracle accepts OUT parameters in stored procedures? Something like: eval { $proc = $dbh-prepare(q{ BEGIN PKG_XPTO.PROCESS(parameter1_out = :param1, parameter2_out = :param2); END; });

RE: in and out parameters

2002-11-22 Thread Steve Baldwin
The answer (I'm pretty sure) is 'Yes'. Check out the statement handle method bind_param_inout in the DBI documentation. -Original Message- From: Carlos Barroso [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 November 2002 7:51 PM To: [EMAIL PROTECTED] Subject: in and out parameters Hy

Re: in and out parameters

2002-11-22 Thread Michael A Chase
On Fri, 22 Nov 2002 08:50:35 - Carlos Barroso [EMAIL PROTECTED] wrote: Can someone please tell me if DBD::Oracle accepts OUT parameters in stored procedures? Something like: eval { $proc = $dbh-prepare(q{ BEGIN PKG_XPTO.PROCESS(parameter1_out = :param1,

ODBC? From Linux to SQL Server

2002-11-22 Thread Roderick A. Anderson
I'm just starting to build a script to load some data into SQL Server running on one system using perl and DBI from another system (Linux). My first attempt to install DBD-ODBC on the Linux system and searches on the web lead me to think this will be a major pain. The install on the Linux box

RE: execute fails in loops only

2002-11-22 Thread Paul Boutros
Hi Jeff, Sorry for the slow replies, and thanks for your help here. 1) What version of DBD::ODBC are you using? I picked up off ActiveState -- the $id line is: # $Id: ODBC.pm,v 1.12 1998/08/14 19:29:50 timbo Exp $ 2) What version of Access are you using? What version of the ODBC driver for

RE: execute fails in loops only

2002-11-22 Thread Paul Boutros
I'm not sure about Access, but some underlying databases don't like multiple statements open at the same time on a single database handle. Just for testing, try opening separate database connections for each statement and see if that helps. # For example (untested): $sth_a = $dbh_a

Re: DBD::Pg timings

2002-11-22 Thread Paul Boutros
I'm having similar problems with DBD::ODBC and I wanted to clarify my understanding of a couple of things you're mentioning here! On Thu, Nov 21, 2002 at 09:25:13AM -0700, Jason E. Stewart wrote: I'd be grateful if someone could give me a reality check. I have 250k rows I want to insert

Re: DBD::Pg timings

2002-11-22 Thread Jason E. Stewart
Paul Boutros [EMAIL PROTECTED] writes: I'm having similar problems with DBD::ODBC and I wanted to clarify my understanding of a couple of things you're mentioning here! On Thu, Nov 21, 2002 at 09:25:13AM -0700, Jason E. Stewart wrote: I'd be grateful if someone could give me a reality

RE: DBD::Pg timings

2002-11-22 Thread David Duff
i just did some performance tests using DBD::Pg - here are quick results. i timed inserts of 100k records using the following three techniques: 1. row-at-a-time insert using a prepared insert statement. 2. copy table from stdin, followed by repeated calls to putline. 3. copy table from tempfile

Installing DBI

2002-11-22 Thread Chris Faust
Please forgive what I'm sure is a really stupid question - but the fact is I've never been in a situation where I didn't have root access to install my modules. I need to get DBI on a web server where I have no SSH/Telnet access, if I take DBI.pm off my local machine and put it on the web server

RE: Installing DBI

2002-11-22 Thread Sterin, Ilya (I.)
Wow, a big no no. You can't do that with a module that's has XS (C) code. The DBI.pm interfaces with the XS code, therefore, just copying DBI.pm does nothing with the C object files, nor the XS interface. It might still work as it does in your case, but you are not taking advantage of any

Re: DBD::Pg timings

2002-11-22 Thread Jason E. Stewart
David Duff [EMAIL PROTECTED] writes: i just did some performance tests using DBD::Pg - here are quick results. Awesome David, thanks for this. After reviewing my DB design I realized that I had some fkey constraints that I didn't need to have and this was probably slowing things down. I'm

Re: DBD::Pg timings

2002-11-22 Thread Tim Bunce
On Fri, Nov 22, 2002 at 03:43:59PM -0700, Jason E. Stewart wrote: David Duff [EMAIL PROTECTED] writes: 1. 1053 records per second 2. 3225 records per second 3. 3448 records per second I was seeing about 10 records/sec!! So I'll take any of these results. Weren't you also doing a

getting manipulating data from a database

2002-11-22 Thread Al Hospers
hi I know I am missing a lot in my knowledge, but I'm trying to figure something out seemingly am in a hole... the task is as follows: 1) query a mysql database for as many records as match a criteria (I can do this OK) 2) put the resulting records, how ever many there are, into a

DBD::Oracle on OS X Success!

2002-11-22 Thread Tom Mornini
Thanks to Andy Lester [EMAIL PROTECTED] and Steve Sapovits [EMAIL PROTECTED], I've figured out a way to get DBD::Oracle to compile and pass all tests on OS X 10.2.2 Jaguar against Oracle 9iR2 DP. It's quite ugly. I'm working on a simpler procedure and I'll share it if it pans out. Here's the

Re: execute fails in loops only

2002-11-22 Thread Michael A Chase
On Fri, 22 Nov 2002 14:21:48 -0500 (EST) Paul Boutros [EMAIL PROTECTED] wrote: Indeed, using multiple $dbh's didn't make any difference. Also, the DBI documentation lends the impression that -finish() shouldn't generally be called explicitly. I have found it necessary for statements where

RE: Installing DBI

2002-11-22 Thread Chris Faust
Thanks Ilya, not really the answer I was hoping for but exactly the answer I needed. Off Topic but -- Is it safe to assume if the module has no need of a C compiler then it would be safe to simply pass around the pm file and count on it working? Or is there no promises there either? Thanks Again

RE: Installing DBI

2002-11-22 Thread Sterin, Ilya
Yes, and no. If there is no C code involved in most cases, you can move the ..pm file around, be warned though, some modules are abstracted into a variety of modules and might depend on other .pm files in the package. So if you move all of them to the place and non of them rely on XS, then you

RE: ODBC? From Linux to SQL Server

2002-11-22 Thread Sterin, Ilya (I.)
Read the valuable FAQ:-) www.xmlproj.com/cgi/fom.cgi Ilya -Original Message- From: Roderick A. Anderson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 1:30 PM To: [EMAIL PROTECTED] Subject: ODBC? From Linux to SQL Server I'm just starting to build a script to load some