Hi Michiel,

 

Many thanks for your held thus far. 

 

I have tried as you suggested and get the following errors.  A few things that might be relevant:

-       The default install of OTRS installed to d:\otrs and perl is a subdir in d:\otrs\perl.  However, I see constant hardcoded references to c:\strawberry which does not exist.  I have changed all my variables in cpan conf to point to d:\otrs\perl.

-       I am able to connect to oracle from the command prompt using sqlplus otrs_user/passwd@odb

-       I am fairly clueless when it comes to Perl and its inner workings.  I have an Oracle development background. 

 

Regards,

Sajit

 

D:\OTRS\Perl\cpan\build\DBD-Oracle-1.22-RR1ujG>dmake

Skip blib\lib\DBD\Oracle.pm (unchanged)

Skip blib\lib/oraperl.ph (unchanged)

Skip blib\arch\auto\DBD\Oracle/dbdimp.h (unchanged)

Skip blib\arch\auto\DBD\Oracle/ocitrace.h (unchanged)

Skip blib\lib/Oraperl.pm (unchanged)

Skip blib\arch\auto\DBD\Oracle/Oracle.h (unchanged)

Skip blib\lib\DBD\Oracle\GetInfo.pm (unchanged)

cp mk.pm blib\arch\auto\DBD\Oracle/mk.pm

gcc -c  -ID:/oracle/instantclient_11_1/sdk/include -ID:/oracle/instantclient_11_

1/rdbms/demo -ID:\OTRS\Perl\perl\site\lib\auto\DBI      -s -O2 -DWIN32 -DHAVE_DE

S_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL

_MSVCRT_READFIX -s -O2    -DVERSION=\"1.22\"    -DXS_VERSION=\"1.22\"  "-ID:\OTR

S\Perl\perl\lib\CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OC

I_VERSION=\"11.1.0.7\" Oracle.c

Oracle.c: In function `boot_DBD__Oracle':

Oracle.c:2078: warning: unknown conversion type character `_' in format

Oracle.c:2078: warning: too many arguments for format

gcc -c  -ID:/oracle/instantclient_11_1/sdk/include -ID:/oracle/instantclient_11_

1/rdbms/demo -ID:\OTRS\Perl\perl\site\lib\auto\DBI      -s -O2 -DWIN32 -DHAVE_DE

S_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL

_MSVCRT_READFIX -s -O2    -DVERSION=\"1.22\"    -DXS_VERSION=\"1.22\"  "-ID:\OTR

S\Perl\perl\lib\CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OC

I_VERSION=\"11.1.0.7\" dbdimp.c

dbdimp.c: In function `dbd_discon_all':

dbdimp.c:199: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_db_login6':

dbdimp.c:738: warning: int format, long unsigned int arg (arg 9)

dbdimp.c:350: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_st_cancel':

dbdimp.c:842: warning: long unsigned int format, int arg (arg 8)

dbdimp.c: In function `ora_db_disconnect':

dbdimp.c:867: warning: unused variable `Perl___notused'

dbdimp.c: In function `createxmlfromstring':

dbdimp.c:1066: warning: long int format, int arg (arg 2)

dbdimp.c:1039: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_realloc_phs_array':

dbdimp.c:1323: warning: unused variable `Perl___notused'

dbdimp.c: In function `dbd_rebind_ph_char':

dbdimp.c:2197: warning: int format, IV arg (arg 5)

dbdimp.c: In function `pp_rebind_ph_rset_in':

dbdimp.c:2286: warning: unused variable `Perl___notused'

dbdimp.c: In function `pp_exec_rset':

dbdimp.c:2381: warning: unused variable `Perl___notused'

dbdimp.c: In function `dbd_rebind_ph_xml':

dbdimp.c:2423: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_bind_ph':

dbdimp.c:2743: warning: int format, IV arg (arg 2)

dbdimp.c:2752: warning: int format, IV arg (arg 2)

dbdimp.c:2786: warning: int format, IV arg (arg 3)

dbdimp.c:2799: warning: unknown conversion type character `_' in format

dbdimp.c: In function `ora_st_execute':

dbdimp.c:2912: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_st_execute_array':

dbdimp.c:3328: warning: unused variable `sv2'

dbdimp.c:3150: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_st_finish':

dbdimp.c:3491: warning: long unsigned int format, int arg (arg 8)

dbdimp.c:3454: warning: unused variable `Perl___notused'

dbdimp.c: In function `ora_st_destroy':

dbdimp.c:3587: warning: long unsigned int format, int arg (arg 8)

gcc -c  -ID:/oracle/instantclient_11_1/sdk/include -ID:/oracle/instantclient_11_

1/rdbms/demo -ID:\OTRS\Perl\perl\site\lib\auto\DBI      -s -O2 -DWIN32 -DHAVE_DE

S_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL

_MSVCRT_READFIX -s -O2    -DVERSION=\"1.22\"    -DXS_VERSION=\"1.22\"  "-ID:\OTR

S\Perl\perl\lib\CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OC

I_VERSION=\"11.1.0.7\" oci8.c

oci8.c: In function `oci_db_handle':

oci8.c:476: warning: unused variable `my_perl'

oci8.c: In function `oci_st_handle':

oci8.c:493: warning: unused variable `my_perl'

oci8.c: In function `ora_utf8_to_bytes':

oci8.c:849: warning: unused variable `my_perl'

oci8.c: In function `fetch_cleanup_rset':

oci8.c:960: warning: unused variable `Perl___notused'

oci8.c: In function `fetch_func_rset':

oci8.c:984: warning: unused variable `Perl___notused'

