I'm attempting to use PP to package a script I've written which does a lot of work on a database. I've installed DBI and the Oracle DBI driver in a subdirectory of my user's home directory, due to issues with system admins not wanting it installed globally.

I can run the script from the .pl file fine, after including the line unshift(@INC,"/export/home/pguillot/modules/sun4-solaris") so that the DBI module and Oracle driver can be found.

However, after packaging the script with pp -o script.exe -a ~pguillot/modules/sun4-solaris/ billcycle.pl attempting to run the generated executable yields the error 

install_driver(Oracle) failed: Can't load '/tmp/par-pguillot/cache-d7f
+3e360cc7caa97a798297098048980b6b8989f/bb3f1c9e.so' for module DBD::Or
+acle: ld.so.1: script.exe: fatal: /apps/oracle/app/oracle/product/10g
+/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /usr/local/lib
+/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230.
 at ../blib/lib/PAR/Heavy.pm line 104
Compilation failed in require at (eval 13) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at script/billcycle.pl line 122

[download]

Line 122 is simply 

my $dbh = DBI->connect( "dbi:Oracle:" . $db_name , $db_user , $db_pass
+ , {AutoCommit => 0} )
        or die "Fatal Error: Could not connect to the database: " . DB
+I->errstr() . "\n";

[download]

I'm not very well versed in the use of PP, and am wondering if I'm missing some step which would cause an issue in the linking of the shared libraries. I'd appreciate any help if anyone sees something that jumps out at them here.

Thanks,
-Preston

In reply to PP problems finding DBI driver libraries by OedipusPrime

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.