- Forwarded message from Rajesh Yenumulapally [EMAIL PROTECTED] -
Date: Mon, 5 Feb 2001 11:11:13 -0800 (PST)
From: Rajesh Yenumulapally [EMAIL PROTECTED]
Subject: bind param problem
To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
sorry the regular mailing list is not
On Wed, Feb 07, 2001 at 11:50:01AM -0500, Thomas A. Lowery wrote:
Is placeholders not allowed in DDL statements or what?
Looking at this, I'd say no. Note the describe is skipped, so I'd say
the statement isn't really parsed by Oracle until the execute is
called.
dbd_preparse
- Forwarded message from Lee Jonas [EMAIL PROTECTED] -
From: Lee Jonas [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED]
Subject: bind_param_inout and DBD::ODBC
Date: Thu, 8 Feb 2001 17:12:44 -
Hi Tim,
I couldn't find anything on it in the
- Forwarded message from wang [EMAIL PROTECTED] -
From: wang [EMAIL PROTECTED]
To: "Tim.Bunce" [EMAIL PROTECTED]
Subject: How to compile a OCI client on linux?
Date: Tue, 14 Nov 2000 01:48:29 +0800
Dear sir,
I've a problem to ask you,
will you please save your prime time to
This is a pre-announcement for Oracle masochists and/or people
who know what Oracle OCI can do and what to get at it from Perl.
To give you a flavor of what you're in for, here's a DBI connect:
use DBI;
DBI-connect("dbi:Oracle:", "scott", "tiger");
Here's the Oracle::OCI version of
- Forwarded message from Prakash Allad [EMAIL PROTECTED] -
From: Prakash Allad [EMAIL PROTECTED]
To: "Tim.Bunce" [EMAIL PROTECTED]
Date: Thu, 15 Feb 2001 11:31:32 -0800
Hi Tim,
My name is prakash. I am new to Perl. I am still in learning stage.
I am getting problem when I try to run
- Forwarded message from Santhosh Kumar [EMAIL PROTECTED] -
Date: Thu, 15 Feb 2001 19:33:00 -0800 (PST)
From: Santhosh Kumar [EMAIL PROTECTED]
Subject: DBI Programming with Perl
To: [EMAIL PROTECTED]
Hi Tim,
I am very new to Perl Programming. I need to use Perl
to talk to SQL Server
On Fri, Feb 16, 2001 at 06:11:01PM +0100, Honza Pazdziora wrote:
On Fri, Feb 16, 2001 at 04:08:56PM -, Pete Coales wrote:
How come? And how the hell do stop it from doing it...???
Instead of shouting, posting in HTML and including JPEGs, why not show
a minimum code that demonstrates
On Fri, Feb 16, 2001 at 02:55:28PM -0500, Sean Cooper wrote:
Tim,
I apologize in advance for sending this directly to you. I've tried to post it 3
times
to [EMAIL PROTECTED], but for whatever reason it doesn't seem to make it.
I've seen it.
This does seem to work BTW ... but I'm a little
- Forwarded message from John Kolvereid [EMAIL PROTECTED] -
Date: Mon, 19 Feb 2001 10:03:46 -0800 (PST)
From: John Kolvereid [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi Tim,
I sent a distress message to the following address
as you mentioned in the README file of the DBD
download for
Great. Thanks.
Tim.
On Mon, Feb 19, 2001 at 04:23:40PM -0600, Paul Walmsley wrote:
When DBD::Oracle 1.06 fetches a LOB from Oracle that is longer than
LongReadLen and LongTruncOk is not set, it outputs an error message
similar to this one:
DBD::Oracle::st fetchrow_array failed: ERROR
- Forwarded message from Graf Laszlo [EMAIL PROTECTED] -
Date: Mon, 19 Feb 2001 17:49:10 +0100
From: Graf Laszlo [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Organization: Axis Kft.
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: Perl and SQL
Hi Tim
I was looking for an example
On Wed, Feb 21, 2001 at 01:47:32PM -0500, Stewart, Clay wrote:
Not to add more junk, but shortly said, this list is invaluable to us
working day-in day-out punching PERL DBD applications, even if only one
message a day adds to the PERL knowledge vault between my ears. Usually a
few does. So
- Forwarded message from Luis Colon [EMAIL PROTECTED] -
Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST)
From: Luis Colon [EMAIL PROTECTED]
Subject: "Can't call method execute" error "undefined value"
To: [EMAIL PROTECTED]
Please assist:
I'm trying to create an interactive HTML that will
Post
Many of you will have read about the wildly successful Perl Whirl
cruise http://www.geekcruises.com/perl/perl_fromtheboat.html
and http://www.wired.com/wired/archive/8.10/cruise.html
Well, time is running out to sign-up for the unique Geek Cruise
conference experience applied to databases, in...
- Forwarded message from Victor Sokov [EMAIL PROTECTED] -
Date: Fri, 16 Mar 2001 19:47:56 +0100
From: Victor Sokov [EMAIL PROTECTED]
To: "Tim.Bunce" [EMAIL PROTECTED]
Subject: Question MySQL
Hi Tim,
soory to disturb you, just a short question.
My hosting service (www.f2s.com) supports
On Wed, Mar 07, 2001 at 10:27:38PM -0800, Colin Meyer wrote:
On Wed, Mar 07, 2001 at 05:16:02PM +, Tim Bunce wrote:
Ilya's suggestion is a good one.
The next version of the DBI will at least generate a warn()'ing that
can be caught using $SIG{__WARN__} if you need to.
What
If you tell me which you'd like to see and why, and I like what you say,
then your word will be my command (eventually:) !
Better still (and faster still), send me a patch!
Tim.
On Mon, Mar 26, 2001 at 01:06:40PM +0200, Steffen Goeldner wrote:
Tim Bunce wrote:
Thanks for the info. Do you
On Wed, Mar 28, 2001 at 10:32:44AM +0200, Steffen Goeldner wrote:
Tim Bunce wrote:
If you tell me which you'd like to see and why, and I like what you say,
then your word will be my command (eventually:) !
Better still (and faster still), send me a patch!
O.k. The patch is tested
the block (which would
thereforce miss your explicit resetting of the attribue).
Tim.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 9:40 AM
To: [EMAIL PROTECTED]
Subject: Memory leak on local($dbh-{RaiseError})=1 is a perl bug
Here's a copy
It gives me great pleasure to announce the arrival of DBI 1.15:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.15.tar.gz
size: 192879 bytes
md5: b1e37f03bdbd91451102e1b8e4b093d4
Should reach a CPAN near you in the next day or three.
Changes in DBI 1.15,28th March 2001
Added
On Fri, Mar 30, 2001 at 09:24:50PM -0600, MikemickaloBlezien wrote:
On Fri, 30 Mar 2001 16:43:22 +0100, Tim Bunce [EMAIL PROTECTED] wrote:
Was wonder if a new Programming w/DBI book will be coming out that will cover
all these new changes in the near future??
I guess that'll be a second
Here's a patch (with thanks to H.Merijn Brand).
Tim.
diff -c -r10.30 DBI.xs
*** 10.30 2001/03/30 14:35:41
--- DBI.xs 2001/04/02 12:26:57
***
*** 30,36
--- 30,38
#ifdef HAS_SETLINEBUF
#define PerlIO_setlinebuf(f)setlinebuf(f)
#else
+ #ifndef
Ah, well spotted! Many thanks.
Tim.
On Mon, Apr 02, 2001 at 12:38:25PM -0400, T.J. Mather wrote:
I think I might have found a bug with the new selectrow_hashref feature of
DBI under mod_perl using Apache::DBI. When I attempt to use
selectrow_hashref, I get the following error:
Can't
On Mon, Apr 02, 2001 at 12:22:49PM -0700, Michael A. Chase wrote:
DBI 1.15 built, tested, and installed cleanly in WinNT with MingW32 gcc
2.95.2.
When I ran the DBD::Oracle tests t/plslq.t failed at test 54. The test
failed at the same point both before and after I rebuilt DBD::Oracle
On Mon, Apr 02, 2001 at 09:53:10PM -0400, Jim Mahoney wrote:
I recently spent more time than I'd like to admit
trying to understand a bug in my DBI program, and
now that I understand what's going on, I'm writing
to suggest that the documentation show better how the type
conversion from
That was simply an error on my part. Sorry.
Tom, please send me the latest DBD::ADO (or else say that the one
on CPAN is the latest you want included in the DBI).
Tim.
On Mon, Apr 02, 2001 at 10:21:11AM -0700, Jonathan Leffler wrote:
Hi,
I just upgraded from DBI 1.14 to 1.15. After the
On Tue, Apr 03, 2001 at 12:08:03PM +0100, Roland Corbet wrote:
I'm Using DBI::ODBC with MS Access 200.
Can anyone tell me what is the best way of getting hold of the Autonumber
that has just been entered into the database with the previously executed
SQL statement.
Perhaps a "select
- Forwarded message from businesscardsdirect [EMAIL PROTECTED]
-
From: businesscardsdirect [EMAIL PROTECTED]
To: "Tim.Bunce" [EMAIL PROTECTED]
Subject: DBI.pmL
Date: Tue, 3 Apr 2001 11:44:54 -0600
X-OriginalArrivalTime: 03 Apr 2001 17:46:04.0080 (UTC)
That'll be another release soonish.
Bundle::DBI isn't (I believe) supported by ActiveState's PPM.
Tim.
On Wed, Apr 04, 2001 at 06:37:36PM +1000, Neil Lunn wrote:
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 6:17 PM
To: Tim Bunce
- Forwarded message from Chris Gould [EMAIL PROTECTED] -
To: [EMAIL PROTECTED]
From: Chris Gould [EMAIL PROTECTED]
Date: Wed, 4 Apr 2001 14:30:42 +
X-MIMETrack: Serialize by Router on sdbo1003/DMGUK/DeuBaInt/DeuBa(Release 5.0.6
|December 14, 2000) at 04/04/2001 02:33:21
On Wed, Apr 04, 2001 at 12:41:49PM -0700, Dean Arnold wrote:
I think Mssr. Bunce may be the final arbiter as to what
gets rolled into "official" DBI DBD::Oracle.
That being said, my assumption is that the format
suggested by Mr. Turner would likely
also be adopted if/when the
On Thu, Apr 05, 2001 at 03:20:51PM -0700, Michael A. Chase wrote:
Ok, you are unscribed and uncribed.
Do you want to be unsubscribed too? If so, send your message to
[EMAIL PROTECTED]
In general it's probably better to tell people to send a message to
[EMAIL PROTECTED] to get a description
- Forwarded message from Scanman 20 [EMAIL PROTECTED] -
X-Originating-IP: [12.126.209.38]
From: Scanman 20 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: nesting queries?
Date: Wed, 11 Apr 2001 09:50:28 -0400
X-OriginalArrivalTime: 11 Apr 2001 13:50:28.0769 (UTC)
I suspect you're not really using the version you think you are.
Add warn $DBI::VERSON to the code.
Tim.
On Wed, Apr 11, 2001 at 04:37:38PM -0500, Mark Stosberg wrote:
Hello,
I'm now using and enjoying the new features of DBI 1.15 (Thanks
everyone!). I have an odd issue with the new
Well spotted (that one particular test simply calls die() if it fails).
Fixed in the next release. Meanwhile: don't do that :)
Thanks!
Tim.
On Tue, Apr 10, 2001 at 03:44:02PM -0400, Belinda M. Giardine wrote:
DBI 1.14
DBD::Oracle ?
Oracle 8.0.5
Setting RaiseError to 0 doesn't seem to
I'll take a look when I get to DBD::Oracle again. Which I'll do after I
get DBI 1.16 out the door. Which I may do this week or next.
Thanks for the clear report.
Tim.
On Tue, Apr 10, 2001 at 09:38:59PM -0500, Stephen Clouse wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I sent an
It's a bug. I can't remember how non-trivial it is to fix, but I'll
certainly be taking a look at it wen I next work on DBD::Oracle.
Tim.
On Wed, Apr 11, 2001 at 03:02:47PM -0400, Sherry Y. Cui wrote:
Hi,
I need your big help...
The application we are developing for our client is written
.,
owner.Good_picture). This can be avoided if a synonym has been
defined for the table name, but that doesn't appear to be the case in your
database.
I use public synonyms for tables and sequencies.
Known bug. Patch is in the archives. Nag me if you really can't find it.
Tim Bunce.
Which
support a user schema like "[EMAIL PROTECTED]"
Assuming these are merged together, I don't know which
goes first, the synonym or the view and whether they should
iterate until they land on a table. They should probably
follow the Oracle rules, I suppose.
Tim Bunce wrote:
Sh
On Wed, Apr 11, 2001 at 08:43:21PM -0500, Mark Stosberg wrote:
Tim Bunce wrote:
On Wed, Apr 11, 2001 at 05:42:03PM -0500, Mark Stosberg wrote:
Tim Bunce wrote:
I suspect you're not really using the version you think you are.
Add warn $DBI::VERSON to the code.
I
Yeah. Many thanks Jonathan!
Tim.
On Thu, Apr 12, 2001 at 01:47:03PM -0400, Jonathan Segal wrote:
Hi,
I had major linking problems building DBD::Oracle on our DEC platforms, which
after a while I diagnosed to a missing -L entry in the link path. I then
diagnosed the reason why this was
Upgrade to DBI 1.15.
Tim.
On Mon, Apr 16, 2001 at 11:40:11PM +0200, dLux wrote:
Hello Tim and DBI hackers,
I have started using dbish, because I am programming a device which
has very small storage, and dbish is smaller than the msql binary
(in a jffs2 filesystem).
I have
- Forwarded message from John West [EMAIL PROTECTED] -
Date: Tue, 17 Apr 2001 08:00:30 -0700 (PDT)
From: John West [EMAIL PROTECTED]
Subject: precompiled Oracle DBD?
To: [EMAIL PROTECTED]
Is it possible to get a precompiled NT Oracle.pm for
Oracle equivalent to ODBC 8.01.06.0? I can't
I'd like to get in touch with any DBI users in the Republic of Ireland.
Please send me an email.
Tim.
- Forwarded message from Yoel Steinmets - BH Photo Video [EMAIL PROTECTED]
-
From: Yoel Steinmets - BH Photo Video [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 18 Apr 2001 14:45:42 -0400
Subject: using perl with oracle 8.1.6
Priority: normal
Hi Tim
maybe you can help me with this
Some people have reported problems with DBI 1.15 + DBD::Oracle 1.06.
Please try using DBI 1.14 and see if that helps.
Please _do_ let me know if that helps.
Tim.
On Thu, Apr 19, 2001 at 02:09:52AM -0500, Hugh Riley wrote:
First of all, I am new to perl, so be gentle with me. Any assistance
On Thu, Apr 19, 2001 at 04:57:31PM +0300, Agamemnon Kaimakis wrote:
Mark,
I have tried that and it doesn't work in this case. It seems that the env vars
must be set before the loading of the perl interpreter (e.g. through a wrapper
script?).
Only applies to LD_LIBRARY_PATH.
Many httpd
On Fri, Apr 20, 2001 at 11:33:52AM +0200, [EMAIL PROTECTED] wrote:
table_info
ok 103
The stat preceding lstat() wasn't an lstat at blib/lib/DBD/ExampleP.pm line 130.
dubious
Thanks. Fixed for the next release.
not ok 75
Missing directories: .,..,lib,blib,t
Expecting directories
- Forwarded message from [EMAIL PROTECTED] -
From: [EMAIL PROTECTED] ()
X-eGroups-Return: [EMAIL PROTECTED]
Date: Thu, 19 Apr 2001 09:47:31 -
To: [EMAIL PROTECTED]
Subject: Installation Issues - DBI in Win 95
User-Agent: eGroups-EW/0.82
X-Originating-IP: 164.164.87.21
Dear Tim Bunce
On Thu, Apr 19, 2001 at 08:57:26AM -0400, Duncan, Mike wrote:
PS: I have contacted Tim Bunce about this issue, in hopes he can enlighten
me furthur.
I'll certainly be looking at it but as I'm away next week it may not get
sorted till the following week.
Tim.
- Forwarded message from Andy Brick [EMAIL PROTECTED] -
From: Andy Brick [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Subject: Further Oracle Character Set Issues
Date: Mon, 30 Apr 2001 22:42:05 +0100
In-Reply-To: [EMAIL PROTECTED]
Hi
I have my Perl script working fine on NT
On Sun, Apr 29, 2001 at 12:23:03PM +0200, Richard Limanowski wrote:
The following code introduced in v1.15 makes perl crash
when retrieving ref curosor with DBD::Oracle.
lines 773 ff
if (DBIc_TYPE(imp) == DBIt_ST) {
SV **Statement = hv_fetch((HV*)SvRV(h), Statement, 9, 0);
- Forwarded message from Bret Bailey [EMAIL PROTECTED] -
Date: Tue, 01 May 2001 16:36:37 -0700
From: Bret Bailey [EMAIL PROTECTED]
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: DBD::Oracle and International characters?
Hi there,
I am using DBI and DBD::Oracle for web
On Fri, May 04, 2001 at 01:59:05PM -0400, Ken Speich wrote:
Does a $sth-finish; close out a $dbh-prepare()?
For example, if I do the following:
$sql = select sysdate from dual;
$sth = $dbh-prepare($sql);
while(1) {
$sth-execute
(Do some stuff here)
$sth-finish
about to destroy or re-use the statement handle.
Basically use finish to remove resources . I hope this will help you .
Regards
Dan.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 2:42 PM
To: Ken Speich
Cc: [EMAIL PROTECTED
- Forwarded message from L RAMESH [EMAIL PROTECTED] -
Original-Received: from 204.68.23.39 by nwcst294
for [202.9.188.136] via web-mailer(34FM.0700.17C.01) on Tue
May 8 12:13:24 GMT 2001
PP-warning: Illegal Received field on preceding line
Date: 8
On Tue, May 08, 2001 at 07:16:37AM -0600, Sterin, Ilya wrote:
Thanks a lot, Neil. Finally a make sense answer. Thus, know I can see
why the script was not failing within eval (due to PrintError being on). It
is quoted in the docs and my fault for overlooking it. Definitelly when we
answer
On Tue, May 08, 2001 at 05:01:28PM +0300, LIBASOV IOANNIS wrote:
I'm realy sorry about that.
I received the reply seying that my message could not be delevered (Mailbox
is full or something like that) and resent the message once again.
FYI, those come from subscribers with broken email
On Tue, May 08, 2001 at 08:26:43AM -0600, Sterin, Ilya wrote:
Here are the quotes from the docs regarding PrintError
PrintError' (boolean, inherited)
This attribute can be used to force
errors to generate warnings (using `warn')
in addition to
- Forwarded message from Paul.Pslee [EMAIL PROTECTED] -
From: Paul.Pslee [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Please help
Date: Wed, 9 May 2001 12:35:15 +0800
X-SMTP-HELO: mail1.maxis.net.my
X-SMTP-MAIL-FROM: [EMAIL PROTECTED]
X-SMTP-RCPT-TO: [EMAIL PROTECTED]
On Tue, May 08, 2001 at 11:06:58AM -0600, Sterin, Ilya wrote:
In the docs shouldn't this be changed...
***
If `PrintError' is also on, then the
`PrintError' is done before the `RaiseError'
***
to
***
If `PrintError' is also on, then the
`PrintError'
- Forwarded message from Joe Zimmerlin [EMAIL PROTECTED] -
Date: Tue, 08 May 2001 14:02:15 -0400
From: Joe Zimmerlin [EMAIL PROTECTED]
Organization: Parabon Computation, Inc.
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: Oracle DBD
Sorry about that last email, I'm running Linux
Your perl installation is broken.
Tim.
On Wed, May 02, 2001 at 06:13:56PM -0400, Simon Yates wrote:
Help please!
I can execute perl Makefile.PL fine
when I run make, I get a bunch of errors.
So you could see what I was doing, I ran script. See file attached.
typescript
my system
On Wed, May 09, 2001 at 08:42:40AM -0600, Sterin, Ilya wrote:
Now as I read it a few times, I can make sense out of it. Just a long day
yersterday. Although it can be a little bit more clearly explained for
challenged people like myself:-)
I guess maybe reverse thinking...
***
If
On Thu, May 10, 2001 at 04:29:04PM -0700, Eric Riggers wrote:
Hi,
I'm trying to call a stored procedure that needs a record type paramater.
I'm unclear as to how to pass the record data. The record data is a hash; I
believe i need to pass in just the values of the hash, as a flattened list
Thanks. (I'd already fixed that one, but thanks anyway.)
Tim.
On Fri, May 11, 2001 at 03:18:18PM -0700, David Dyck wrote:
On Fri, 30 Mar 2001, Tim Bunce wrote:
It gives me great pleasure to announce the arrival of DBI 1.15:
When I installed this, I got the following warning during
The only thing the program lacks is an eval around the data_sources
method call to cleanly catch drivers that are 'installed' but not
functional.
Tim.
On Wed, May 16, 2001 at 11:16:11AM -0400, Curt Russell Crandall wrote:
Ignore that program... it almost NEVER works. I'm on a Solaris box,
On Wed, May 16, 2001 at 05:22:45PM +0100, Tim Bunce wrote:
I guess I could add an option to available_drivers() to have it hide
drivers that are 'installed' but fail to load.
D'oh. Forget that thinko. What it needs is an eval around the
data_sources method call.
Tim.
Tim.
On Wed, May 16
I guess I could add an option to available_drivers() to have it hide
drivers that are 'installed' but fail to load.
Tim.
On Wed, May 16, 2001 at 08:56:00AM -0500, Spohn, Albert F. wrote:
My initial install of DBI 1.15 bundle went without an apparent hitch. I
then attempted to run the
On Sat, Apr 21, 2001 at 12:14:09AM +0200, M.W. Koskamp wrote:
- Original Message -
From: Paul D. Smith [EMAIL PROTECTED]
To: M.W. Koskamp [EMAIL PROTECTED]
Cc: dbi-users [EMAIL PROTECTED]
Sent: Saturday, April 21, 2001 12:04 AM
Subject: Re: ISA inheritance vs. DBI?
This is
- Forwarded message from Timur Taluy [EMAIL PROTECTED] -
Date: Mon, 28 May 2001 21:40:48 -0700 (PDT)
From: Timur Taluy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Tamino PERL Module
Tim-
I just replied to a post of yours at Geocrawler.com, but found your email
anddress and decided
On Thu, May 31, 2001 at 01:44:37PM +0200, Bart Lateur wrote:
On Thu, 31 May 2001 19:29:12 +0800 (PHT), Orlando Andico wrote:
On Thu, 31 May 2001, [iso-8859-1] Hèctor Alòs i Font wrote:
..
Simply something as simple as :
$sth = $dbh-prepare (select FIELD from TABLE where
On Thu, May 31, 2001 at 03:49:33PM +0100, Llewellyn Jim wrote:
I was able to figure out more about what was going on there by running it
through the preprocessor only, and examining the output.
Thanks. I didn't have the energy to try to explain how to do that
and was kind'a hoping someone
Thanks. I'll fix it for the next release. Meanwhile try
... $attr ? sort %$attr : ();
Tim.
On Thu, May 31, 2001 at 04:17:09PM -0500, Mitch Helle-Morrissey wrote:
I think there might be a bug with the connect_cached() method in DBI. If
the elements in the attributes hashref are in a
On Fri, Jun 01, 2001 at 12:18:55PM +0200, [EMAIL PROTECTED] wrote:
Tim,
Is my assumption correct that either:
OCIStmtPrepare or OCIStmtExecute
should return an error of some sort ??
I'd expect OCIStmtExecute to return OCI_ERROR or OCI_SUCCESS_WITH_INFO.
But since the update says it
- Forwarded message from webmaster [EMAIL PROTECTED] -
From: webmaster [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Accent insensitive
Date: Fri, 1 Jun 2001 14:30:06 -0300
Hi, Tim. I need your help. But, first off all, dont mind about my english.
Tim, i am using DBI
On Tue, Jun 05, 2001 at 10:08:01AM -0400, John Peacock wrote:
Tim Bunce wrote:
FYI, There's an Oracle::OCI release cooking that'll probably also
prompt a minimal DBD::Oracle release at the same time.
When you release DBD::Oracle, please remember to fix the VMS link line
to use LnOCIc
You can ignore it.
Tim.
On Tue, Jun 05, 2001 at 01:42:25PM -0700, Big Mac wrote:
has anyone seen the following error while attempting
the DBD::Oracle install:
dbdimp.c: In function `pp_exec_rset':
dbdimp.c:926: warning: passing arg 1 of `Perl_newRV'
from incompatible pointer t
ype
- Forwarded message from Alexander Knack [EMAIL PROTECTED] -
Date: Wed, 6 Jun 2001 19:19:50 +0200
From: Alexander Knack [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Subject: DBD::Oracle: two-task internal error
User-Agent: Mutt/1.2.2i
In-Reply-To: [EMAIL PROTECTED]; from [EMAIL
On Wed, Jun 06, 2001 at 02:18:59PM -0300, Katja Sattler (EDS) wrote:
There is a lost fi at line 2670 in the Makefile (DB-Oracle-1.07).
I have noticed the same at the previous DBD-Oracle version (DB-Oracle-1.06)
Because DBD::Oracle is simply copying chunks of your Oracle makefiles.
What
On Fri, Jun 08, 2001 at 05:32:00PM +0900, Karen Ellrick wrote:
I tried downloading a little set of scripts for processing my HTTP access
log, and theoretically it works (the sample displayed on the web looks
great), but it doesn't work for me. This isn't DBI-related, but I'm not
subscribed
On Fri, Jun 08, 2001 at 06:03:04PM +0900, Karen Ellrick wrote:
On Fri, Jun 08, 2001 at 05:32:00PM +0900, Karen Ellrick wrote:
I tried downloading a little set of scripts for processing my
HTTP access
log, and theoretically it works (the sample displayed on the web looks
great), but
On Fri, Jun 08, 2001 at 12:24:33PM -0700, Kokarski, Anton wrote:
Greg,
Look around on mysql.com I've seen a mentioning of the utility that allows
you to port MySQL to oracle. I think it comes from Oracle.
And is a mostly hopeless marketing tick box gimmick.
I'm migrating from MySQL to
But for minimal app code change I'd suggest a using a PL/SQL trigger
that implements the auto increment functionality and saves the last
value into a per-session package variable.
If you, or anyone, does the latter then I'd be very interested in
having a copy as I'll need to do
- Forwarded message from Kim Leung [EMAIL PROTECTED] -
Date: Thu, 14 Jun 2001 19:35:28 +1000 (EST)
From: Kim Leung [EMAIL PROTECTED]
Subject: Question: Oracle 8.1.7 with Perl
To: [EMAIL PROTECTED]
Hi Tim,
I was looking at dbi-users and your name keeps
reappearing with answers so I
- Forwarded message from Daniel Czajko [EMAIL PROTECTED] -
From: Daniel Czajko [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: DBperl extension
Date: Fri, 15 Jun 2001 15:54:57 -0400
Could you point me in the direction where I can download the Oracle
extension to
- Forwarded message from liu_wen [EMAIL PROTECTED] -
From: liu_wen [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: about tpmonitor
Date: Mon, 18 Jun 2001 09:37:02 +0800
Hi,Tim Bunce
I know u from
http://www.grin.net/~mirthles/pile/database_connection_pooling.html
to go
is the support for user names and passwords with the data_sources
method. If you are interested in that, please contact Tim Bunce.
..
Thanks, Jochen
== end quote 1 ==
== quote 2 ==
Date: Thu, 10 Feb 2000 10:11:23 +
From: Tim Bunce [EMAIL PROTECTED
- Forwarded message from Andrej Harsani [EMAIL PROTECTED] -
From: Andrej Harsani [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Oracle reconnect
Date: Mon, 25 Jun 2001 16:57:46 +0200
Hello,
I have problem with reconnect to Oracle.
1) db running
2) script running
3) i
- Forwarded message from Yitong Phou [EMAIL PROTECTED] -
From: Yitong Phou [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: Perl Error!
Date: Mon, 25 Jun 2001 12:05:56 -0700
Hello Tim,
I am new to Perl. However, after I have worked on it for about 1
week, I
On Mon, Jun 25, 2001 at 08:32:42PM -0700, Jonathan Leffler wrote:
Tim Bunce wrote:
Changes in DBI 1.16,30th May 2001
Added note to data_sources() method docs that some drivers may
require a connected database handle to be supplied as an attribute.
With all due respect, Tim
On Tue, Jun 26, 2001 at 10:50:31PM +0800, Orlando Andico wrote:
This may be true, but as I understand it (vaguely), in Oracle, when you do
the execute it (by default) runs the query through and fetches all the
rows. Although this behavior can be changed using an optimizer hint
(return rows
On Tue, Jun 26, 2001 at 11:48:34PM +0800, Orlando Andico wrote:
and definitely, the execute part took longest.. if what you're saying is
true, execute would return immediately and let me fetch records at will.
That does NOT happen. execute takes forever, THEN i can fetch records.
That's
On Tue, Jun 26, 2001 at 09:09:36AM -0700, Michael Peppler wrote:
$t0 = [gettimeofday];
$sth = $dbh-prepare (SELECT * FROM TEN_MILLION_ROW_TABLE);
print [gettimeofday] - $t0;
$t0 = [gettimeofday];
$sth-execute;
# and so on..
and definitely, the execute part took
Add code into your PL/SQL block that 'unpacks' the ADT and returns the
field(s) within it as simple string types.
Tim.
On Tue, Jun 26, 2001 at 03:14:07PM -0700, Jeff Holt wrote:
I've searched the DBI mailing list archive, the perldoc, and various example sites
and have found
no way to
On Tue, Jun 19, 2001 at 01:24:36PM +0200, Axel Rose wrote:
Hello Tim,
please delete from the DBD::Oralce 1.07 README the URL to
http://www.wmd.de/
I know for sure that the company wmd no longer exists.
Thanks.
I have a minor compilation problem and would like to search
first in the
function should be used instead of 'alter user..' to
accomplish password changes. I'm hoping someone has figured out how to do
this using Perl.
I saw the following archive item where Tim Bunce talks about a possible
approach to incorporate this functionality into DBI but I don't know
How many times was type_info() being called?
Tim.
On Mon, Jul 02, 2001 at 01:19:10PM -0500, Dean Kopesky wrote:
Hi!
While testing an application that generates SQL based on data extracted
from a database, I noticed that almost 80% of the runtime was being
consumed by DBI::db::quote(). A
- Forwarded message from Mahdi A. Sbeih [EMAIL PROTECTED] -
From: Mahdi A. Sbeih [EMAIL PROTECTED]
To: Tim.Bunce [EMAIL PROTECTED]
Subject: Just direct me where to go
Date: Wed, 4 Jul 2001 16:42:55 +0200
Hi Tim,
Our company is developing allot of Perl script using DBI and
1 - 100 of 2336 matches
Mail list logo