oci8.c: In function `dbd_rebind_ph_lob':

oci8.c:1095: warning: long int format, ub4 arg (arg 2)

oci8.c: In function `fetch_func_autolob':

oci8.c:1559: warning: unused variable `my_perl'

oci8.c: In function `calc_cache_rows':

oci8.c:1597: warning: unused variable `my_perl'

oci8.c: In function `get_attr_val':

oci8.c:1655: warning: unknown conversion type character `O' in format

oci8.c:1655: warning: char format, different type arg (arg 6)

oci8.c:1655: warning: too many arguments for format

oci8.c:1672: warning: unknown conversion type character `O' in format

oci8.c:1672: warning: char format, different type arg (arg 6)

oci8.c:1672: warning: too many arguments for format

oci8.c: In function `get_object':

oci8.c:1911: warning: int format, pointer arg (arg 6)

oci8.c: In function `fetch_get_piece':

oci8.c:2024: warning: int format, pointer arg (arg 6)

oci8.c:2047: warning: int format, pointer arg (arg 7)

oci8.c:2056: warning: long unsigned int format, int arg (arg 8)

oci8.c:2060: warning: unused variable `Perl___notused'

oci8.c: In function `ora_describe':

oci8.c:2823: warning: long int format, ub4 arg (arg 2)

oci8.c:2963: warning: int format, pointer arg (arg 6)

oci8.c: In function `ora_st_fetch':

oci8.c:3048: warning: long unsigned int format, int arg (arg 8)

oci8.c:3063: warning: long unsigned int format, int arg (arg 8)

oci8.c:3074: warning: long unsigned int format, int arg (arg 8)

oci8.c:3084: warning: unused variable `Perl___notused'

oci8.c:3091: warning: unused variable `Perl___notused'

oci8.c: In function `init_lob_refetch':

oci8.c:3556: warning: long int format, ub4 arg (arg 2)

oci8.c:3596: warning: long int format, int arg (arg 2)

oci8.c:3614: warning: int format, long int arg (arg 3)

Running Mkbootstrap for DBD::Oracle ()

D:\OTRS\Perl\perl\bin\perl.exe "-Id:/OTRS/Perl/perl/lib" "-Id:/OTRS/Perl/perl/li

b" -MExtUtils::Command -e chmod 644 Oracle.bs

dlltool --def Oracle.def --output-exp dll.exp

g++ -o blib\arch\auto\DBD\Oracle\Oracle.dll -Wl,--base-file -Wl,dll.base -mdll -

s -L"c:\strawberry\perl\lib\CORE" -L"C:\strawberry\c\lib" Oracle.o      dbdimp.o

        oci8.o -Wl,--image-base,0x23170000  D:\OTRS\Perl\perl\lib\CORE\libperl58

.a liboci.a dll.exp

Oracle.o:Oracle.c:(.text+0x653c): undefined reference to `OCILobGetChunkSize'

dbdimp.o:dbdimp.c:(.text+0xce4f): undefined reference to `OCINlsCharSetIdToName'

 

dbdimp.o:dbdimp.c:(.text+0xce75): undefined reference to `OCINlsCharSetIdToName'

 

collect2: ld returned 1 exit status

dmake:  Error code 129, while making 'blib\arch\auto\DBD\Oracle\Oracle.dll'

 

D:\OTRS\Perl\cpan\build\DBD-Oracle-1.22-RR1ujG>dmake test

dlltool --def Oracle.def --output-exp dll.exp

g++ -o blib\arch\auto\DBD\Oracle\Oracle.dll -Wl,--base-file -Wl,dll.base -mdll -

s -L"c:\strawberry\perl\lib\CORE" -L"C:\strawberry\c\lib" Oracle.o      dbdimp.o

        oci8.o -Wl,--image-base,0x23170000  D:\OTRS\Perl\perl\lib\CORE\libperl58

.a liboci.a dll.exp

Oracle.o:Oracle.c:(.text+0x653c): undefined reference to `OCILobGetChunkSize'

dbdimp.o:dbdimp.c:(.text+0xce4f): undefined reference to `OCINlsCharSetIdToName'

 

dbdimp.o:dbdimp.c:(.text+0xce75): undefined reference to `OCINlsCharSetIdToName'

 

collect2: ld returned 1 exit status

dmake:  Error code 129, while making 'blib\arch\auto\DBD\Oracle\Oracle.dll'

 

D:\OTRS\Perl\cpan\build\DBD-Oracle-1.22-RR1ujG>dmake install

dlltool --def Oracle.def --output-exp dll.exp

g++ -o blib\arch\auto\DBD\Oracle\Oracle.dll -Wl,--base-file -Wl,dll.base -mdll -

s -L"c:\strawberry\perl\lib\CORE" -L"C:\strawberry\c\lib" Oracle.o      dbdimp.o

        oci8.o -Wl,--image-base,0x23170000  D:\OTRS\Perl\perl\lib\CORE\libperl58

.a liboci.a dll.exp

Oracle.o:Oracle.c:(.text+0x653c): undefined reference to `OCILobGetChunkSize'

dbdimp.o:dbdimp.c:(.text+0xce4f): undefined reference to `OCINlsCharSetIdToName'

 

dbdimp.o:dbdimp.c:(.text+0xce75): undefined reference to `OCINlsCharSetIdToName'

 

collect2: ld returned 1 exit status

dmake:  Error code 129, while making 'blib\arch\auto\DBD\Oracle\Oracle.dll'

 

D:\OTRS\Perl\cpan\build\DBD-Oracle-1.22-RR1ujG>

 

 

This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal