Oracle OCI - OCI on Win

Author

OCI on Win

Dave K

2005-06-03, 8:27 pm

Hello,
I am going to try to build this on WinNT, and I hope to find some help
here (without tying up too much of any one person's time).
I am using NT sp5, with cygwin, Perl 5.8 and DBD::Oracle 1.12 compiled on
this box. Oracle 8.1.5 (the header file are not where they usually are, but
I found them).
First issue in running boot is:
DBD::Oracle::mk module doesn't define dynamic_lib at ./mod_boot line 92.
Where in the makefile can I find the information required to cure this
(first of probably many) errors?
TIA
David

Tim Bunce

2005-06-03, 8:27 pm

On Thu, Apr 03, 2003 at 07:34:28AM -0500, Dave K wrote:
> Hello,
> I am going to try to build this on WinNT, and I hope to find some help
> here (without tying up too much of any one person's time).
> I am using NT sp5, with cygwin, Perl 5.8 and DBD::Oracle 1.12 compiled on
> this box. Oracle 8.1.5 (the header file are not where they usually are, but
> I found them).
> First issue in running boot is:
> DBD::Oracle::mk module doesn't define dynamic_lib at ./mod_boot line 92.
> Where in the makefile can I find the information required to cure this

You could just comment out the error and see what fails later...

> (first of probably many) errors?

Indeed!

Tim.

Dave K

2005-06-03, 8:27 pm

> You could just comment out the error and see what fails later...
>
Some how I knew you were going to say that...
I did comment out the cause of the error and ran into 'Hit by missing
[ORACLE_HOME OCI_HEADER etc] and found work arounds/fixes. Then tried again.
h2xs seems to be choking (though the real problem may be in assemblying the
args for h2xs

A partial listing of the result is:
Actual var sent to qx (added by djk to try to dig in and find the error)

h2xs -d -O -n
Oracle::OCI -F -IE:/Oracle/Ora81/oci/include/ -IE:/Oracle/Ora81/...
^OCI(? !AQ|AttrGet|Bind|Cac
he|Callback|Complex|
Context|Date|DirPath
|EnvCallba
ck...
er|Raw|Ref|Security|
SharedLibInit|StmtBi
ndByName|StmtBindByP
os|StmtGetBindIn
fo...
deChar|_FLAGS|_FNCOD
E_|_NLS_|_ORACLE)|^S
QL' -k -x
E:/Oracle/Ora81/\OCI\INCLUDE...
Running h2xsA...
Unknown option: IE:/Oracle/Ora81/oci/include/
Unknown option: E
h2xs [OPTIONS ... ] [headerfile & #91;extra_libraries]
]
version: 1.22

I have been working to make the above execute cleanly.
my $h2xs = qw( h2xs );
my $h2xsA = $h2xs .' '. join ' ', @h2xsargz;
This may be misguided or I may need to clean up the args array.
Any help appreciated.

Dave K

2005-06-03, 8:27 pm

More progress...
More errors. A partial list:
collect2: ld returned 1 exit status
perlld: *** system() failed to execute
gcc -shared -o

OCI.dll -Wl,--out-implib=libOCI.dll.a -Wl,--export-all-symbols -Wl,--enable-
auto-import -Wl,--stack,8388608 \
-s -L/usr/local/lib OCI.o utility.o
/usr/lib/perl5/5.8.0/cygwin-multi-64int/CORE/libperl.dll.a -loci

make: *** [blib/arch/auto/Oracle/OCI/OCI.dll] Error 1
I did not want to offer a very large post so the rest is attached as
list_oci.txt
Thanks!

begin 666 list_oci.txt
M)" N+VUO9%]B;V]T#0IV+7-T<FEN9R!I;B!U<V4O<F5Q=6ER92!N;VXM<&]R
M=&%B;&4@870@+B]M;V1?8F]O="!L:6YE(#,N#0H-"B!/<F%C;&4@:&]M92!I
M<R!R97!O<G1E9"!T;R!B92 Z13HO3W)A8VQE+T]R83@
Q+PT*#0H@($]#22!)
M;F-L=61E(')E<&]R=&5D('1O(&)E($4Z+T]R86-L92]/<F$X,2]O8VDO:6YC
M;'5D92\-"@T*02!L:7-T:6YG(&]F('1H92!C;VYT96YT<R!F;VQL;W=S#0I$
M:7)E8W1O<GDZ("]C>6=D<FEV92]E+T]R86-L92]/<F$X,2]O8VDO:6YC;'5D
M92\-"D-$14U/1% P+D@-"DM54T%022Y(#0I+55-404=3+D@-"DY:15)23U(N
M2 T*3EI4+D@-"D]#22Y(#0I/0TDQ+D@-"D]#23A$4"Y(#0I/0TE!4"Y(#0I/
M0TE!4%(N2 T*3T-)1$5&+D@-"D]#241%32Y(#0I/0TE$1DXN2 T*3T-)15A4
M4"Y(#0I/0TE+4"Y(#0I/0TE+4%(N2 T*3T1#22Y(#0I/4D%465!%4RY(#0I/
M4DDN2 T*3U))1"Y(#0I/4DPN2 T*3U)/+D@-"D]25"Y(#0I36#,N2 T*5$Y3
M05!)+D@-"@T*4F5G97@@9F]R(&@R>',@:6=N;W)E<SH@7D]#22@_(4%1?$%T
M=')'971\0FEN9'Q#86- H97Q#86QL8F%C:WQ#;VU
P;&5X?$-O;G1E>'1\1&%T
M97Q$:7)0871H?$5N=D-A;&QB86-K?$5X=')A8W1\1FEL97Q&;W)M871\26YT
M97)V86Q\271E<GQ-96UO<GE\365S<V%G#0IE?$UU;'1I0GET97Q/8FIE8W1\
M4&EC:VQE<GQ287=\4F5F?%-E8W5R:71Y?%- H87)E9$QI8DEN:71\4W1
M=$)I
M;F1">4YA;65\4W1M=$)I;F1">5!O<WQ3=& UT1V5T0FEN9$EN9F]\4W
1R:6YG
M?%-U8G-C<FEP=& EO;GQ486)L97Q4:')E86
1\5'EP97Q4>7!E07)R87D-"D)Y
M3F%M97Q4>7!E07)R87E">5)E9GQ7:61E0VAA<GQ?1DQ!1U-\7T9.0T]$15]\
M7TY,4U]\7T]204-,12E\7E-13 T*0V]M<&QE=&4@:#)X<R!A<F=U;65N=',Z
M("XO:#)X<R M9" M3R M;B!/<F%C;&4Z.D]#22 M1B M22]C>6=D<FEV92]E
M+T]R86-L92]/< F$X,2]O8VDO:6YC;'5D9
2\@+4DO8WEG9')I=F4O9
2]/<F%C
M;&4O3W)A.#$O;V-I+VEN8VQU9&4O("U%(&=E=%]O8VE?97)R#0IO<BQG971?
M;V-I7VAA;F1L92QO8VE?8G5F7VQE;BQ/0TE!='1R1V5T("U-("=>3T-)*#\A
M05%\071T<D=E='Q":6YD?$-A8VAE?$-A;&QB86-K?$-O;7!L97A\0V]N=&5X
M='Q$871E?$1I<E!A=&A\16YV0V%L;&)A8VM\17AT<F%C='Q&:6QE?$9O<FUA
M='Q);G1E<G8-"F%L?$ET97)\365M;W)Y?$UE<W-A9V5\375L=&E">71E?$]B
M:F5C='Q0:6-K;&5R? %)A=WQ2969\4V5C=7)I=
'E\4VAA<F5D3&EB26YI='Q3
M=&UT0FEN9$)Y3F%M97Q3=&UT0FEN9$)Y4&]S?%-T;71'971":6YD26YF;WQ3
M=')I;F=\4W5B<V-R:7!T:6]N?%1A8FQE? T*5&AR96%D?%1Y<&5\5'EP94%R
M<F%Y0GE.86UE?%1Y<&5!<G)A>4)Y4F5F?%=I9&5#:&%R?%]&3$%'4WQ?1DY#
M3T1%7WQ?3DQ37WQ?3U)!0TQ%*7Q>4U%,)R M:R M>" O8WEG9')I=F4O92]/
M<F%C;&4O3W)A.#$O3T-)+TE.0TQ51$4O;V-I+F@-"@T*#0I!8W1U86P@=F%R
M('-E;G0@=&\@<7@-"@T*+B]H,GAS("UD("U/("UN($]R86-L93HZ3T-)("U&
M("U)+V- Y9V1R:79E+V4O3W)A8VQ
E+T]R83@Q+V]C:2]I;F-L=61E+R M22]C
M>6=D<FEV92]E+T]R86-L92]/< F$X,2]O8VDO:6YC;'5D9
2\@+44@9V5T7V]C
M:5]E<G)O<BQG971?;V-I7VAA;F1L92QO8VE?8G5F#0I?;&5N+$]#24%T=')'
M970@+4T@)UY/0TDH/R%!47Q!='1R1V5T?$)I;F1\0V%C:&5\0V%L;&)A8VM\
M0V]M<&QE>'Q#;VYT97AT?$1A=&5\1&ER4& %T:'Q%;G9#86QL8F%C:W
Q%>'1R
M86-T?$9I;&5\1F]R;6%T?$EN=&5R=F%L?$ET97)\365M;W)Y?$UE<W-A9V5\
M374-"FQT:4)Y=&5\3V)J96-T?%!I8VML97)\4F%W?%)E9GQ396-U<FET>7Q3
M:&%R961,:6));FET?%-T;71":6YD0GE.86UE?%-T;71":6YD0GE0;W-\4W1M
M=$=E=$)I;F1);F9O?%-T<FEN9WQ3=6)S8W)I<'1I;VY\5&%B;&5\5&AR96%D
M?%1Y<&5\5'EP94%R<F%Y0GE.80T*;65\5'EP94%R<F%Y0GE2969\5VED94-H
M87)\7T9,04=3?%]&3D-/1$5??%].3%-??%]/4D%#3$4I?%Y344PG("UK("UX
M("]C>6=D<FEV92]E+T]R86-L92]/<F$X,2]/ 0TDO24Y#3%5$12]O8VDN
: T*
M4G5N;FEN9R!H,GAS+BX
N#0I38V%N;FEN9R!T>7!E;6%P<RXN+@T*(%-C86YN
M:6YG("]U<W(O;&EB+W!E<FPU+S4N."XP+T5X=%5T:6QS+W1Y<&5M87 -"E-C
M86YN:6YG("]C>6=D<FEV92]E+T]R86-L92]/<F$X,2]/0TDO24Y#3%5$12]O
M8VDN:" !F;W(@9G5N8W1I;VYS+B
XN#0I38V%N;FEN9R O8WEG9')I=F4O92]/
M<F%C;&4O3W)A.#$O3T-)+TE.0TQ51$4O;V-I+F@@9F]R('1Y<&5D969S+BXN
M#0I7<FET:6YG($]R86-L92]/0TDO3T-)+G!M#0I7<FET:6YG($]R86-L92]/
M0TDO3T-)+GAS#0I7<FET:6YG($]R86-L92]/0TDO='EP96UA< T*5W)I=&EN
M9R!/<F%C;&4O3T- )+TUA:V5F:6QE+E!,#0I
7<FET:6YG($]R86-L92]/0TDO
M=&5S="YP; T*5W)I=&EN9R!/<F%C;&4O3T-)+T-H86YG97,-"E=R:71I;F<@
M3W)A8VQE+T]#22]-04Y)1D535 T*161I=&EN9R!/0TDN>',N+BX-"D5D:71I
M;F<@36%K969I;&4N4$PN+BX-"D)U:6QD:6YG+BXN#0I5<VEN9R!$0DD@,2XS
M,B!I;G-T86QL960@:6X@+W5S<B]L:6(O<&5R;#4O<VET95]P97)L+S4N."XP
M+V-Y9W=I;BUM=6QT:2TV-&EN="]A=71O+T1"20T*0VAE8VMI;F<@:68@>6]U
M<B!K:70@:7,@8V]M<&QE=&4N+BX-"DQO;VMS(&=O;V0-"E=R:71I;F<@36%K
M969I;&4@9F]R($]R86-L93HZ3T-)#0IC<"!/0TDN<&T@8FQI8B]L:6(O3W)A
M8VQE+T]#22YP;0T*075
T;U-P;&ET=&EN9R!B;&EB+VQI8B]/<F%C;&4O3T-)
M+G!M("AB;& EB+VQI8B]A=71O+T]R86
-L92]/0TDI#0HO=7-R+V)I;B]P97)L
M+F5X92 O=7-R+VQI8B]P97)L-2\U+C@N,"]%>'15=&EL<R]X<W5B<' @("UT
M>7!E;6%P("]U<W(O;&EB+W!E<FPU+S4N."XP+T5X=%5T:6QS+W1Y<&5M87 @
M+71Y<&5M87 @:#)X<RYT>7!E;6%P("UT>7!E;6%P('1Y<&5M87 @($]#22YX
M<PT*/B!/0TDN>'-C("8F(&UV($]#22YX<V,@3T-)+F,-"E!L96%S92!S<&5C
M:69Y('!R;W1O='EP:6Y
G(&)E:&%V:6]R(&9O<B!/0TDN>',@*'-E92!P97)L
M>',@;6%N=6%L*0T*9V-C("UC(" M22]C>6=D<FEV92]E+T]R86-L92]/<F$X
M,2]O8VDO:6YC;'5D92\
@+4DO=7-R+VQI8B]P97)L-2]S:71E7W!E<FPO-2XX
M+C O8WEG=VEN+6UU;'1I+38
T:6YT+V%U=&\O1$)$+T]R86-L92 M22]U<W(O
M;&EB+W!E<FPU+W-I=&5?<&5R;"\U+C@N," ]C#0IY9W=I;BUM=6QT:2
TV-&EN
M="]A=71O+T1"22 M1%!%4DQ?55-%7U-!1D5?4%5414Y6("UF;F\M<W1R:6-T
M+6%L:6%S:6YG("U$55-%24U03U)43$E"("UG(" @+41615)324]./5PB,"XP
M,5PB("U$6%-?5D524TE/3CU<(C N,#%<(B @(BU)+W5S<B]L:6(O<&5R;#4-
M"B\U+C@N,"]C>6=W:6XM;75L=&DM-C1I;G0O0T]212(@("U)+V-Y9V1R:79E
M+V4O3W)A8VQE+T]R83@
Q+V]C:2]I;F-L=61E+R!/0TDN8PT*3T-)+GAS.B!)
M;B!F=6YC=&EO;B!@8V]N<W1A;G1?3T-)7TQ/0B<Z#0I/0TDN>',Z,30U-CH@
M=V%R;FEN9SH@9&5C:6UA;"!C;VYS=&%N="!I<R!S;R!L87)G92!T:&%T(&ET
M(&ES('5N<VEG;F5D#0IE>'1R82YX<V@Z($EN(&9U;F-T:6]N(&!84U]/<F%C
M;&5?7T]#25]G971?;V-I7VAA;F1L92<Z#0IE>'1R82YX<V@Z,C,Z('=A<FYI
M;F<Z(&-A<W0@9G)O;2!P;VEN=&5R('1O(&EN=&5G97(@;V8@9&EF9F5R96YT
M('-I>F4-" F5X=')A+GAS:#H@26X@9
G5N8W1I;VX@8%A37T]R8
6-L95]?3T-)
M7V]C:5]B=69?;&5N)SH-" F5X=')A+GAS:#HU,3H@=
V%R;FEN9SH@87-S:6=N
M;65N="!F<F]M(&EN8V]M<&%T:6)L92!P;VEN=&5R('1Y<&4-"F5X=')A+GAS
M:#HU,CH@=V%R;FEN9SH
@87-S:6=N;65N="!F<F]M(&EN8V]M<&%T:6)L92!P
M;VEN=&5R('1Y<&4-" F5X=')A+GAS:#HU,SH@=
V%R;FEN9SH@8V%S="!F<F]M
M('!O:6YT97(@=&\@:6YT96=E<B!O9B!D:69F97)E;G0@<VEZ90T*9V-C("UC
M(" M22]C>6=D<FEV92]E+T]R86-L92]/< F$X,2]O8VDO:6YC;'5D9
2\@+4DO
M=7-R+VQI8B]P97)L-2]S:71E7W!E<FPO-2XX+C O8WEG=VEN+6UU;'1I+38
T
M:6YT+V%U=&\O1$)$+T]R86-L92 M22]U<W(O;&EB+W!E<FPU+W-I=&5?<&5R
M;"\U+C@N," ]C#0IY9W=I;BUM=6QT:2
TV-&EN="]A=71O+T1"22 M1%!%4DQ?
M55-%7U-!1D5?4%5414Y6("UF;F\M<W1R:6-T+6%L:6%S:6YG("U$55-%24U0
M3U)43$E"("UG(" @+41615)324]./5PB,"XP,5PB("U$6%-?5D524TE/3CU<
M(C N,#%<(B @(BU)+W5S<B]L:6(O<&5R;#4-"B\U+C@N,"]C>6=W:6XM;75L
M=&DM-C1I;G0O0T]212(@("U)+V- Y9V1R:79E+V4O3W)A8VQ
E+T]R83@Q+V]C
M:2]I;F-L=61E+R!U=&EL:71Y+F,-" G5T:6QI='DN8SH@26X@9
G5N8W1I;VX@
M8&]C:5]B=69?9V5T;6%X;&5N)SH-"G5T:6QI='DN8SHT-3H@=V%R;FEN9SH@
M8V%S="!T;R!P;VEN=&5R(&9R;VT@:6YT96=E<B!O9B!D:69F97)E;G0@<VEZ
M90T*=71I;&ET>2YC.B!);B!F=6YC=&EO;B!@;V- I7V)U9E]S971C=7)L96X
G
M.@T*=71I;&ET>2YC.C4U.B!W87)N:6YG.B!C87- T('1O('!O:6YT97(@9G)
O
M;2!I;G1E9V5R(&]F(&1I9F9E<F5N=" !S:7IE#0I2=6YN:6YG($
UK8F]O='-T
M<F%P(&9O<B!/<F%C;&4Z.D]#22 H*0T*8VAM;V0@-C0T($]#22YB<PT*<FT@
M+68@8FQI8B]A<F-H+V%U=&\O3W)A8VQE+T]#22]/0TDN9&QL#0I,1%]254Y?
M4$%42#TB+W5S<B]L:6(B(&QD,B @+7,@+4PO=7-R+VQO8V%L+VQI8B!/0TDN
M;R!U=&EL:71Y+F\@("UO(&)L:6(O87)C:"]A=71O+T]R86-L92]/0TDO3T-)
M+F1L;" @+W5S<B]L:6(O<&5R;#4O-2XX+C O8WEG=VEN+6UU;'1I+38
T:6YT
M+T-/4D4O;&D-"F)P97)L+F1L;"YA("UL;V-I#0IG8V,@+7-H87)E9" M;R @
M3T-)+F1L;" M5VPL+2UO=70M:6UP;&EB/6QI8D]#22YD;&PN82 M5VPL+2UE
M>'!O<G0M86QL+7-Y;6)O;',@+5=L+"TM96YA8FQE+6%U=&\M:6UP;W)T("U7
M;"PM+7-T86-K+#@S.#@V,#@@7 T*+7,@+4PO=7-R+VQO8V%L+VQI8B!/0TDN
M;R!U=&EL:71Y+F\@("]U<W(O;&EB+W!E<FPU+S4N."XP+V-Y9W=I;BUM=6QT
M:2TV-&EN="]#3U)%+VQI8G!E<FPN9&QL+F$@+6QO8VD-"D-R96%T:6YG(&QI
M8G)A<GD@9FEL93H@;&EB3T-)+F1L;"YA#0I/0TDN;R@N=&5X="LP>&8W8V8I
M.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)0VAA<E-E=$-O;G9E
M<G-I;VY)<U)E<&QA8V5M96YT57-E9"<Z#0HO:& ]M92]D879E+V]R85]O8V
DO
M;W)A8VQE+6]C:2]/<F%C;&4O3T-)+T]#22YC.C<X,S0Z('5N9&5F:6YE9"!R
M969E<F5N8V4@=&\@8%]/0TE#:&%R4V5T0V]N=F5R<VEO;DES4F5P;&%C96UE
M;G15<V5D)PT*3T-)+F\H+G1E> '0K,'AF9#=E*3H@26X@9
G5N8W1I;VX@8%A3
M7T]R86-L95]?3T-)7T]#24-H87)39714;U5N:6-O9&4G.@T*+VAO;64O9&%V
M92]O<F%?;V-I+V]R86- L92UO8VDO3W)A8VQE+T]
#22]/0TDN8SHW.#4U.B!U
M;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)0VAA<E-E=%1O56YI8V]D92<-
M"D]#22YO*"YT97AT*S!X,3$W,64I.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE
M7U]/0TE?3T-)0V]L;$ES3&]C871O<B<Z#0HO:& ]M92]D879E+V]R85]O8V
DO
M;W)A8VQE+6]C:2]/<F%C;&4O3T-)+T]#22YC.C<Y.30Z('5N9&5F:6YE9"!R
M969E<F5N8V4@=&\@8%]/0TE#;VQL27-,;V-A=&]R)PT*3T-)+F\H+G1E>'0K
M,'@Q-C,Q,"DZ($EN(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE%;G9#
M<F5A=&4G.@T*+VAO;64O9&%V92]O<F%?;V-I+V]R86-L92UO8VDO3W)A8VQE
M+T]#22]/0TDN8SHX,S<S.B!U;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)
M16YV0W)E871E)PT*3T-)+F\H+G1E>'0K,'@Q.6(U9BDZ($EN(&9U;F-T:6]N
M(&!84U]/<F%C;&5?7T]#25]/0TE,;V)#;&]S92<Z#0HO:&]M92]D879E+V]R
M85]O8VDO;W)A8VQE+6]
C:2]/<F%C;&4O3T-)+T]#22YC.C@V.#$Z('5N9&5F
M:6YE9"!R969E<F5N8V4@=&\@8%]/0TE,;V)#;&]S92<-"D]#22YO*"YT97AT
M*S!X,6$W83(I.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)3&]B
M0W)E871E5&5M<&]R87)Y)SH-" B]H;VUE+V1A=F4O;W)A7
V]C:2]O<F%C;&4M
M;V-I+T]R86-L92]/0TDO3T-)+F,Z.#<S- #H@=6YD969I;F5D(')E9
F5R96YC
M92!T;R!@7T]#24QO8D-R96%T951E;7!O<F%R>2<-"D]#22YO*"YT97AT*S!X
M,61B-F8I.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)3&]B1G)E
M951E;7!O<F%R>2<Z#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/
M<F%C;&4O3T-)+T]#22YC.CDP,C<Z('5N9&5F:6YE9"!R969E<F5N8V4@=&\@
M8%]/0TE,;V)&<F5E5&5M<&]R87)Y)PT*3T-)+F\H+G1E>'0K,'@Q9&8R82DZ
M($EN(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE,;V)'971#:'5N:U-I
M>F4G.@T*+VAO;64O9&%V92]O<F%?;V-I+V]R86- L92UO8VDO3W)A8VQE+T]
#
M22]/0TDN8SHY,#4P.B!U;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)3&]B
M1V5T0VAU;FM3:7IE)PT
*3T-)+F\H+G1E>'0K,'@Q96,Y."DZ($EN(&9U;F-T
M:6]N(&!84U]/<F%C;&5?7T]#25]/0TE,;V))<T]P96XG.@T*+VAO;64O9&%V
M92]O<F%?;V-I+V]R86- L92UO8VDO3W)A8VQE+T]
#22]/0TDN8SHY,3(U.B!U
M;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)3&]B27-/<&5N)PT*3T-)+F\H
M+G1E> '0K,'@Q9C$R82DZ($EN(
&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/
M0TE,;V))<U1E;7!O<F%R>2<Z#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE
M+6]C:2]/<F%C;&4O3T-)+T]#22YC.CDQ-3 Z('5N9&5F:6YE9"!R969E<F5N
M8V4@=&\@8%]/0TE,;V))<U1E;7!O<F%R>2<-"D]#22YO*"YT97AT*S!X,69A
M964I.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)3&]B3&]C871O
M<D%S<VEG;B<Z#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/<F%C
M;&4O3T-)+T]#22YC.CDR,#$Z('5N9&5F:6YE9"!R969E<F5N8V4@=&\@8%]/
M0TE,;V),;V-A=&]R07-S:6=N)PT*3T-)+F\H+G1E>'0K,'@R,#0W-RDZ($EN
M(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE,;V)/<&5N)SH-"B]H;VUE
M+V1A=F4O;W)A7V]C:2]
O<F%C;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z.3(U
M- 3H@=6YD969I;F5D(')E9
F5R96YC92!T;R!@7T]#2
4QO8D]P96XG#0I/0TDN
M;R@N=&5X="LP>#(R,3< P*3H@26X@9G5N8W1I;VX
@8%A37T]R86-L95]?3T-)
M7T]#24QO8E=R:71E07!
P96YD)SH-" B]H;VUE+V1A=F4O;W)A7
V]C:2]O<F%C
M;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z. 3,W,SH@=6YD969I;F5D(
')E9F5R
M96YC92!T;R!@7T]#24Q
O8E=R:71E07!P96YD)PT
*3T-)+F\H+G1E>'0K,'@R
M,S(W82DZ($EN(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE.;'-'971)
M;F9O)SH-" B]H;VUE+V1A=F4O;W)A7
V]C:2]O<F%C;&4M;V-I+T]R86-L92]/
M0TDO3T-)+F,Z.30U- #H@=6YD969I;F5D(')E9
F5R96YC92!T;R!@7T]#2
4YL
M<T=E=$EN9F\G#0I/0TDN;R@N=&5X="LP>#(U- 3AC*3H@26X@9G5N8W1I;
VX@
M8%A37T]R86-L95]?3T-)7T]#24YU;6)E<D1E8R<Z#0HO:&]M92]D879E+V]R
M85]O8VDO;W)A8VQE+6]
C:2]/<F%C;&4O3T-)+T]#22YC.CDW,# Z('5N9&5F
M:6YE9"!R969E<F5N8V4@=&\@8%]/0TE.=6UB97)$96,G#0I/0TDN;R@N=&5X
M="LP>#(W. 65C*3H@26X@9G5N8W1I;
VX@8%A37T]R86-L95]?3T-)7T]#24YU
M;6)E<DEN8R<Z#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/<F%C
M;&4O3T-)+T]#22YC.CDY,C@Z('5N9&5F:6YE9"!R969E<F5N8V4@=&\@8%]/
M0TE.=6UB97));F,G#0I/0TDN;R@N=&5X="LP>#(X,3 Y*3H@26X@9G5N8W1I
M;VX@8%A37T]R86-L95]?3T-)7T]#24YU;6)E<DES26YT)SH-"B]H;VUE+V1A
M=F4O;W)A7V]C:2]O<F%C;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z.3DW,SH@
M=6YD969I;F5D(')E9F5
R96YC92!T;R!@7T]#24Y
U;6)E<DES26YT)PT*3T-)
M+F\H+G1E>'0K,'@R.60Q8RDZ($EN(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#
M25]/0TE.=6UB97)0<F5C)SH-" B]H;VUE+V1A=F4O;W)A7
V]C:2]O<F%C;&4M
M;V-I+T]R86-L92]/0TDO3T-)+F,Z,3 Q-3@Z('5N9&5F:6YE9"!R969E<F5N
M8V4@=&\@8%]/0TE.=6UB97)0<F5C)PT*3T-)+F\H+G1E>'0K,'@R83,Y,"DZ
M($EN(&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE.=6UB97)39710:2<Z
M#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/<F%C;&4O3T-)+T]#
M22YC.C$P,C Q.B!U;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)3G5M8F5R
M4V5T4&DG#0I/0TDN;R@N=&5X="LP>#)A. #5E*3H@26X@9G5N8W1I;
VX@8%A3
M7T]R86-L95]?3T-)7T]#24YU;6)E<E-H:69T)SH-"B]H;VUE+V1A=F4O;W)A
M7V]C:2]O<F%C;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z,3 R,S0Z('5N9&5F
M:6YE9"!R969E<F5N8V4@=&\@8%]/0TE.=6UB97)3:&EF="<-"D]#22YO*"YT
M97AT*S!X,F%B8S<I.B!);B!F=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)
M3G5M8F5R4VEG;B<Z#0HO:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/
M<F%C;&4O3T-)+T]#22YC.C$P,C4V.B!U;F1E9FEN960@<F5F97)E;F-E('1O
M(&!?3T-)3G5M8F5R4VEG;B<-"D]#22YO*"YT97AT*S!X,F4R,C0I.B!);B!F
M=6YC=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)4F5S970G.@T*+VAO;64O9&%V
M92]O<F%?;V-I+V]R86- L92UO8VDO3W)A8VQE+T]
#22]/0TDN8SHQ,#4U,#H@
M=6YD969I;F5D(')E9F5
R96YC92!T;R!@7T]#25)
E<V5T)PT*3T-)+F\H+G1E
M> '0K,'@S,C0U8BDZ($EN(
&9U;F-T:6]N(&!84U]/<F%C;&5?7T]#25]/0TE4
M97)M:6YA=&4G.@T*+VAO;64O9&%V92]O<F%?;V-I+V]R86-L92UO8VDO3W)A
M8VQE+T]#22]/ 0TDN8SHQ,#@X,#H@=6YD
969I;F5D(')E9F5R96YC
92!T;R!@
M7T]#251E<FUI;F%T92<-"D]#22YO*"YT97AT*S!X,S-F-64I.B!);B!F=6YC
M=&EO;B!@6%-?3W)A8VQE7U]/0TE?3T-)56YI8V]D951O0VAA<E-E="<Z#0HO
M:& ]M92]D879E+V]R85]O8V
DO;W)A8VQE+6]C:2]/<F%C;&4O3T-)+T]#22YC
M.C$Q,#,X.B!U;F1E9FEN960@<F5F97)E;F-E('1O(&!?3T-)56YI8V]D951O
M0VAA<E-E="<-"D]#22YO*"YT97AT*S!X,S0V.3DI.B!);B!F=6YC=&EO;B!@
M6%-?3W)A8VQE7U]/0TE?3T-)57-E<D-A;&QB86-K1V5T)SH-"B]H;VUE+V1A
M=F4O;W)A7V]C:2]O<F%C;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z,3$P-C@Z
M('5N9&5F:6YE9"!R969E<F5N8V4@=&\@8%]/0TE5<V5R0V%L;&)A8VM'970G
M#0I/0TDN;R@N=&5X="LP>#,T9& (Q*3H@26X@9G5N8W1I;V
X@8%A37T]R86-L
M95]?3T- )7T]#255S97)#86QL8F%
C:U)E9VES=&5R)SH-"B]H;VUE+V1A=F4O
M;W)A7V]C:2]O<F%C;&4M;V-I+T]R86-L92]/0TDO3T-)+F,Z,3$Q,# Z('5N
M9&5F:6YE9"!R969E<F5N8V4@=&\@8%]/0TE5<V5R0V%L;&)A8VM296=I<W1E
M<B<-"F-O;&QE8W0R.B!L9"!R971U<FYE9" Q(&5X:70@<W1A='5S#0IP97)L
M;&0Z("HJ*B!S>7-T96TH*2!F86EL960@=&\@97AE8W5T90T*9V-C("US:&%R
M960@+6\@($]#22YD;&P@+5=L+"TM;W5T+6EM<&QI8CUL:6)/0TDN9&QL+F$@
M+5=L+"TM97AP;W)T+6%L;"US>6UB;VQS("U7;" PM+65N86)L92UA=71O+6
EM
M<&]R=" M5VPL+2US=&%C:RPX,S@X-C X(%P-"BUS("U,+W5S<B]L;V-A;"]L
M:6(@3T-)+F\@=71I;&ET>2YO(" O=7-R+VQI8B]P97)L-2\U+C@N,"]C>6=W
M:6XM;75L=&DM- C1I;G0O0T]212]L:6)P9
7)L+F1L;"YA("UL;V-I#0H-"FUA
M:V4Z("HJ*B!;8FQI8B]A<F-H+V%U=&\O3W)A8VQE+T]#22]/0TDN9&QL72!%
*<G)O<B Q#0H-"@``
`
end

Tim Bunce

2005-06-03, 8:27 pm

Hint: I'm very unlikely to read that. Far better to include the
text in the email (or attach it in a way that doesn't uuencode it).

Tim.

On Fri, Apr 04, 2003 at 06:35:14AM -0500, Dave K wrote:
> More progress...
> More errors. A partial list:
> collect2: ld returned 1 exit status
> perlld: *** system() failed to execute
> gcc -shared -o
>
> OCI.dll -Wl,--out-implib=libOCI.dll.a -Wl,--export-all-symbols -Wl,--enable-
> auto-import -Wl,--stack,8388608 \
> -s -L/usr/local/lib OCI.o utility.o
> /usr/lib/perl5/5.8.0/cygwin-multi-64int/CORE/libperl.dll.a -loci
>
> make: *** [blib/arch/auto/Oracle/OCI/OCI.dll] Error 1
> I did not want to offer a very large post so the rest is attached as
> list_oci.txt
> Thanks!
>
>
> begin 666 list_oci.txt
> M)" N+VUO9%]B;V]T#0IV+7-T<FEN9R!I;B!U<V4O<F5Q=6ER92!N;VXM<&]R
> M=&%B;&4@870@+B]M;V1?8F]O="!L:6YE(#,N#0H-"B!/<F%C;&4@:&]M92!I
> M<R!R97!O<G1E9"!T;R!B92 Z13HO3W)A8VQE+T]R83@
Q+PT*#0H@($]#22!)
> M;F-L=61E(')E<&]R=&5D('1O(&)E($4Z+T]R86-L92]/<F$X,2]O8VDO:6YC
> M;'5D92\-"@T*02!L:7-T:6YG(&]F('1H92!C;VYT96YT<R!F;VQL;W=S#0I$
> M:7)E8W1O<GDZ("]C>6=D<FEV92]E+T]R86-L92]/<F$X,2]O8VDO:6YC;'5D
> M92\-"D-$14U/1% P+D@-"DM54T%022Y(#0I+55-404=3+D@-"DY:15)23U(N
> M2 T*3EI4+D@-"D]#22Y(#0I/0TDQ+D@-"D]#23A$4"Y(#0I/0TE!4"Y(#0I/
> M0TE!4%(N2 T*3T-)1$5&+D@-"D]#241%32Y(#0I/0TE$1DXN2 T*3T-)15A4

Dave K

2005-06-04, 3:24 am

Tim (and anybody else that can point me in the right direction),
> Hint: I'm very unlikely to read that. Far better to include the
> text in the email (or attach it in a way that doesn't uuencode it).
Sorry about that. The Listing is fairly big and includes things I included
to deal with errors, identify things I wanted to modify and so on. The full
output of mod_boot is:

v-string in use/require non-portable at ./mod_boot line 3.

Oracle home is reported to be :E:/Oracle/Ora81/

OCI Include reported to be E:/Oracle/Ora81/oci/include/

A listing of the contents follows
Directory: /cygdrive/e/Oracle/Ora81/oci/include/
CDEMODP0.H
KUSAPI.H
KUSTAGS.H
NZERROR.H
NZT.H
OCI.H
OCI1.H
OCI8DP.H
OCIAP.H
OCIAPR.H
OCIDEF.H
OCIDEM.H
OCIDFN.H
OCIEXTP.H
OCIKP.H
OCIKPR.H
ODCI.H
ORATYPES.H
ORI.H
ORID.H
ORL.H
ORO.H
ORT.H
SX3.H
TNSAPI.H

Regex for h2xs ignores:
^OCI(? !AQ|AttrGet|Bind|Cac
he|Callback|CharSetC
onversionIsReplaceme
ntUsed|Cha
rSetToUnicode|CollIs
Locator|Complex|Cont
ext|Date|D
irPath|EnvCallback|E
nvCreate|Extract|Fil
e|Format|Interval|It
er|LobClose|LobC
reateTemporary|LobFr
eeTemporary|LobGetCh
unkSize|LobIsOpen|Lo
bIsTemporary|L
obLocatorAssign|LobO
pen|LobWriteAppend|M
emory|Message|MultiB
yte|NlsGetInfo|N
umberDec|NumberInc|N
umberIsInt|NumberPre
c|NumberSetPi|Number
Shift|NumberSi
gn|Object|Pickler|Ra
w|Ref|Reset|Security
|SharedLibInit|StmtB
indByName|StmtBi
ndByPos|StmtGetBindI
nfo|String|Subscript
ion|Table|Terminate|
Thread|Type|Ty
peArrayByName|TypeAr
rayByRef|UnicodeToCh
arSet|UserCallbackGe
t|UserCallbackRe
gister|WideChar|_FLA
GS|_FNCODE_|_NLS_|_O
RACLE|constant_OCI_L
OB)|^SQL
Complete h2xs arguments: ./h2xs -d -O -n
Oracle::OCI -F -I/cygdrive/e/Oracle/Ora81/oci/include/ -I/cygdrive/e/Oracle/
Ora81/oci/include/ -E get_oci_err
or,get_oci_handle,oc
i_buf_len,OCIAttrGet
-M
'^OCI(? !AQ|AttrGet|Bind|Cac
he|Callback|CharSetC
onversionIsReplaceme
ntUsed|Ch
arSetToUnicode|CollI
sLocator|C
omplex|Context|Date|
DirPath|EnvCallback|
EnvCreate|Extract|Fi
le|Format|Interv
al|Iter|LobClose|Lob
CreateTemporary|LobF
reeTemporary|LobGetC
hunkSize|LobIs
Open|LobIsTemporary|
LobLocatorAssign|Lob
Open|LobWriteAppend|
Memory|Message|M
ultiByte|NlsGetInfo|
NumberDec|NumberInc|
NumberIsInt|NumberPr
ec|NumberSetPi
|NumberShift|NumberS
ign|Object|Pickler|R
aw|Ref|Reset|Securit
y|SharedLibInit|
StmtBindByName|StmtB
indByPos|StmtGetBind
Info|String|Subscrip
tion|Table|Ter
minate|Thread|Type|T
ypeArrayByName|TypeA
rrayByRef|UnicodeToC
harSet|UserCallb
ackGet|UserCallbackR
egister|WideChar|_FL
AGS|_FNCODE_|_NLS_|_
ORACLE|constan
t_OCI_LOB)|^SQL' -k -x /cygdrive/e/Oracle/Ora81/OCI/INCLUDE/oci.h

Actual var sent to qx

../h2xs -d -O -n
Oracle::OCI -F -I/cygdrive/e/Oracle/Ora81/oci/include/ -I/cygdrive/e/Oracle/
Ora81/oci/include/ -E get_oci_error,get_oc
i_handle,oci_buf
_len,OCIAttrGet -M
'^OCI(? !AQ|AttrGet|Bind|Cac
he|Callback|CharSetC
onversionIsReplaceme
ntUsed|Ch
arSetToUnicode|CollI
sLocator|Complex|Con
text|Date|DirPa
th|EnvCallback|EnvCr
eate|Extract|File|Fo
rmat|Interval|Iter|L
obClose|LobCreat
eTemporary|LobFreeTe
mporary|LobGetChunkS
ize|LobIsOpen|LobIsT
emporary|LobLo
catorAssign|LobOpen|
LobWriteAppend|Memor
y|Message|MultiByte|
NlsGetInfo|Numbe
rDec|NumberInc|Numbe
rIsInt|NumberPrec|Nu
mberSetPi|NumberShif
t|NumberSign|O
bject|Pickler|Raw|Re
f|Reset|Security|Sha
redLibInit|StmtBindB
yName|StmtBindBy
Pos|StmtGetBindInfo|
String|Subscription|
Table|Terminate|Thre
ad|Type|TypeAr
rayByName|TypeArrayB
yRef|UnicodeToCharSe
t|UserCallbackGet|Us
erCallbackRegist
er|WideChar|_FLAGS|_
FNCODE_|_NLS_|_ORACL
E|constant_OCI_LOB)|
^SQL' -k -x /c
ygdrive/e/Oracle/Ora81/OCI/INCLUDE/oci.h
Running h2xs...
Scanning typemaps...
Scanning /usr/lib/perl5/5.8.0/ExtUtils/typemap
Scanning /cygdrive/e/Oracle/Ora81/OCI/INCLUDE/oci.h for functions...
Scanning /cygdrive/e/Oracle/Ora81/OCI/INCLUDE/oci.h for typedefs...
Writing Oracle/OCI/OCI.pm
Writing Oracle/OCI/OCI.xs
Writing Oracle/OCI/typemap
Writing Oracle/OCI/Makefile.PL
Writing Oracle/OCI/test.pl
Writing Oracle/OCI/Changes
Writing Oracle/OCI/MANIFEST
Editing OCI.xs...
Editing Makefile.PL...
Building...
Using DBI 1.32 installed in
/usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/auto/DBI
Checking if your kit is complete...
Looks good
Writing Makefile for Oracle::OCI
cp OCI.pm blib/lib/Oracle/OCI.pm
AutoSplitting blib/lib/Oracle/OCI.pm (blib/lib/auto/Oracle/OCI)
/usr/bin/perl.exe /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8.0/ExtUtils/typemap -typemap h2xs.typemap -typemap typemap
OCI.xs
> OCI.xsc && mv OCI.xsc OCI.c
Please specify prototyping behavior for OCI.xs (see perlxs manual)
gcc -c -I/cygdrive/e/Oracle/Ora81/oci/include/ -I/usr/lib/perl5/site_perl/5
..8.0/cygwin-multi-64int/auto/DBD/Oracle -I/usr/lib/perl5/site_perl/5.8.0/c
ygwin-multi-64int/auto/DBI - DPERL_USE_SAFE_PUTEN
V -fno-strict-aliasing -DUSE
IMPORTLIB -g -DVERSION=\"0.01\" -DXS_VERSION=\"0.01\" "-I/usr/lib/perl5
/5.8.0/cygwin-multi-64int/CORE" -I/cygdrive/e/Oracle/Ora81/oci/include/
OCI.c
OCI.xs: In function `constant_OCI_LOB':
OCI.xs:1456: warning: decimal constant is so large that it is unsigned
extra.xsh: In function `XS_Oracle__OCI_get_
oci_handle':
extra.xsh:23: warning: cast from pointer to integer of different size
extra.xsh: In function `XS_Oracle__OCI_oci_
buf_len':
extra.xsh:51: warning: assignment from incompatible pointer type
extra.xsh:52: warning: assignment from incompatible pointer type
extra.xsh:53: warning: cast from pointer to integer of different size
gcc -c -I/cygdrive/e/Oracle/Ora81/oci/include/ -I/usr/lib/perl5/site_perl/5
..8.0/cygwin-multi-64int/auto/DBD/Oracle -I/usr/lib/perl5/site_perl/5.8.0/c
ygwin-multi-64int/auto/DBI - DPERL_USE_SAFE_PUTEN
V -fno-strict-aliasing -DUSE
IMPORTLIB -g -DVERSION=\"0.01\" -DXS_VERSION=\"0.01\" "-I/usr/lib/perl5
/5.8.0/cygwin-multi-64int/CORE" -I/cygdrive/e/Oracle/Ora81/oci/include/
utility.c
utility.c: In function `oci_buf_getmaxlen':

utility.c:45: warning: cast to pointer from integer of different size
utility.c: In function `oci_buf_setcurlen':

