Tom,
To answer this correctly we need to know which database you're using.
If you are using Oracle, remember that you can use pl/sql to do any number
of
operations within one execute(). For example you could call nextval on a
sequence object to derive a primary key, enter a record in a table us
> What I need to know at the moment (simplified syntax, without all Perl
subtilities) :
>INSERT INTO Country (Name, Continent) VALUES ('France', 'Europe');
>SELECT Country.Id FROM Country WHERE Name='France' AND Continent='Europe';
>INSERT INTO City (Name, CountryId) VALUES ('Paris', Country.Id)
On Thu 18 Jul 2002 16:46, Tim Bunce <[EMAIL PROTECTED]> wrote:
> file: $CPAN/authors/id/T/TI/TIMB/DBI-1.30.tar.gz
> size: 257016 bytes
>md5: 30e6b539fb36da93c862c7c7df0f3bf8
>
> =head2 Changes in DBI 1.30,18th July 2002
>
> Fixed problems with selectrow_array, selectrow_arrayref,
Try it with DBI 1.30
Tim.
On Thu, Jul 18, 2002 at 02:06:30PM -0400, Qingjuan Gu wrote:
> Hi,
>
> I am install DBI-1.29 to connetect mysql database and perl5.6.1 on Tru64.
>
> I have installed :
> Data-Dumper-2.101.tar.gz
> DBI-1.29.tar.gz
> Data-ShowTable-3.3.tar.gz
> Msql-Mysql-module
HI all:
When I am trying to connect to oracle by
my $dbh = DBI->connect("dbi:Oracle:test", "scott", "tiger");, I get the
following error
DBI->connect(gldba) failed: ERROR OCIEnvInit at db_connect.plx line 10
What does this mean? Can anybody help me out.
Thanx
Viji
Title: Seek a suitable modules for Oracle Database
Dear Sir,
I want to connect Oracle database with perl program in Linux Platform.
Should I install this modules (DBD::Oracle-1.12.tar.gz) and DBI.
Is it work...
Regards
Lstar
Hi!
From DBI version 1.19, there is a function that using the database handler
and the name of the table, returns the primary key. You can check the sintax
in the documentation of DBI or at
http://www.akadia.com/dbi/DBI_Talk5_2001/sld074.htm . However, I have tried
to use this call with an A