Re: error during DBD::Oracle installation (was: error during DBI installation)

------=_Part_6037_22545193.1207194199772
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Looks like time to get the development stuff you need installed.  The log
file says:

Reading /export/home/oracle/product/9Iclient/precomp/lib/env_precomp.mk

Attempting to discover Oracle OCI build rules
gcc -c  -I. -I/export/home/oracle/product/9Iclient/precomp/public
-I/export/home/oracle/product/9Iclient/rdbms/public
-I/export/home/oracle/product/9Iclient/rdbms/demo
-I/export/home/oracle/product/9Iclient/plsql/public
-I/export/home/oracle/product/9Iclient/network/public
-I/export/home/oracle/product/9Iclient/rdbms/demo
-I/export/home/oracle/product/9Iclient/rdbms/demo
-I/opt/ActivePerl-5.8/lib/site_perl/5.8.7/sun4-solaris-thread-multi/auto/DBI/
 -D_POSIX_PTHREAD_SEMANTICS -D_REENTRANT -DUSE_SITECUSTOMIZE
-DNO_HASH_SEED -DBUILT_BY_ACTIVESTATE -fno-strict-aliasing -pipe
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"1.16\"
-DXS_VERSION=\"1.16\" -fPIC
"-I/opt/ActivePerl-5.8/lib/5.8.7/sun4-solaris-thread-multi/CORE"
-Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"9.2.0.1\" DBD_ORA_OBJ.c
by executing: [make -f
/export/home/oracle/product/9Iclient/precomp/demo/proc/demo_proc.mk
build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true
OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
Oracle oci build command:
        [true -o DBD_ORA_EXE DBD_ORA_OBJ.o
-L/export/home/oracle/product/9Iclient/lib/ -lclntsh `cat
/export/home/oracle/product/9Iclient/lib/ldflags`   `cat
/export/home/oracle/product/9Iclient/lib/sysliblist`
-R/export/home/oracle/product/9Iclient/lib -laio  -lposix4  -lm
-lthread]

Found header files in rdbms/demo.


*********************************************************
I can't find the header files I need in your Oracle installation.
You probably need to install some more Oracle components.
I'll keep going, but the compile will probably fail.
See README.clients for more information.
*********************************************************


It also says:

***  If you have problems...
     read all the log printed above, and the README and README.help files.
     (Of course, you have read README by now anyway, haven't you?)


So, which part of that is too hard to understand?  You're running on ancient
Solaris (2.6 - not supported), and you have a fairly old version of Oracle
client -- did you check whether it is supported.

And DBD does not mean DBD::Oracle - there are lots of DBD::DBMS drivers.


On Wed, Apr 2, 2008 at 1:08 PM, Sasidharan, Radhakrishnan <
Radhakrishnan.Sasidharan@xerox.com> wrote:

> We are trying to run the DBD installation on a unix server. We are able to
> do the Makefile.PL but it failed on the subsequent make. Attached is the
> output of the two commands. Kindly help us to resolve this issue.
>



-- 
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

------=_Part_6037_22545193.1207194199772--
0
jonathan
4/3/2008 3:43:19 AM
perl.dbi.users 11028 articles. 1 followers. Follow

2 Replies
458 Views

Similar Articles

[PageSpeed] 57

Hi.

I am using Perl 5.8.8 on SunOS pnc 5.8 with Informix (Server Version
9.30) and DBI 1.51 and DBD::Informix 2005.2.

I try to copy a list of tables using DBI.  I have found that a certain
column declared as varchar(64) is copied incorrectly when it contains an
empty string.  The value in the target location is a string containing
one space instead of being empty.

Here is a code fragment copied from the actual script:

foreach my $tb ( @$table_list )
{
    my ( $sel ) =3D $from_dbh->prepare( "SELECT * FROM $tb" );
    $sel->execute();
    my ( $cols, $val_str ) =3D ( $sel->{NUM_OF_FIELDS}, "()" );
    $val_str =3D "(" . ("?," x ($cols-1)) . "?)"  if ( $cols>0 );
    my ( $ins ) =3D $to_dbh->prepare( "INSERT INTO $tb VALUES" . $val_str
);
    my ( $fetch_tuple_sub ) =3D sub { $sel->fetchrow_arrayref };
    my @tuple_status;
    my ( $rc ) =3D $ins->execute_for_fetch( $fetch_tuple_sub,
\@tuple_status );
    my ( @errors ) =3D grep { ref $_ } @tuple_status;
    $sel->finish();
    $ins->finish();
}

Is this a known bug?  Is there a way I can get this code to faithfully
reproduce the data including blank strings of type varchar(64)?

-Will



     - - - - - Appended by Scientific Atlanta, a Cisco company - - - - - =
        
This e-mail and any attachments may contain information which is confiden=
tial, 
proprietary, privileged or otherwise protected by law. The information is=
 solely 
intended for the named addressee (or a person responsible for delivering =
it to 
the addressee). If you are not the intended recipient of this message, yo=
u are 
not authorized to read, print, retain, copy or disseminate this message o=
r any 
part of it. If you have received this e-mail in error, please notify the =
sender 
immediately by return e-mail and delete it from your computer.

0
Will
4/3/2008 10:34:07 PM
------=_Part_5408_8005666.1207270249273
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Bother.

---------- Forwarded message ----------
From: Jonathan Leffler <jonathan.leffler@gmail.com>
Date: Thu, Apr 3, 2008 at 5:49 PM
Subject: Re: Blank inserted with varchar copy using prepare
To: "Rutherdale, Will" <Will.Rutherdale@sciatl.com>




On Thu, Apr 3, 2008 at 3:34 PM, Rutherdale, Will <Will.Rutherdale@sciatl.com>
wrote:

> I am using Perl 5.8.8 on SunOS pnc 5.8 with Informix (Server Version
> 9.30) and DBI 1.51 and DBD::Informix 2005.2.
>
> I try to copy a list of tables using DBI.  I have found that a certain
> column declared as varchar(64) is copied incorrectly when it contains an
> empty string.  The value in the target location is a string containing
> one space instead of being empty.
>
> Here is a code fragment copied from the actual script:
>
> foreach my $tb ( @$table_list )
> {
>    my ( $sel ) = $from_dbh->prepare( "SELECT * FROM $tb" );
>    $sel->execute();
>    my ( $cols, $val_str ) = ( $sel->{NUM_OF_FIELDS}, "()" );
>    $val_str = "(" . ("?," x ($cols-1)) . "?)"  if ( $cols>0 );
>    my ( $ins ) = $to_dbh->prepare( "INSERT INTO $tb VALUES" . $val_str
> );
>    my ( $fetch_tuple_sub ) = sub { $sel->fetchrow_arrayref };
>    my @tuple_status;
>    my ( $rc ) = $ins->execute_for_fetch( $fetch_tuple_sub,
> \@tuple_status );
>    my ( @errors ) = grep { ref $_ } @tuple_status;
>    $sel->finish();
>    $ins->finish();
> }
>
> Is this a known bug?  Is there a way I can get this code to faithfully
> reproduce the data including blank strings of type varchar(64)?
>

Perl 5.10.0 on Solaris 10, DBI 1.604, DBD::Informix 2008.0229, ESQL/C
3.00.UC2.

#!/bin/perl -w
use strict;
use DBD::Informix::TestHarness;

my($dbh) = connect_to_test_database({RaiseError => 1});

my($tbl1) = "dbd_ix_something_1";
my($tbl2) = "dbd_ix_something_2";
$dbh->do("create {temp} table $tbl1 ( col VARCHAR(64) NOT NULL)");
$dbh->do("create {temp} table $tbl2 ( col VARCHAR(64) NOT NULL)");
$dbh->do("INSERT INTO $tbl1 VALUES('a')");  # Non-blank VARCHAR
$dbh->do("INSERT INTO $tbl1 VALUES(' ')");   # Single-blank VARCHAR
$dbh->do("INSERT INTO $tbl1 VALUES('')");    # Empty (non-null) VARCHAR

my($from_dbh) = $dbh;
my($to_dbh) = $dbh;

my($table_list) = [ $tbl1 ];

foreach my $tb ( @$table_list )
{
    my ( $sel ) = $from_dbh->prepare( "SELECT * FROM $tb" );
    $sel->execute();
    my ( $cols, $val_str ) = ( $sel->{NUM_OF_FIELDS}, "()" );
    $val_str = "(" . ("?," x ($cols-1)) . "?)"  if ( $cols>0 );
    my ($new) = $tb;
    $new =~ s/1/2/;
    my ( $ins ) = $to_dbh->prepare( "INSERT INTO $new VALUES" . $val_str);
    my ( $fetch_tuple_sub ) = sub { $sel->fetchrow_arrayref };
    my @tuple_status;
    my ( $rc ) = $ins->execute_for_fetch( $fetch_tuple_sub,
    \@tuple_status );
    my ( @errors ) = grep { ref $_ } @tuple_status;
    $sel->finish();
    $ins->finish();
}

Runs OK - first time.

Black JL: perl will.sciatl.pl
# DBI->connect('dbi:Informix:stores', '', '');
#       Connect Attribute: RaiseError => 1
#       Connect Attribute: ChopBlanks => 1
Black JL: sqlcmd -d stores -F unload -e 'select * from dbd_ix_something_1'
a|
 |
\ |
Black JL: sqlcmd -d stores -F unload -e 'select * from dbd_ix_something_2'
a|
 |
\ |
Black JL:

Basically, this code is copying the single blank and the empty but non-null
string accurately.

So, in the absence of a reproduction with DBD::Informix 2008.0229, I'm going
to claim "no longer a problem".  There have been issues in the handling of
VARCHAR, both in ESQL/C and in DBD::Informix on occasion, but not
self-evidently on this occasion.

I assume there's a reason why you can't do:
    INSERT INTO dbase2:tablename SELECT * FROM dbase1:tablename;
Probably related to error -999 (not implemented yet).

-- 
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."



-- 
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

------=_Part_5408_8005666.1207270249273--
0
jonathan
4/4/2008 12:50:49 AM
Reply:

Similar Artilces:

Re: RE: Error in DBD::Oracle Installation
Thanks! I don't where I have to put Oracle.so file Please let me know to which directory I supposed to put from where?? Thanks again > > From: Jayanta Banerjee <jbanerjee@pdx.medscapeinc.com> > Date: 2001/04/17 Tue AM 09:33:29 EDT > To: 'Prasanna Gopalakrishna' <prasanna@fuse.net> > Subject: RE: Error in DBD::Oracle Installation > > Where is your Oracle.so file ? It is not finding that file in the proper > location. Try to put it in the appropriate directory. > > Thanks > > Jayanta Banerjee > Phone : 503-...

Re-install of Oracle -- does DBD::Oracle need to be re-installed?
I've recently come upon a situation where Oracle is not installed in a standard place (company standard). There is a potential the DBA group will want to delete the current installation and re-install in the standard directory structure. I'm guessing that this will impact my DBD::Oracle installation, since libraries will be in different places, etc. Can anyone confirm whether this will be a problem? What steps must I take in order to get DBD::Oracle to the proper state? Will this require me to uninstall anything, and if so is there a standard DBD uninstall procedure? ...

Attempting to manually install DBI...errors with DBI.DLL
------=_NextPart_000_0003_01C23109.8133FD90 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit This issue just will not die. I have recently moved to a server that is under the same architecture as my intranet server (Intel) and we are both running the same version and builds of ActiveState Perl (5.6.1 Build 629). I do not have any way (telnet, SSH, shell) of *properly* (via automation) installing modules to the host machine and the host provider will not install *additional* modules not included in the standard distribution of Perl. ...

re: dbi.pm install errors
Ganesh, I read your post to beginners-cgi posting board. I would appreciate any help you can provide. I had the following error installing DBI.pm (DBI-1.32 version) on WinXP machine and was wondering if you got a solution? I used makefile.pl and was successful but the following fatal error occurred when using nmake: C:\Perl\bin\perl.exe -Ic:\Perl\lib -Ic:\Perl\lib C:\Perl\lib\ExtUtils/xs ubpp -typemap C:\Perl\lib\ExtUtils\typemap Perl.xs > Perl.xsc && C:\Perl\bin\pe rl.exe -Ic:\Perl\lib -Ic:\Perl\lib -MExtUtils::Command -e mv Perl.xsc Perl.c cl ...

Installing DBD:Oracle (DBI 1.37 installed) (64bit) no ideas?
Hello, and good Morning I have a probelm with the installation of DBD:Oracle on the describted system. The environment is configured by our db-administrators, so I guess it should be correct. A Oracle 8 client is installed. The DBI-Module installtion looks good. If I try to "perl ./Makefile.PL" or "perl ./Makefile.PL -8" in the DBD-Oracle-1.14 directory, I get only 1 line back: Using DBI-1.37 installed in /usr/lib/perl/site_perl/5.6.1/sun4-solaris-64int/auto/DBI And the it does not do anything anymore till armageddon. If anyone have some info...

DBI Installation errors
I am trying to install the DBI-1.18 module on my Mac OS X server, running OS 10.2.2. I get the following error after the make command: Running Mkbootstrap for DBI () chmod 644 DBI.bs LD_RUN_PATH="" cc -o blib/arch/auto/DBI/DBI.bundle -bundle -flat_namespace -undefined suppress DBI.o /usr/bin/ld: /usr/lib/libSystem.dylib load command 9 unknown cmd field make: *** [blib/arch/auto/DBI/DBI.bundle] Error 1 Can anyone help me get this to install. -- Patrick Gormley Lapeer East High School Lapeer MI 48446 http://chem.lapeer.org/ "Education is not the filling o...

Error installing DBI
Hi All, While I am trying to install DBI 1.15 on Solaris, perl Makefile.PL PREFIX=$HOME INSTALLSITELIB=$HOME INSTALLSITEARCH=$HOME/sun4-solaris I got this error: Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: lib /usr/local/lib/perl5/sun4-solaris/5.00404 /usr/local/lib/perl5 /usr/local/lib/perl5/site_perl/sun4-solaris /usr/local/lib/perl5/site_perl ..) at Makefile.PL line 14. BEGIN failed--compilation aborted at Makefile.PL line 14. Any explanations? Why it is looking in /usr/local.... I have only the Perl interpreter on the machine, is there anythin...

dbi install error
Hi, I'm trying to install dbi, on machine running Windows NT, by issuing PPM install dbi.ppd. I'm getting the following error: Error: No Valid repositories: Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown error) The version of Perl is 5.8.0 built for MSWin32-x86-multi-thread, Binary build 806. I did not install PERL on this machine, it was already there. I have installed DBI/DBD a lot of times and have never seen this error before. Do I need to reinstall PERL?? Thanks for any help, /Dave __________________________________ Do you...

