How to Retrieve Table Name from Statement Handle

I am creating a simple tool that will query one table and retrieve the data. Then this tool will turn the data into insert statements. I was wondering if there was a way to retrieve the table name from the statement handle? Similar to print SQL statement contains $sth-{NUM_OF_FIELDS}

Fw: How to Retrieve Table Name from Statement Handle

schema.zord Joseph Lamb - Forwarded Message From: Alexander Foken [EMAIL PROTECTED] To: Lamb Joseph [EMAIL PROTECTED] Cc: dbi-users@perl.org Sent: Wednesday, May 7, 2008 11:18:53 AM Subject: Re: How to Retrieve Table Name from Statement Handle Hmmm, and what do you think $sth-{TABLENAME

Fw: How to Retrieve Table Name from Statement Handle

I will have to break apart the SQL statement with a regex and store it that way. Thanks for the input. Joseph Lamb - Forwarded Message From: Jonathan Leffler [EMAIL PROTECTED] To: Lamb Joseph [EMAIL PROTECTED] Cc: dbi-users@perl.org Sent: Wednesday, May 7, 2008 12:22:06 PM Subject

Re: Issues in Installing DBD-Oracle module.

Nirmala, Did you read and try the readme notes? http://cpan.uwinnipeg.ca/htdocs/DBD-Oracle/README.html What questions do you have about this processes? Joseph Lamb - Original Message From: Nirmaladevi Venkataraman [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Thursday, February

Re: Issues in Installing DBD-Oracle module.

: Lamb Joseph [EMAIL PROTECTED] To: Nirmaladevi Venkataraman [EMAIL PROTECTED]; dbi-users@perl.org Sent: Friday, February 22, 2008 12:45:18 PM Subject: Re: Issues in Installing DBD-Oracle module. Nirmala, Did you read and try the readme notes? http://cpan.uwinnipeg.ca/htdocs/DBD-Oracle

Re: Using to_dsinterval or INTERVAL with placeholder

Mike, Here are some of the things that I would do. 1. Set the NLS Date Format Example I pulled from the internet # set Oracle NLS date format if ( $optctl{dateformat} ) { $dbh-do(qq{alter session set nls_date_format = '$optctl{dateformat}'} ); } 2. Using bind_param set all your

Re: Please Help !!! Unable to install DBD-Oracle ( I am using perl 5.6 on solaris 8)

Please try: ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd --- [EMAIL PROTECTED] wrote: Hi there, I am trying to install DBD-Oracle with PPM Its giving me the error:- Error installing package

Updating Oracle Tables Using bind_param

I was wondering, why I can insert data with no problems into my Oracle DB without bind_param. However when I go to update the table it seems I must import sql_types and use bind_param. Especially, when I use char datatypes. Why? Is there an article I can read? Thank you, = Joseph Lamb

Faster Inserting Code

I would like to know how to insert faster using SQLite. use strict; use dbi; use Date::Manip; use Diagnostics; #Connect to the database my $dbh = DBI-connect(dbi:SQLite:data.dbl) || die Cannot connect: $DBI::errstr; #MSSQL Server my $kewilldb = 'LV_KWARCHIVE'; my $dbh_kewill = DBI-connect(

RE: Faster Inserting Code

are your expectations? - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Lamb Joseph [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 2:05 PM To: [EMAIL PROTECTED] Subject: Faster Inserting Code I would like to know how

RE: Faster Inserting Code

? Can you use fetch instead of fetchall_arrayref? I'd take out the print statements and test there, too... Jeff -Original Message- From: Lamb Joseph [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 4:19 PM To: [EMAIL PROTECTED] Subject: RE: Faster Inserting

Installing DBI::Profile on VMS

I need to manually install DBI::Profile on a VMS server. Will profile work on VMS(v5.6.1 built for VMS_AXP)? Can I copy the following files to VMS from my WIN32 box to get DBI::Profile to work? profile.pm profiledumper.pm profiledata.pm Are = Joseph Lamb