Re: Ref:-- How to transfer DBI/DBD binary.

[Richard T Malafa]

Is this assuming the hardware is identical on both machines and the Oracle 
Database (not the clients alone) are identical? 
What about the Perl??? Is that also have to be identicial in every 
respect???
Has this actually been tried
Thank You
Rich


.· '·..· '·. º .· '·. .· '·. ·. .· '·. º
“Anything that doesn’t eat you today is saving you for tomorrow.”



Computer Sciences Corporation 
Registered Office: 2100 East Grand Avenue, El Segundo California 90245, 
USA
Registered in USA No: C-489-59


This is a PRIVATE message. If you are not the intended recipient, please 
delete without copying and kindly advise us by e-mail of the mistake in 
delivery. 
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to 
any order or other contract unless pursuant to explicit written agreement 
or government initiative expressly permitting the use of e-mail for such 
purpose.





John D Groenveld [EMAIL PROTECTED] 
10/25/2007 08:38 PM

To
MEHTA, HARESH, ATTSI [EMAIL PROTECTED]
cc
dbi-users@perl.org
Subject
Re: Ref:-- How to transfer DBI/DBD binary.






In message 
[EMAIL PROTECTED]
, MEHTA, HARESH, ATTSI writes:
I have installed DBI/DBD using gcc in our development
solaris server. I want to install on production server but without using
gcc or cc(compiler), Is there any way to transfer binary of DBI/DBD to
production server??

You should be able to package up or tar your Perl build and
extract it on your production server.

Don't alter your Perl basedir and make certain your Oracle client
libraries are in the same ORACLE_HOME on both systems.

John
[EMAIL PROTECTED]

Re: Ref:-- How to transfer DBI/DBD binary.

[John D Groenveld]

In message [EMAIL PROTECTED],
 Richard T Malafa writes:
 Is this assuming the hardware is identical on both machines and the
 Oracle
 Database (not the clients alone) are identical?

Yes. The development and production systems must be the same
architecture and OS version.

The Oracle client libraries need to be the same version on both.

 What about the Perl??? Is that also have to be identicial in every
 respect???

I assumed the OP is planning on copying the entire Perl installation 
to the production machine.

 Has this actually been tried

Yes.

John
[EMAIL PROTECTED]

Parsing Results from fetchall_hashref()

[Rob Wilkerson]

I'm trying to debug a problem in a Perl script that retrieves records
from an Oracle database and writes those records to a flat file.  I'm
retrieving the records using fetchall_hashref() and have found that at
least one record isn't being written correctly so I'm trying to figure
out why.

I can access the value of each member just fine using $mediaref-
{$media_id}-{'ADID'} and I can access the size of the entire record
set as keys ( %$mediaref ).  What I need to know, though, is how many
elements exist in $mediaref-{$media_id}, but I can't figure out
whether that's possible or how to do it.  I've tried all kinds of
variations of keys ( %$mediaref-{$mediaid} ) with no luck at all.

Is it possible?  Am I correctly guessing at how the system stores
fields (i.e. as a nested hash)?

Any insight would be very much appreciated.

Thanks.

Rob Wilkerson