-
From: Vamsi_Doddapaneni [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 7:27 AM
To: Thutika, Srinivas (ODC - Satyam)
Cc: dbi-users@perl.org
Subject: RE: how to get datatype of columns of a table in perl script
Importance: High
Hi ,
Thanks for replying.
My problem is, the perl script
msi_Doddapaneni [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 7:27 AM
To: Thutika, Srinivas (ODC - Satyam)
Cc: dbi-users@perl.org
Subject: RE: how to get datatype of columns of a table in perl script
Importance: High
Hi ,
Thanks for replying.
My problem is, the perl script successfully
riginal Message-
From: Vamsi_Doddapaneni [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 8:27 AM
To: Thutika, Srinivas (ODC - Satyam)
Cc: dbi-users@perl.org
Subject: RE: how to get datatype of columns of a table in perl script
Importance: High
Hi ,
Thanks for replying.
My pr
for insertion.
Hope you got my problem
Thanks & Regards
Vamsi
-Original Message-
From: Thutika, Srinivas (ODC - Satyam) [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 7:48 PM
To: Vamsi_Doddapaneni
Subject: RE: how to get datatype of columns of a table in perl script
Hi ,
Assuming you have a group of rcds called tth;
$nbrFlds = $tth->{NUM_OF_FIELDS}; ### returns the # of fields
for ($ixx=0; $ixx < $nbrFlds ; $ixx++) {
$xname = $tth->{NAME}->[$ixx]; ### returns the field name
}
Caveat,
This might be dependent on the drivers you use;
Quoting Vamsi_Doddapaneni <[EMAIL PROTECTED]>:
> I am new to perl just (1 1/2 month experience.). I am developing perl script
> which connects to oracle database and selects rows from a (x) table and then
> inserts them into its corresponding table in db2. So, while inserting i need
> to find what
On 4/14/05, Darren Duncan <[EMAIL PROTECTED]> wrote:
> At 7:38 PM +0530 4/14/05, Vamsi_Doddapaneni wrote:
> >Hi all
> >I am new to perl just (1 1/2 month experience.). I am developing perl script
> >which connects to oracle database and selects rows from a (x) table and then
>
> A simple generic s
Have you looked at type_info_all()? It may provide what you need, but I
recommend using bind parameters instead.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Vamsi_Doddapaneni [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 8:09 AM
To: db
At 7:38 PM +0530 4/14/05, Vamsi_Doddapaneni wrote:
Hi all
I am new to perl just (1 1/2 month experience.). I am developing perl script
which connects to oracle database and selects rows from a (x) table and then
inserts them into its corresponding table in db2. So, while inserting i need
to find wh
