RE: how to get datatype of columns of a table in perl script

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:Vamsi_Doddapaneni@xxxxxxxxxx]
Sent: Thursday, April 14, 2005 8:09 AM
To: dbi-users@xxxxxxxx
Subject: how to get datatype of columns of a table in perl script
Importance: High


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 what is the datatype of columns , since we need to use quotes for
varchar,date etc.....



Could anybody help me out to find an approach .



Thanks in advance





Regards

Vamsi

**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • RE: Réf. : RE: connect to oracle database as sysdba form windows
    ... connect to oracle database as sysdba form windows ... it and all copies from your system and notify the sender immediately by return e-mail. ... The sender does not accept liability for any errors or omissions which arise as a result. ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • Re: Pain clinic shut down and now the issues come to the surface
    ... This e-mail may contain confidential and/or privileged information. ... error) please notify the sender immediately and destroy this e-mail. ... disclosure or distribution of the material in ...
    (alt.support.chronic-pain)
  • RE: VNC HowTo or docs
    ... Matthew Polashek ... If you were not an intended recipient, ... please notify the sender and delete all copies. ...
    (Fedora)
  • RE: sth->do()
    ... If you are not the intended recipient, ... Please notify the sender of the delivery ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)
  • RE: (Fwd) DBD::Oracle
    ... What compiler was used to compile the Perl distributed with Solaris 9? ... Senior DBA ... If the reader of this message is not the intended recipient, ... distribution or copying of this communication is strictly prohibited. ...
    (perl.dbi.users)