utility.c:55: warning: cast to pointer from integer of different size
Running Mkbootstrap for Oracle::OCI ()
chmod 644 OCI.bs
rm -f blib/arch/auto/Oracle/OCI/OCI.dll
LD_RUN_PATH="/usr/lib" ld2 -s -L/usr/local/lib OCI.o utility.o -o
blib/arch/auto/Oracle/OCI/OCI.dll
/usr/lib/perl5/5.8.0/cygwin-multi-64int/CORE/li
bperl.dll.a -loci
gcc -shared -o

OCI.dll -Wl,--out-implib=libOCI.dll.a -Wl,--export-all-symbols -Wl,--enable-
auto-import -Wl,--stack,8388608 \
-s -L/usr/local/lib OCI.o utility.o
/usr/lib/perl5/5.8.0/cygwin-multi-64int/CORE/libperl.dll.a -loci
Creating library file: libOCI.dll.a
mv OCI.dll libOCI.dll.a blib/arch/auto/Oracle/OCI/
chmod 755 blib/arch/auto/Oracle/OCI/OCI.dll
cp OCI.bs blib/arch/auto/Oracle/OCI/OCI.bs
chmod 644 blib/arch/auto/Oracle/OCI/OCI.bs
Manifying blib/man3/Oracle.OCI.3pm
/usr/bin/perl.exe "- MExtUtils::Command::
MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base....Can't load
'/home/dave/ORA_OCI/Oracle-OCI/Oracle/OCI/blib/arch/auto/Oracle/OCI/OCI.dll'
for module Oracle::OCI: dlopen: Win32 error 127 at
/usr/lib/perl5/5.8.0/cygwin-multi-64int/DynaLoader.pm line 229.
at t/01base.t line 9
Compilation failed in require at t/01base.t line 9.
BEGIN failed--compilation aborted at t/01base.t line 9.
t/01base....dubious
Test returned status 255 (wstat 65280, 0xff00)
t/05dbi.....Can't load
'/home/dave/ORA_OCI/Oracle-OCI/Oracle/OCI/blib/arch/auto/Oracle/OCI/OCI.dll'
for module Oracle::OCI: dlopen: Win32 error 127 at
/usr/lib/perl5/5.8.0/cygwin-multi-64int/DynaLoader.pm line 229.
at t/05dbi.t line 8
Compilation failed in require at t/05dbi.t line 8.
BEGIN failed--compilation aborted at t/05dbi.t line 8.
t/05dbi.....dubious
Test returned status 255 (wstat 65280, 0xff00)
FAILED--2 test scripts could be run, alas--no output ever seen
make: *** [test_dynamic] Error 2

Thanks
David

Dave K

2005-06-04, 3:24 am

Tim, Gerrit, and Anybody with an idea of how I can push this forward.
I am trying to run the boot script on WinNT with cygwin. DBD::Oracle was
compiled on this machine
with perl 5.8.0.
To keep the posts short (and not burden those who are not intrested) I have
a 'blow by blow'
account of my attempt posted at.
http://geocities.com/k2001evad/oci.txt
One of the more vexing problems I was having stemmed from upgrading some
portion of my system:
dlopen: Win32 error 127
Which reared its head again when I was redoing some of the exercises from
the XS tutorial. This prompted me to restart 'from scratch' with the OCI
attempt. I opted to track the attempt 'operation by operation' so it might
be useful to others trying to do the same thing. The current state of the
effort is 2 steps short of where I had been earlier. This is where I throw
caution to the wind and dive into that portion of the boot script marked
'High Voltage'...
Any hints, help or pointers appreciated.
David

Sponsored Links