Re: Oracle OCI question

From: (wrong string) çon <marc_melancon_at_bmc.com>
Date: Wed, 19 Sep 2001 20:45:16 -0500
Message-ID: <yTbq7.4174$qR1.345220_at_weber.videotron.net>

Cdemo5.c from the 8i oci samples....

MarcM

begin 666 Cdemo5.c

M(VEF9&5F(%)#4TE$#0IS=&%T:6,_at_8VAA<B J4D-3:60@/2 -"B @("(D2&5A
M9&5R.B!C9&5M;S4N8R R,BUA=6<M.3<N,30Z,#DZ-#_at__at_96AA>65S($5X<" D
M("([#0HC96YD:68_at_+RH_at_4D-3240@*B\-"@T*+RH_at_0V]P>7)I9VAT("AC*2 Q

M.3DU+" Q.3DV+" Q.3DW(&)Y($]R86-L92!#;W)P;W)A=&EO;B J+PT*+RHM" B _at_($Y!344-"B @(" @8V1E;6\U+F,@+2!A('-M86QL(&5X86UP;&4@;V8@

M=7-E(&]F('9A<FEA8FQE(&-U<G-O<G,-"B _at_($U/1$E&245$(" @*$U-+T1$
M+UE9*0T*(" _at_(&5H87EE<R @(" @,#4O,CDO.3<@+2 @1FEX(&]L:6YT(&5R
M<F]R<PT*(" _at_(&%Z:&%O(" @(" @,#4O,38O.3<@+2 @8VAA;F=E('5B,2!T
M;R!U8C0_at_9F]R(&AS=&(-"B @("!D8VAA='1E<B @(# W+S$U+SDV("T@(&AD
M82!I<R!A('5B-"!A<G)A>2!T;R!P<F5V96YT(&)U<R!E<G)O<_at_T*(" @('!L
M;V-K92 _at_(" @,3$O,3_at_O.34@+2 @=&\@=7!D871E(&9O<B!V-RXS#0H@(" @
M<VQA<FD_at_(" @(" P-"\R-2\Y-2 M("!M97)G92!C:&%N9V5S(&9R;VT_at_8G)A
M;F-H(#$N,2XW,C N,0T*(" _at_('-L87)I(" @(" @,#0O,C O.34@+2 @0G)A

M;F-H7V9O<E]P871C: T*(" _at_('-L87)I(" @(" @,#0O,3DO.34@+2 @<F5P M;&%C92!O<FQO;B!W:71H(&]L;V<-"B _at_("!P=F%S=&5R9" @(#$P+S(P+SDT M("T_at_($-H86YG97,@=&\@8G)I;F<@:6YT;R!L:6YE('=I=&@@;W1H97(@8V1E M;6]S#0H_at_(" @9&-H871T97(@(" Q,"\Q-R\Y-" M("!#<F5A=&EO;@T*("HO M#0HO*_at_T*("H@(" @("TM(&-D96UO-2YC("TM#0H@*_at_T*("H@($%N(&5X86UP M;&4_at_<')O9W)A;2!W:&EC:"!D96UO;G-T<F%T97,@=&AE('5S92!O9_at_T*("H@ M(%9A<FEA8FQE($-U<G-O<G,_at_:6X_at_86X@3T-)('!R;V=R86TN#0H@*_at_T*("HO M#0H-"B-I;F-L=61E(#QS=&1I;RYH/_at_T*(VEN8VQU9&4@/'-T9&QI8BYH/_at_T* M(VEN8VQU9&4_at_/&-T>7!E+F@^#0HC:6YC;'5D92 \;W)A='EP97,N:#X-"B-I M;F-L=61E(#QO8VED9FXN:#X-"B-I;F-L=61E(#QO8VEK<'(N:#X-"_at_T*("\J M(&]P87)S92!F;&%G<R J+PT*(V1E9FEN92!$149%4E]005)312 Q#0HC9&5F M:6YE(%9%4E-)3TY?-R R#0H-"B-D969I;F4_at_3E!/4R Q-_at_T*(V1E9FEN92!$ M4T-,14X_at_,C0P#0H-"G1E>'0@*G5S97)N86UE(#T@*'1E>'0@*BD@(E-#3U14 M(CL-"G1E>'0_at_*G!A<W-W;W)D(#T@*'1E>'0@*BD@(E1)1T52(CL-"@T*<W1A

M=&EC("!S=V]R9"!R971V86P[#0IS=&%T:6,_at_('5B-" @(&AS=&);-3$R73L-
M"G-T871I8R _at_=&5X=" @97)R;W)B6S0P.35=.PT*<W1A=&EC("!T97AT("!C
M8G5F6TY03U-=6T130TQ%3ET[#0IS=&%T:6,_at_('-B-" @(&-B=69L6TY03U-=
M.PT*<W1A=&EC("!S8C0_at_("!D8G-I>F5;3E!/4UT[#0IS=&%T:6,@('-B-" @
M(&1S:7IE6TY03U-=.PT*<W1A=&EC("!S8C(_at_("!D8G1Y<&5;3E!/4UT[#0IS

M=&%T:6,_at_('-B,B @('!R96-;3E!/4UT[#0IS=&%T:6,@('-B,B @('-C86QE M6TY03U-=.PT*<W1A=&EC("!S8C(_at_("!N=6QL;VM;3E!/4UT[#0H@#0IS=&%T M:6,_at_3&1A7T1E9B!L9&$Q.PT*#0IS=&%T:6,@=&5X="!P;'-Q;%]B;&]C:UM= M(#T_at_#0H@(" @(" B8F5G:6X_at_7 T*"2 @3U!%3B Z8W5R<V]R,2!&3U(@<V5L M96-T(&5M<&YO+"!E;F%M92P_at_:F]B+"!M9W(L(&AI<F5D871E+'-A;"QD97!T M;F]<#0H_at_(" @(" @(" @(" @("!F<F]M(&5M<"!W:&5R92!J;V(].FIO8B!O M<F1E<B!B>2!E;7!N;SM<#0H_at_(" @("!E;F0[(CL-"@T*+RH_at_0TQ)14Y4($-5

M4E-/4E,_at_*B\-"G-T871I8R!#9&%?1&5F(&-U<G-O<BP_at_8W5R<V]R7V5M<#L-
M"_at_T*+RH_at_4')O=&]T>7!E("HO#0IV;VED(&]R86-L95]E<G)O<B_at_I.PT*#0II
M;G0_at_;6%I;B H*0T*>PT*("!,9&%?1&5F("IL9&%P(#T@)FQD83$[#0H-"B @

M=6(T(" _at_(&5M<&YO.PT*("!T97AT(" @96YA;65;,3%=.PT*("!T97AT(" @ M:F]B6S$P73L-"B _at_=6(T(" @(&UG<CL-"B @=&5X=" @(&AI9&%T95LQ,%T[ M#0H_at_('5B-" @("!S86P[#0H@('5B-" @("!D97!T;F\[#0H@(&EN=" @("!I M.R _at_#0H@('1E>'0@("!J;V)?:VEN9%LU,%T[#0H@('5B-" @("!P;W,[#0H@ M( T*("!S=')C<'DH*&-H87(_at_*BD@:F]B7VMI;F0L(")!3D%,65-4(BD[#0H@ M(&9P<FEN=&8H<W1D;W5T+")<;EQN1D540TA)3D<_at_9F]R(&IO8CTE<UQN7&XB M+&IO8E]K:6YD*3L-"_at_T*(" O*B -"B @("H_at_0V]N;F5C="!T;R!/<F%C;&4@

M87,_at_4T-/5%0O5$E'15(N#0H@(" J($5X:70@;VX_at_86YY(&5R<F]R+_at_T*(" @
M*B\-"B _at_#0H@(&EF("AO;&]G*&QD87 L("AU8C$@*BEH<W1B+"!U<V5R;F%M
M92P_at_+3$L('!A<W-W;W)D+" M,2P-"B @(" @(" @(" @*'1E>'0@*BD@,"P@

M+3$L("AU8C0I3T-)7TQ-7T1%1BDI#0H_at_('L@( T*(" @(" @<')I;G1F*")5 M;F%B;&4_at_=&\@8V]N;F5C="!A<R E<UQN(BP@=7-E<FYA;64I.PT*(" @(" @ M97AI="A%6$E47T9!24Q54D4I.PT*("!]#0H_at_('!R:6YT9B_at_B0V]N;F5C=&5D M('1O($]R86-L92!A<R E<UQN7&XB+"!U<V5R;F%M92D[#0H_at_#0H@("\J#0H@

M(" J($]P96X_at_82!C=7)S;W(@9F]R(&5X96-U=&EN9R!T:&4_at_4$PO4U%,(&)L
M;V-K+_at_T*(" @*B\-"@T*("!I9B H;V]P96XH)F-U<G-O<BP@;&1A<"P@*'1E
M>'0_at_*BD@,"P@+3$L(# L("AT97AT("HI(# L("TQ*2D-"B @>PT*(" @("!O

M<F%C;&5?97)R;W(H)F-U<G-O<BD[#0H_at_(" @(&5X:70H15A)5%]&04E,55)% M*3L-"B _at_?0T*( T*(" O*_at_T*(" @*B!087)S92!T:&4_at_4$PO4U%,(&)L;V-K M+_at_T*(" @*B\-"@T*("!I9B H;W!A<G-E*"9C=7)S;W(L('!L<W%L7V)L;V-K M+" H<V(T*2 M,2P_at_*'-W;W)D*2!44E5%+" H=6(T*2 R*2D-"B @>PT*(" @ M("!O<F%C;&5?97)R;W(H)F-U<G-O<BD[#0H_at_(" @(&5X:70H15A)5%]&04E, M55)%*3L-"B _at_?0T*#0H@("\J#0H@(" J($)I;F0_at_82!V87)I86)L92!O9B!C M=7)S;W(_at_9&%T871Y<&4L('1H92!C=7)S;W(@=VEL;"!B92!O<&5N960-"B @

M("H_at_:6YS:61E('1H92!03"]344P_at_8FQO8VLN#0H@(" J+PT*#0H@(&EF("AO
M8FYD<F$H)F-U<G-O<BP_at_*'1E>'0@*BD@(CIC=7)S;W(Q(BP@+3$L("AU8C$@
M*BD_at_)F-U<G-O<E]E;7 L( T*(" @(" @(" @(" @("TQ+"!344Q47T-54BP@

M+3$L("AS8C(_at_*BD@,"P@*'5B,B J*2 P+" H=6(R("HI(# L#0H@(" @(" @ M(" _at_(" @*'5B-"D@,"P@*'5B-" J*2 P+" H=&5X=" J*2 P+" P+" P*2DM" B _at_>PT*(" @("!O<F%C;&5?97)R;W(H)F-U<G-O<BD[#0H@(" @(&5X:70H M15A)5%]&04E,55)%*3L-"B _at_?0T*#0H@("\J#0H@(" J($)I;F0_at_82!V87)I M86)L92!O9B!S=')I;F<_at_9&%T871Y<&4N#0H@(" J+PT*#0H@(&EF("AO8FYD M<F$H)F-U<G-O<BP_at_*'1E>'0@*BD@(CIJ;V(B+" M,2P@*'5B,2 J*2!J;V)?

M:VEN9"P_at_#0H@(" @(" @(" @(" @+3$L(%-13%1?4U12+" M,2P@*'-B,B J
M*2 P+" H=6(R("HI(# L("AU8C(_at_*BD@,"P-"B @(" @(" @(" @(" H=6(T
M*2 P+" H=6(T("HI(# L("AT97AT("HI(# L(# L(# I*0T*("![#0H_at_(" @

M(&]R86-L95]E<G)O<B_at_F8W5R<V]R*3L-"B @(" @97AI="A%6$E47T9!24Q5 M4D4I.PT*("!]#0H-"B _at_+RH@#0H@(" J($5X96-U=&4@=&AE(%!,+U-13"!B M;&]C:RX-"B _at_("HO#0H-"B @(&EF("AO97AE8R_at_F8W5R<V]R*2D-"B @('LM" B _at_(" @(&]R86-L95]E<G)O<B_at_F8W5R<V]R*3L-"B @(" @(&5X:70H15A)

M5%]&04E,55)%*3L-"B _at_('T-"@T*(" O*_at_T*(" @*B!#;&]S92!T:&4_at_8W5R
M<V]R(&]N('=H:6-H('1H92!03"]344P_at_8FQO8VL_at_97AE8W5T960N#0H@(" J
M+PT*#0H_at_(&EF("AO8VQO<V4H)F-U<G-O<BDI#0H@('L-"B @(" @;W)A8VQE

M7V5R<F]R*"9C=7)S;W(I.PT*(" _at_("!E>&ET*$58251?1D%)3%5212D[#0H@ M('T-"_at_T*(" O*B -"B @("H_at_1&\@9&5S8W)I8F4@;VX_at_8W5R<V]R(&EN:71I M86QI>F5D(&%N9"!R971U<FYE9"!F<F]M('1H92!03"]344P_at_8FQO8VLN#0H@ M(" J+PT*#0H_at_(&9O<B H<&]S(#T@,#L@<&]S(#P_at_3E!/4SL@<&]S*RLI#0H@ M('L-"B _at_(" @8V)U9FQ;<&]S72 ]($130TQ%3CL-"B @(" @:68@*&]D97-C M<B_at_F8W5R<V]R7V5M<"P@*'-W;W)D*2 H<&]S*S$I+" F9&)S:7IE6W!O<UTL M("9D8G1Y<&5;<&]S72P-"B _at_(" @(" @(" @(" @(" H<V(Q("HI(&-B=69; M<&]S72P_at_)F-B=69L6W!O<UTL("9D<VEZ95MP;W-=+ T*(" @(" @(" @(" @

M(" _at_("9P<F5C6W!O<UTL("9S8V%L95MP;W-=+" F;G5L;&]K6W!O<UTI*0T*
M(" _at_("![#0H@(" @(" @(&EF("AC=7)S;W)?96UP+G)C(#T](#$P,#<I#0H@
M(" _at_(" @(" @(&)R96%K.PT*(" @(" @("!O<F%C;&5?97)R;W(H)F-U<G-O

M<E]E;7 I.PT*(" _at_(" @("!E>&ET*$58251?1D%)3%5212D[#0H@(" @('TM" B _at_?0T*#0H@('!R:6YT9B_at_B1&5S8W)I8F4@<V5L96-T+6QI<W0@<F5T=7)N M<SI<;EQN(BD[#0H_at_('!R:6YT9B_at_B+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+5QN(BD[#0H_at_('!R:6YT9B_at_B271E;5QT7'1-87A3 M:7IE7'1<=%1Y<&5<;B(I.PT*("!P<FEN=&8H(BTM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2U<;B(I.PT*("!F;W(_at_*&D@/2 P.R!I M(#P_at_<&]S.R!I*RLI#0H@('L-"B @(" @8V)U9EMI75MC8G5F;%MI75T@/2 G M7# G.PT*(" _at_("!P<FEN=&8H(B5S7'1<="5D7'1<="5D7&XB+"!C8G5F6VE= M+"!D8G-I>F5;:5TL(&1B='EP95MI72D[#0H_at_('T-"@T*(" O*B -"B @("H@

M1&\_at_8VQI96YT(&1E9FEN97,N#0H@(" J+PT*#0H@(&EF("AO9&5F:6XH)F-U
M<G-O<E]E;7 L(#$L("AU8C$_at_*BD@)F5M<&YO+" H<W=O<F0I('-I>F5O9BAU
M8C0I+"!344Q47TE.5"P_at_#0H@(" @(" @(" @(" @+3$L("AS8C(@*BD@+3$L

M("AT97AT("HI(# L("AS=V]R9"D_at_,"P@*'-W;W)D*2 P+" H=6(R("HI(# L M#0H_at_(" @(" @(" @(" @*'5B,B J*2 P*2D-"B @>PT*(" @("!O<F%C;&5? M97)R;W(H)F-U<G-O<E]E;7 I.PT*(" _at_("!E>&ET*$58251?1D%)3%5212D[ M#0H_at_('T-"@T*(" @:68@*&]D969I;B_at_F8W5R<V]R7V5M<"P@,BP@*'5B,2 J M*2!E;F%M92P_at_*'-W;W)D*2!S:7IE;V8H96YA;64I+" -"B @(" @(" @(" @

M(" _at_4U%,5%]35%(L("TQ+" H<V(R("HI("TQ+" H=&5X=" J*3 L("AS=V]R
M9"D_at_,"P@*'-W;W)D*2 P+" -"B @(" @(" @(" @(" @*'5B,B J*2 P+" H
M=6(R("HI(# I*0T*(" _at_>PT*(" @(" @;W)A8VQE7V5R<F]R*"9C=7)S;W)?

M96UP*3L-"B _at_(" @(&5X:70H15A)5%]&04E,55)%*3L-"B @('T-"@T*("!I M9B H;V1E9FEN*"9C=7)S;W)?96UP+" S+" H=6(Q("HI(&IO8BP_at_*'-W;W)D M*2!S:7IE;V8H:F]B*2P_at_#0H@(" @(" @(" @(" @4U%,5%]35%(L("TQ+" H M<V(R("HI("TQ+" H=&5X=" J*2 P+" H<W=O<F0I(# L("AS=V]R9"D_at_,"P@ M#0H_at_(" @(" @(" @(" @*'5B,B J*2 P+" H=6(R("HI(# I*0T*(" @>PT* M(" _at_(" @;W)A8VQE7V5R<F]R*"9C=7)S;W)?96UP*3L-"B @(" @(&5X:70H M15A)5%]&04E,55)%*3L-"B _at_('T-"@T*("!I9B H;V1E9FEN*"9C=7)S;W)? M96UP+" T+" H=6(Q("HI)FUG<BP_at_*'-W;W)D*2!S:7IE;V8H=6(T*2P_at_4U%,

M5%])3E0L( T*(" _at_(" @(" @(" @("TQ+" H<V(R("HI("TQ+" H=&5X=" J
M*3 L("AS=V]R9"D_at_,"P@*'-W;W)D*2 P+" H=6(R("HI(# L#0H@(" @(" @
M(" _at_(" @*'5B,B J*2 P*2D-"B @('L-"B @(" @(&]R86-L95]E<G)O<B_at_F

M8W5R<V]R7V5M<"D[#0H_at_(" @("!E>&ET*$58251?1D%)3%5212D[#0H@("!] M#0H-"B _at_:68@*&]D969I;B_at_F8W5R<V]R7V5M<"P_at_-2P@*'5B,2 J*6AI9&%T M92P_at_*'-W;W)D*2!S:7IE;V8H:&ED871E*2P@#0H@(" @(" @(" @(" @4U%,

M5%]35%(L("TQ+" H<V(R("HI("TQ+" H=&5X=" J*2 P+" H<W=O<F0I(# L
M("AS=V]R9"D_at_,"P@#0H@(" @(" @(" @(" @*'5B,B J*2 P+" H=6(R("HI
M(# I*0T*(" _at_>PT*(" @(" @;W)A8VQE7V5R<F]R*"9C=7)S;W)?96UP*3L-

M"B _at_(" @(&5X:70H15A)5%]&04E,55)%*3L-"B @('T-"@T*(" @:68@*&]D M969I;B_at_F8W5R<V]R7V5M<"P_at_-BP@*'5B,2 J*2 F<V%L+" H<W=O<F0I('-I M>F5O9BAU8C0I+"!344Q47TE.5"P_at_#0H@(" @(" @(" @(" @("TQ+" H<V(R M("HI("TQ+" H=&5X=" J*2 P+" H<W=O<F0I(# L("AS=V]R9"D_at_,"P@*'5B M,B J*2 P+ T*(" _at_(" @(" @(" @(" H=6(R("HI(# I*0T*(" @>PT*(" @ M(" _at_;W)A8VQE7V5R<F]R*"9C=7)S;W)?96UP*3L-"B @(" @(&5X:70H15A) M5%]&04E,55)%*3L-"B _at_('T-"@T*(" @:68@*&]D969I;B_at_F8W5R<V]R7V5M M<"P_at_-RP@*'5B,2 J*2 F9&5P=&YO+" H<W=O<F0I('-I>F5O9BAD97!T;F\I

M+" -"B _at_(" @(" @(" @(" @4U%,5%])3E0L("TQ+" H<V(R("HI("TQ+" H
M=&5X=" J*2 P+" H<W=O<F0I(# L("AS=V]R9"D_at_,"P@#0H@(" @(" @(" @
M(" _at_("AU8C(@*BD@,"P@*'5B,B J*2 P*2D-"B @('L-"B @(" @(&]R86-L

M95]E<G)O<B_at_F8W5R<V]R7V5M<"D[#0H@(" @("!E>&ET*$58251?1D%)3%52 M12D[#0H_at_("!]#0H-"B @<')I;G1F*")<;D9%5$-((&9R;VT@=F%R:6%B;&4@ M8W5R<V]R.EQN7&XB*3L-"B _at_<')I;G1F*"(M+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2U<;B(I M.PT*("!P<FEN=&8H(F5M<&YO7'1E;F%M95QT:F]B7'1M9W)<=&AI<F5D871E M7'1S86QA<GE<=&1E<'1<;B(I.PT*("!P<FEN=&8H(BTM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM

M+5QN(BD[#0H-"B _at_+RH@#0H@(" J($YO=R!F971C:"!T:&4@<F5S=6QT('-E
M="!A;F0_at_9&ES<&QA>2X-"B @("HO#0H-"B @=VAI;&4@*#$I#0H@('L-"B @
M("!S8C0_at_97)R(#T@,#L-"@T*(" @(&EF("AE<G(@/2!O9F5T8V_at_H)F-U<G-O
M<E]E;7 I*0T*(" _at_('L-"B @(" @(&EF("AC=7)S;W)?96UP+G)C(#T](#$T
M,#,I#0H_at_(" @(" @("!B<F5A:SL-"B @(" @(&5L<V4@#0H@(" @("![#0H@
M(" _at_(" @("!O<F%C;&5?97)R;W(H)F-U<G-O<E]E;7 I.PT*(" @(" @(" @
M97AI="A%6$E47T9!24Q54D4I.PT*(" _at_(" @?0T*(" @('T-"B @("!E;'-E

M( T*(" _at_('L-"B @(" @("\J($$@<F]W('=A<R!R971U<FYE9#L@:&%V92!T M;R!D;R!T:&4_at_9F5T8V_at_N("HO#0H@(" @("!F<')I;G1F*'-T9&]U="P@(B5D M7'0E<UQT)7-<="5D7'0E<UQT)61<="5D7&Y<;B(L#0H_at_(" @(" @(" @(" @

M(&5M<&YO+"!E;F%M92P_at_:F]B+"!M9W(L(&AI9&%T92P@<V%L+"!D97!T;F\I
M.PT*(" _at_('T-"B @?0T*#0H@("\J( T*(" @*B!,;V<@;V9F+_at_T*(" @*B\-
M"_at_T*("!I9B H;VQO9V]F*&QD87 I*0T*("![#0H@(" @(&]R86-L95]E<G)O

M<B_at_F8W5R<V]R7V5M<"D[#0H@(" @(&5X:70H15A)5%]&04E,55)%*3L-"B @

M?0T*?2 O*B!E;F0_at_;V8@;6%I;B J+PT*#0IV;VED(&]R86-L95]E<G)O<BAL
M9&$I#0I,9&%?1&5F("H_at_;&1A.PT*>PT*("!C:&%R(&US9V)U9ELU,3)=.PT*
M("!I;G0_at_;CUO97)H;7,H;&1A+"!L9&$M/G)C+" H=&5X=" J*6US9V)U9BP@

M*&EN="D_at_<VEZ96]F*&US9V)U9BD@*3L-"B @( T*("!P<FEN=&8H(EQN7&XE ;+BIS7&XB+&XL;7-G8G5F*3L-"GT-"_at_T*( T* `
end Received on Thu Sep 20 2001 - 03:45:16 CEST