Errors in DBI installation!!
------_=_NextPart_001_01C74A29.6CD1DE8C Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C74A29.6CD1DE8C" ------_=_NextPart_002_01C74A29.6CD1DE8C Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 I am getting the errors when trying to install DBI module. Please have a look at the attached files and let me know where I am going wrong. =20 Thanks alot, Goverdhan. ------_=_NextPart_002_01C74A29.6CD1DE8C Content-Type: text/html; charset="us-ascii" Content-Transfer-Encodi...

error in installing DBI
Hai, While installing dbi on Linux/SuSE machine I got an error. I entered as a root on the machine. When I executed the command perl Makefile.PL it gave the following error Unable to open the file MakeMaker.tmp : permission denied at /usr/lib/perl5/5.6.1/ExtUtils/makeMaker.pm at line number 759. My perl version is 5.6.1 Please suggest me how to install it. Advanced thanks. regards, china. ===== cnu. __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ...

error while installing DBI
Hi, When I try to install DBI the following error is coming.... Please help.... PPM> install DBI Install package 'DBI?' (y/N): y Installing package 'DBI'... Error installing package 'DBI': Could not locate a PPD file for package DBI PPM> Thanks in advance Murugan. I don't think DBI is available in PPD format. You need to CPAN or do it by hand (download the package and its dependencies, gzip -d, tar, perl Makefile.pl, make, make tests, make install). I've had mixed success with CPAN on Windows. HTH, Dave On Sep 2, MURUGAN V ...

