On 2008-05-05 10:46:05 -0700, pgodfrin wrote:
My install of Oracle, for reasons unknown to me, had this file set to
rwxr-x--- which doesn't work for 'others'.
In recent versions of Oracle, by default the programs and libraries
installed with a server installation are only usable by the DBA
Thanks Martin and Tim you pointed me in the right direction and
DBD::ODBC now works on my Mac OS X Leopard machine.
For anyone having trouble getting it to work, this is what I did.
Rebuild DBI v1.604 - I did this with a cpan force install
export LD_LIBRARY_PATH=/usr/local/iODBC/lib
cd
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}
Hmmm, and what do you think $sth-{TABLENAME} should contain after
executing the following SQL?
SELECT t1.foo,t2.bar FROM narf t1, zord t2 WHERE t1.ikes=t2.blurb
Alexander
On 07.05.2008 19:51, Lamb Joseph wrote:
I am creating a simple tool that will query one table and retrieve the data.
On Wed, May 7, 2008 at 10:51 AM, Lamb Joseph [EMAIL PROTECTED] wrote:
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
To answer you question, for an Oracle environment I would like
$sth-{TABLENAME} to contain a list.
my $tablename = $sth-{TABLENAME} -[0] = First table
$tablename $sth-{TABLENAME} -[1] = Second table
The $tablename value will be schema.tablename format.
For example:
schema.narf
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:
On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph [EMAIL PROTECTED] wrote:
To answer you question, for an Oracle environment I would like
$sth-{TABLENAME} to contain a list.
my $tablename = $sth-{TABLENAME} -[0] = First table
$tablename $sth-{TABLENAME} -[1] = Second table
The $tablename
You may be able to use the explain plan functionality in Oracle to
obtain the tables participating in a SELECT statement.
Steve
On Wed, 2008-05-07 at 12:48 -0700, Jonathan Leffler wrote:
On Wed, May 7, 2008 at 12:37 PM, Lamb Joseph [EMAIL PROTECTED] wrote:
To answer you question, for an