Hi there
I'm trying to find a mechanism for dealing with large BLOBs, where large is
a value greater than the memory available to the process.
This is used in a CGI application.
I've been reading through and docs and source to DBI and DBD::Oracle. I've
checked pretty much every resource I can fi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, Sep 20, 2001 at 08:58:54PM +0100, Alan Evetts wrote:
> I have been unable to find anything on the sites or in the README's about
> if/when Oracle 9 support was going to be added into the DBI Module.
It's already there. The latest version of
We're running DBI 1.20 and DBD::Oracle 1.12 with Oracle9i (9.0.1 on SuSE
Linux 7.2) in a fairly large production environment right now - things
seem to be holding together pretty well. We found we needed DBD::Oracle
1.12 in order to get it to compile with the 9i client environment.
Found a bug in
Hi,
I use PerlScript (ActiveX compliant engine) in ASP
pages and connect to MSSQL using DBI.
All is well for first HTTP request. But for all subsequent
requests, I get empty response. If I "touch" the .asp file
(ie change the time stamp), it works again, but for only one request.
This problem i
Don't know about support for Oracle 9 - but while you're asking - does
anyone know about support for Oracle 8? If so can you point me to a URL
since none appears to explicitly mention Oracle 8 support and apparently the
DBI Module I'm using is outdated.
Thanks!
-Original Message-
From:
On Thu, Sep 20, 2001 at 01:35:36PM -0400, Steven Vetzal wrote:
> Hi Folks,
>
> I've run across an issue in our environment regarding concurrent
> read/write access of a LOB record. I have duplicated it on Oracle 9i /
> 8i (8.1.5 and 8.1.7), DBI 1.15/1.18, DBD::Oracle 1.06/1.07... a variety
> of e
- Forwarded message from Alan Evetts <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Thu, 20 Sep 2001 10:13:31 -0700
From: Alan Evetts <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: oracle 9 support for dbi
User-Agent: Mutt/1.2.5i
Dear Tim,
I have been unable to find any
Since today I have been getting the following error message.
Software error:
Can't load
'/home/test/public_html/cgi-bin/perlmod//sun4-solaris/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: /opt/exptools/bin/perl: fatal: relocation
error: file
/home/test/public_html/cgi-bin/perlmod//
Hi Folks,
I've run across an issue in our environment regarding concurrent
read/write access of a LOB record. I have duplicated it on Oracle 9i /
8i (8.1.5 and 8.1.7), DBI 1.15/1.18, DBD::Oracle 1.06/1.07... a variety
of environments.
I believe it has to do with what Tim Bunce documents as a two
It's supposed to throw an error. I am not sure of why it does not, since
RaiseError is on. Anyone???
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: Sterin, Ilya
Cc: '''[EMAIL PROTECTED] ' ' '
Sent: 9/20/01 10:03 AM
Subject: Re: DBI use with DBD:Oracle module
It works !!!
It works
It was just a problem with a column which was misnamed in the select query
(DBI returned no error for this)
Sorry. And thanks again for all your advises.
Bye for now.
"Sterin, Ilya" wrote:
> Quick question, are you sure you are connecting to the right
> > > my $sth= $dbh->prepare($query);
> > > $sth->execute();
> > >
> > > my $rawRef;
> > >
> > > while(($rawRef= $sth->fetchrow_arrayref())) {
> > > push(@choices, $rawRef->[0]);
> > > }
It probably won't help, but you could replace this whole
section with:
my $choices = $dbh->selectcol_array
There is only one instance of Oracle on the target machine, so no mistake
is
possible.
I'm trying to connect different ways.
Thanks a lot Ilya.
"Sterin, Ilya" wrote:
> Quick question, are you sure you are connecting to the right db. The
reason
> I ask, is if you have both production and dev
Quick question, are you sure you are connecting to the right db. The reason
I ask, is if you have both production and development environments, which I
have here, you might make a mistake and connect to a different db wher that
table is empty, I've done that plenty of times before.
Seems from th
True, Bart. I thought about that though just gave that as another option, I
agree that was senseless:-) Now looking through the trace file, looks like
everything is running fine, just nothing is returned?
Ilya
-Original Message-
From: Bart Lateur
To: [EMAIL PROTECTED]
Sent: 9/20/01 8:4
Hi Ilya
I tried the changes you recommanded, and the result is still the same : i
have
no exception (die) thrown, the database handler is defined,
but the query doesn't return anything (I tried under sqlplus, and the given
table has records).
Here is, as an attachment, the DBI log file.
Please
On Thu, 20 Sep 2001 08:12:38 -0600, Sterin, Ilya wrote:
>Then put || die $DBI::errstr at the end of the connect call or call connect
>like this...
>
>my $dbh= DBI->connect("dbi:Oracle:host=;sid=", $user,
>$password, {RaiseError => 1});
>
>Just in case the call to connect fails.
In that case it w
On Wed, Sep 19, 2001 at 05:49:26PM -0700, Jonathan Leffler wrote:
> On Wed, 19 Sep 2001, Tim Bunce wrote:
> >On Wed, Sep 19, 2001 at 11:24:39AM -0500, James Maes wrote:
> >> On Wednesday 19 September 2001 11:16 am, James Maes wrote:
> >> > On Wednesday 19 September 2001 10:51 am, Tim Bunce wrote:
First try to run this query in sqlplus to see if it's suppost to return
results, make sure to login with the same account used in the connect().
Then put || die $DBI::errstr at the end of the connect call or call connect
like this...
my $dbh= DBI->connect("dbi:Oracle:host=;sid=", $user,
$passwor
Here is the code I used for the connection to the database :
my $dbh= DBI->connect("dbi:Oracle:host=;sid=", $user,
$password);
$dbh->{AutoCommit} = 0;
$dbh->{RaiseError} = 1;
And the code of the select statement :
my $query= "select type from productTypes";
my $sth= $dbh->prepare($query);
$s
Yes, I think everyone on this list has experience:-)
You need to give us a sample code as well as a little more info, before we
can help, since as of right now, no one knows what you are doing wrong.
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/20/01 6:3
Well what have you tried that's not working as expected or as you read in
the docs (perldoc DBI && DBD::Oracle)? You have read the docs, I am
assuming?
Ilya
-Original Message-
From: MUHAMMAD TAQI RIAZ
To: [EMAIL PROTECTED]
Sent: 9/20/01 5:17 AM
Subject: help me out plz!
hello all i wo
What error message did you get ??
Where is your coding at ??
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 7:39 AM
To: [EMAIL PROTECTED]
Subject: DBI use with DBD:Oracle module
Hi.
I'm trying to use DBI with the DBD::Oracle
Hi.
I'm trying to use DBI with the DBD::Oracle driver.
The connection seems to work, but even a simple query like "select
col_name from table" doesn't return any record in the fetch.
Does anyone have experienced the use of DBI with Oracle ???
Thanks a lot
Tewfik, a simple developper.
(See at
On Thu, 20 Sep 2001 04:17:37 -0700 (PDT), MUHAMMAD TAQI RIAZ wrote:
>hello all i work on Windows plate form n i wanna interact with database
>offline as well as online through perl script can any body help me how
>to do it ? remember off line i wanna interact with Oracle and online to
>any feasib
hello all i work on Windows plate form n i wanna interact with database offline as
well as online through perl script can any body help me how to do it ? remember off
line i wanna interact with Oracle and online to any feasible data base.
plz tell me how to do it .with regards
taqi
---
hi all i have some experience of working in CGI using perl i make shopping cart which
utilizez a text file now i want my cart to update using database can any body guide me
how to manage online database . and which one is best for web.plz guide me
all contributions are appreciated
thanks in
Hello one and all
I'm trying to install the following modules on Solaris 8 and have endless
problems
with SDK complations.
* Mozilla::LDAP::Conn
* Mozilla::LDAP::Utils
* Mozilla::LDAP::Entry
* MIME::Base64
* SHA
* CGI
Has anybody come across the problem insta
Hi.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 5:17 PM
Subject: dbi excel config...
(snip)
> What is IO/Scalar.pm ? Is that something still needing to be loaded ?
Yes.
You need IO::Scalar included
excel-prob.txt:perl excel module config problems:
D:\>type excel-prob.txt
perl excel module config problems:
unzipped DBD-Excel-0.05 bundle. It doesn't install with "make install" or with "ppm
install DBD-Excel" or with "perl Makefile.PL".
What is IO/Scalar.pm ? Is that something still needi
30 matches
Mail list logo