Error while DBI installation
------=_NextPart_000_0029_01C1D415.54270690 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am trying to install DBI Perl module on Linux. First 2 commands ( perl Makefile.PL , make) went successful. But when i give "make test", i get an error in preparse.t. Following is the log attached for the command. Regards, Laxmikant=20 ------=_NextPart_000_0029_01C1D415.54270690-- ...

DBI installation error
------_=_NextPart_000_01C15D77.60B153D0 Content-Type: text/plain; charset="iso-8859-1" Hello I am compiling DBI-1.20 using gcc 2.95.3 and perl 5.6.1 and I am geeting a core dump when it runs the t/examp tests. I have attached a file with the errors. What are the t/examp tests testing. I want to know in case it is not relevant and I can ignore it. <<dbierror.txt>> (:=) Think Globally Act Locally (=:) (-: Nagu :- ) Southampton City Council - CPS Tel :- 02...

DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
Hi Running some redhat servers and created some scripts that use DBI and = DBD::Oracle to access our 10.2.0.3 databases. The script was built and tested and has been used successfully on dual = core 64bit Xeon CPU servers and with as best as we can tell an identical = installation on some new quad core servers the script fails with the = above error. We have tried a later version of DBI we were using the 1.40 version = installed as a RPM and have installed 1.59 using perl and make. DBD::Oracle is 1.19 I have some strace output from where it fails running a simple piece of = co...

