Rohan,
I do have a patch for DBD::Oracle 1.12 that allows for passing PL/SQL
Tables ( OCI Collection Types ) to/from PL/SQL. However, for the project
I initially developed the patch for, it turned out to be easier to use
straight C/OCI, so I must say the patch hasn't fully tested or used
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.21.tar.gz
size: 208384 bytes
md5: c781eee2559de5e4a72e28a8120cb1d9
Changes in DBI 1.21,7th February 2002
The minimum supported perl version is now 5.005_03.
Fixed DBD::Proxy support for AutoCommit thanks to Jochen Wiedmann.
Fixed DBI::Pr
The uploaded file
DBI-1.21.tar.gz
has entered CPAN as
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.21.tar.gz
size: 208384 bytes
md5: c781eee2559de5e4a72e28a8120cb1d9
No action is required on your part
Request entered by: TIMB (Tim Bunce)
Request entered on: Thu, 07 Feb 2002 03:28:40 GMT
R
I'm pleased to announce the availability of
DBD::Chart 0.60, a Perl DBI driver abstraction
for rendering charts and graphs using a simple
SQL syntax.
Release 0.60 includes the following updates:
- support for histograms (sideways barcharts),
both 2-D and 3-D, and 3 axis
- support for tempora
Here's a cheat.
1) create, using MS Access, and EMPTY MDB file, no tables, nothing.
2) to create the db on the fly, then copy that file to your file when you
need to...
3) don't use a pre-configured DSN, just use the dsn-less approach.
Example (using MS Access):
my $DSN = 'driver=Micro
I wasn't using $hash_ref but I am using it now.It provides column name as
key.
Thanks !!!
Jie
"Kokarski, Anton" wrote:
> if you are using method $hash_ref = $sth->fetchrow_hashref; then it should
> be easy
>
> Anton
>
> -Original Message-
> From: jie zhang [mailto:[EMAIL PROTECTED]
Please keep this on the list; I have added dbi-users to my response.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he ea
On Wed, 6 Feb 2002, Tim Bunce wrote:
> How does this sound:
>
> =item C (code ref, inherited) I
>
> This attribute can be used to provide your own alternative behaviour
> in case of errors. If set to a reference to a subroutine then that
> subroutine is called when an error is det
Until your execute() or do() the statement hasn't occurred yet, so there's
nothing to commit or rollback.
Each time you commit or rollback, a new transaction starts.
Transactions are session specific, so the transactions in two open database
handles in the same program are independent of each ot
Does anybody know how Oracle8i handles transactions from DML statements
passed from a DBI database connection?
Do the dbh->commit() and dbh->rollback() statements commit or rollback
all DML instructions issued while the connection is open, or just those
which get passed by sth->do() or sth->exec
Steve,
My experience is that I've always needed the db2connect installation.
The Perl DBI::DB2 doesnt work right without it. I learned this the hard way
recently with solaris and db2 on Windows NT.
-Original Message-
From: Steve Sapovits [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Fe
On Wed, Feb 06, 2002 at 12:26:23PM -, Rohan Holt wrote:
> I would like to use DBI & DBD::Oracle to call a third party (proprietry)
> stored proc API which happens to use PL/SQL tables as out parameters in some
> cases.
>
> Problem:
> Having scanned many of the questions & answers relating to
I think I asked this way back, but I never followed up.
We have a DB2 database running on an AS/400. I'd like to
access that from Solaris 2.7 using Perl/DBI. I have DBI
and Oracle::DBD set up there already.
What's needed as far as a DB2 client goes? Our Java guys
got a free DB2 JDBC driver
Hi,
I have a simple question, but I can't find the answer anywhere.
I'm trying to update a date field in a .dbf file with DBD::XBase, but I
can't figure out what format DBD::XBase wants the date in, and the pod
doesn't mention it.
Would it be possible to use something like:
$sth->bind_para
- Original Message -
From: "BAO RuiXian" <[EMAIL PROTECTED]>
To: "Michael A Chase" <[EMAIL PROTECTED]>
Cc: "ariel mastracchio" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 12:03
Subject: Re: Problems DBI/DBD::Oracle/Perl..
> Michael A Chase wrote:
>
> > I s
Hi group,
I have a client who is asking for all of their data to be encrypted.
Is this possible?
I am assuming that they want communication between server and client to be secure.
Also, if I was to encrypt the data myself and then store the data in, say mySql, doing
a subsequent query wouldn'
Can somebody help me solve this problem?
Thanks,
David
Error:
DBD::JDBC::st fetchall_arrayref failed: Data truncation
DBI handle cleared whilst still active.
dbih_clearcom (h 0x103a0334, com 0x1048e138):
FLAGS 0x111: COMSET Warn PrintError
TYPE 3
PARENT DBI::db=HASH(0x10
Hello, Mac,
Michael A Chase wrote:
> I said, a signal handler in the _child_ process. If you have opened the
> database handles in the children (as you should), catching the
Sorry for interuption, would you tell more about why the database handles should
be openned in the children. I want to k
If you've updated DBI, you should re-build your DBDs as well. It would be a
good time to update them.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a da
Whoops! Misspoke there the first time...
I asked "Is it possible without using the ODBC administrator?"
I meant, is it possible to create the databases in perl instead of first creating them
in Access?
Glen
Have you switched the databases? Possibly upgrade the DBD::Oracle as well.
Ilya
-Original Message-
From: Robert Bond
To: [EMAIL PROTECTED]
Sent: 2/6/02 11:40 AM
Subject: Help with DBI <***
Hi -
I've been trying to upgrade my version of DBI. My database is Oracle
8.1.7. When I run t
Hi -
I've been trying to upgrade my version of DBI. My database is Oracle
8.1.7. When I run the test script shown below I get the following error
message:
Error Message:
*
DBI->connect(nhup.mccoy) failed: (UNKNOWN OCI STATUS 1804) OCIInitialize.
Check ORACLE_HOME and N
Alright, stupid newbie question - how do I (or can I) create a Microsoft Access
database anew with perl and the DBI?
Situation: I have a number of working perl apps that are all built with flat file
tables (for ease of use, since the converted-from-COBOL !!! source data was very poor
and I ha
It depends on how granular your extract is. Any action in progress when the
database goes down will have to restart from its beginning. Discontinuing
is sort of automatic if there is no database available to extract from.
You will have to
1. trap the error caused by the database shutting dow
Hi,
Thanks to everyone for all their help and suggestions.
I haven't had time in the last 24 hours or so to follow any of these up, but
will pick things up again tomorrow.
I just need to find a development machine around here with the right version
of VC installed, or work out the firewall issues.
Hello, I need your help!
I've got the following massage :
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so
'
for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:
libclntsh.so.1.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.
Hi,
I am using DBI 1.14 and DBD::Oracle 1.06.
Our database shuts down nightly for backup. However, my script maybe still
running and extracting data. (It is extracting the entire database).
Is there a way to discontinue extracting when the database is offline and
continue when it is back up?
It works well with bind_param...i made a typo :-)
Thank you very much.
Emmanuel
"Jeff Urlwin" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
> I'd suggest, given that ActiveState is behind and I'm patching like mad
> lately, that you use bind parameters to work around it. I
As you pointed to me, i used placeholders and did :
$sth = $dbh->prepare($sql) or die $dbh->errstr;
$sth->bind_param(1, $rec->{majdate}, { TYPE => SQL_TIMESTAMP });
$sth -> execute() or die $dbh->errstr;
this problem occurs now :
Can't bind non-scalar value (currently) at
No private emails please. I have included dbi-users in this response.
If you have not forked, you don't have a child process. If you have forked,
the child is _not_ the same as the parent. The whole point of creating
children is to create _separate_ processes.
SIGCHLD is used to notify a pare
On Wed, Feb 06, 2002 at 12:47:43PM +0100, Henrik Tougaard wrote:
> > > To sum it up: we do need a way of catching DBI errors and turning
> > > them into something else.
> [snip]
> >
> > And now you have it...
> >
> > > Something with a better interface would be nice. It would probably
> > > need
On Wed, 2002-02-06 at 03:37, Tim Bunce wrote:
> Hopefully that'll enable what you want (and more :)
This will be a very welcome addition, IMO, Tim. Great idea!
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED]
I would like to use DBI & DBD::Oracle to call a third party (proprietry)
stored proc API which happens to use PL/SQL tables as out parameters in some
cases.
Problem:
Having scanned many of the questions & answers relating to stored procs in
this list it seems that this is not possible. The closes
I want to set the AutoCommit property when opening my database
connection on a SQL server 7 on the same W2000 box.
I'm using ActiveState Perl 5.6.1.
I've tried the following:
my $dbh = DBI->connect('DBI:ADO:absolut','sa','',{ AutoCommit => 0 })
or die "Couldn't connect to dat
> > To sum it up: we do need a way of catching DBI errors and turning
> > them into something else.
[snip]
>
> And now you have it...
>
> > Something with a better interface would be nice. It would probably
> > need to differ between $dbh errors and $sth erros (and $drh errors
> > of course) as
On Wed, Feb 06, 2002 at 09:14:19AM +0100, Henrik Tougaard wrote:
> > Don't be surprised if you haven't heard of the Handlers attribute,
> > it's not documented. And don't bother finding out about it because
> > it's probably going away.
> >
> > But I think I have mentioned it a couple of times a
Hi Ilya,
err...I think I'm right in saying you don't actually
need Apache::DBI for using DBI with mod_perl. It just
makes a persistent database connection, so you don't
re-connect and disconnect from your database every
time the program runs.
regards
Henry
--- "Sterin, Ilya" <[EMAIL PROTECTED
Hi Mark
I don't know if you've managed to get this to work yet, but I successfully use
PPM behind a firewall.
Basically (and if you read the docs it does kind of explain this) you need to
set some environment variables before you run PPM.
If you have a pssive proxy (ie you don't use a username
38 matches
Mail list logo
