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;
});
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
19 matches
Mail list logo