Web resources about - Re: error during DBD::Oracle installation (was: error during DBI installation) - perl.dbi.users

List of United States Army installations in Germany - Wikipedia, the free encyclopedia
Gen. Lucius D. Clay Kaserne (former Wiesbaden Army Airfield, renamed 2012), Wiesbaden The rationale behind the large number of closures is that ...

Fulton Center - Glass Installation - Metropolitan Transportation Authority (MTA) - Facebook
As of June 8, 2012, several of the Fulton Center's newly built and rehabilitated underground passageways have been substantially completed. Photo:... ...

App Store - Smiley+ Easy Emoji Installation for iPhone
Get Smiley+ Easy Emoji Installation for iPhone on the App Store. See screenshots and ratings, and read customer reviews.

SRNL Fiber Optic Cable Installation - Flickr - Photo Sharing!
The SRNS Information and Technology department installs new fiber optic cable to expand communication capabilities for the Savannah River National ...

Blink Twice video installation at Summer Set Festival: 3D motion faces projected on trees - YouTube
Blink Twice is a video installation that transforms trees into huge 3D faces that smile, move, gesticulate and even follow the viewer's gaze. ...

Cyclone Marcia: Building regulator to investigate dodgy roof installations
Queensland's building industry regulator will be asking for answers from contractors responsible for dodgy roof installations exposed by Tropical ...

Lego refuses to supply bricks for Weiwei installation at National Gallery of Victoria because of 'political ...
Part of a major international exhibition planned for Melbourne is thrown into doubt after Lego refuses to supply building blocks for the project. ...

Canada Post Suspends Community Mailbox Installation 55
... the comprehensive program on hold in an orderly fashion,'' said a statement. OTTAWA — The country's national mail carrier has halted the installation ...

Apple TV advertising goes beyond small screen with new billboard installations
Taking its Apple TV advertising campaign beyond the small screen and into the real world, Apple is in the process of plastering U.S. billboards ...

How to download Windows 10 with the November Update and create your own installation media
... versions available. Save and run the file. You’ll be offered two choices. You can upgrade the PC you’re on to Windows 10 or create installation ...

Resources last updated: 12/17/2015 4:23:11 AM