Re: Stored Procedures : How to get a reasult set back ( Multiple Rows )

Here is a PB example to retrieve into a datawindow. You might want to use the Powerbuilder newsgroup, found on news server forums.sybase.com

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Yahoo wrote in message <81io44$4vn$1_at_clematis.singnet.com.sg>...


>Hi ,

>

>Can anyone please help me out on this one ??


>

>I am using PB 7.0 as a frontend and Oracle 8.0.4 as backend. I want to get

a


>set of rows into the PB program from a oracle stored procedure.


>Is this possible ? Can I get a set of rows out of the procedure at a single

>go or do I have to call the stored procedure again and again for each row I

>want to retrieve.

>

>Any help will be appreciated.

>TIA

>

>Yahoo.

>

>



begin 666 sp_as_source_for_dw.sql
M+2T_at_3F%M93H@<W!?87-?<V]U<F-E7V9O<E]D=RYS<6P-"BTM($%U=&AO<CH@
M5&5R<GD_at_1'EK<W1R82!;5&5A;5!370T*+2T@(" @(" @("!#86YA9&EA;B!&
M;W)E<W0_at_3VEL($QT9"X-"BTM($1A=&4Z(#$Y.3_at_O,#4O,#D-"BTM(%)E<75I
M<F5M96YT<SH_at_3W)A8VQE(#<N,B!O<B!L871E<@T*+2T_at_3F]T97,Z(%EO=2!D
M969I;F4_at_82!P86-K86=E(&AE861E<B!T:&%T('5S97,_at_82!R968_at_8W5R<V]R
M+_at_T*+2T_at_5&AE;B!Y;W4_at_8W)E871E(&$@<W1A;F0M86QO;F4@<')O8V5D=7)E
M('1H870_at_<F5F97)E;F-E<R!T:&4@<F5S=6QT('-E="!D969I;F5D(&EN('1H
M92!P86-K86=E(&AE861E<BX-"BTM($YO=R!C<F5A=&4_at_82!D871A=VEN9&]W
M('5S:6YG('-T;W)E9"!P<F]C961U<F4_at_87,@<V]U<F-E(&%N9"!S96QE8W0@
M=&AE('!R;V-E9'5R90T*+2T_at_4V5T=&EN9W,Z(" )1$)087)M(%!"1$)-4STP
M#0HM+2!/<F%C;&4_at_<')I=FEL96=E<SH_at_86YY(&]F($5814-55$4_at_04Y9(%!2
M3T-%1%5212P_at_0U)%051%(%!23T-%1%5212P_at_0U)%051%($%.62!04D]#1415
M4D4L(&1E<&5N9&EN9R -"BTM(&]N('=H870_at_>6]U<B!$0D$_at_86QL;W=S+_at_T*
M+2T_at_4G5N('1H:7,@<V-R:7!T(&9R;VT@<W%L+W!L=7,N( T*#0H-"BTM($-R
M96%T92!E>&%M<&QE('1A8FQE#0HM+2 ]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T-"F1R;W _at_=&%B;&4@=V]R:U]O<F1E<G,-"B\-"@T*8W)E
M871E('1A8FQE('=O<FM?;W)D97)S("_at_-"F-O;7!A;GD)"79A<F-H87(R*#,I
M+ T*;W)D97)?;F\)=F%R8VAA<C(H,3 I+ T*;W)D97)?9&%T90ED871E*0T*
M+PT*#0II;G-E<G0_at_:6YT;R!W;W)K7V]R9&5R<R!V86QU97,@*"=!0D,G+"<Q
M,# P)RP_at_=&]?9&%T92_at_G,3DY.2\P,R\P-2<L)WEY>7DO;6TO9&0G*2D-"B\-
M"FEN<V5R="!I;G1O('=O<FM?;W)D97)S('9A;'5E<R H)T%"0R<L)S$P,#$G
M+"!T;U]D871E*"<Q.3DY+S S+S W)RPG>7EY>2]M;2]D9"<I*0T*+PT*:6YS
M97)T(&EN=&\_at_=V]R:U]O<F1E<G,@=F%L=65S("@G04)#)RPG,3 P,B<L('1O
M7V1A=&4H)S$Y.3DO,#,O,#8G+"=Y>7EY+VUM+V1D)RDI#0HO#0II;G-E<G0_at_
M:6YT;R!W;W)K7V]R9&5R<R!V86QU97,_at_*"="0T0G+"<Q,# R)RP@=&]?9&%T
M92_at_G,3DY.2\P,R\P-B<L)WEY>7DO;6TO9&0G*2D-"B\-"FEN<V5R="!I;G1O
M('=O<FM?;W)D97)S('9A;'5E<R H)T)#1"<L)S$P,#4G+"!T;U]D871E*"<Q
M.3DY+S S+S$U)RPG>7EY>2]M;2]D9"<I*0T*+PT*8V]M;6ET#0HO#0H-"BTM
M($-R96%T92!086-K86=E+B _at_3F%M93H_at_85]D96UO#0HM+2 ]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T-"D-214%412!/4B!215!,04-%(%!!
M0TM!1T4_at_85]D96UO($E3#0H-"B!465!%(&UY7W)E<W5L=%]S970_at_25,_at_4D5&
M($-54E-/4B!215154DX_at_=V]R:U]O<F1E<G,E4D]75%E013L-"@T*14Y$(&%?
M9&5M;SL-"B\-"_at_T*#0HM+2!#<F5A=&4_at_4')O8V5D=7)E+B @3F%M93H@<')O
M8U]D96UO#0HM+2 _at_4F5F97)E;F-E<R!P86-K86=E(&%?9&5M;PT*+2T@/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]#0I#4D5!5$4_at_3U(@4D50
M3$%#12!04D]#14154D4_at_<')O8U]D96UO("AO=71?<F5S=6QT($E.($]55"!A
M7V1E;6\N;7E?<F5S=6QT7W-E="D-"B!!4PT*#0H_at_0D5'24X-"@T*+2T@<F5T
M=7)N(')E<W5L="!T;R!D871A=VEN9&]W#0H_at_($]014X@;W5T7W)E<W5L= T*
M("!&3U(_at_4T5,14-4("H_at_1E)/32!W;W)K7V]R9&5R<SL-"@T*14Y$('!R;V-?
M9&5M;SL-"B\-"_at_T*#0HM+2 ]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T-"BTM(%-I;6EL87(_at_97AA;7!L92P_at_8G5T(&YO=R!U<VEN9R!O;F4@
M<F5T<FEE=F%L(&%R9W5M96YT#0H-"BTM($-R96%T92!086-K86=E+B _at_3F%M
M93H_at_85]D96UO,_at_T*+2T@/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]#0I#4D5!5$4_at_3U(@4D503$%#12!004-+04=%(&%?9&5M;S(@25,-"@T*
M(%194$4_at_;7E?<F5S=6QT7W-E="!)4R!2148_at_0U524T]2#0H_at_4D5455).('=O
M<FM?;W)D97)S)5)/5U194$4[#0H-"D5.1"!A7V1E;6\R.PT*+PT*#0H-"BTM
M($-R96%T92!0<F]C961U<F4N("!.86UE.B!P<F]C7V1E;6\R#0HM+2 _at_4F5F
M97)E;F-E<R!P86-K86=E(&%?9&5M;S(-"BTM(#T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/0T*0U)%051%($]2(%)%4$Q!0T4_at_4%)/0T5$55)%
M('!R;V-?9&5M;S(_at_*&%S7V-O;7 @24X_at_5D%20TA!4C(L(&]U=%]R97-U;'0@
M24X_at_3U54(&%?9&5M;S(N;7E?<F5S=6QT7W-E="D-"B!!4PT*#0H_at_0D5'24X-
M"_at_T*+2T@<F5T=7)N(')E<W5L="!T;R!D871A=VEN9&]W#0H@($]014X@;W5T
M7W)E<W5L= T*("!&3U(_at_4T5,14-4("H_at_1E)/32!W;W)K7V]R9&5R<PT*"5=(
M15)%(&-O;7!A;GD_at_/2!A<U]C;VUP.PT*#0I%3D0@<')O8U]D96UO,CL-"B\-
M"_at_T*#0HM+2!#<F5A=&4_at_4')O8V5D=7)E+B @3F%M93H@<')O8U]D96UO,_at_T*
M+2T_at_(%)E9F5R96YC97,@<&%C:V%G92!A7V1E;6\R80T*+2T@/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]#0I#4D5!5$4_at_3U(@4D503$%#12!0
M4D]#14154D4_at_<')O8U]D96UO,F$@*&%D7V]R9&5R9&%T92!)3B!$051%+"!O
M=71?<F5S=6QT($E.($]55"!A7V1E;6\R+FUY7W)E<W5L=%]S970I#0H_at_05,-
M"_at_T*($)%1TE.#0H-"BTM(')E='5R;B!R97-U;'0@=&\@9&%T87=I;F1O=PT*
M("!/4$5.(&]U=%]R97-U;'0-"B _at_1D]2(%-%3$5#5" J($923TT@=V]R:U]O
M<F1E<G,-"_at_E72$5212!O<F1E<E]D871E(#T_at_861?;W)D97)D871E.PT*#0I%
M3D0_at_<')O8U]D96UO,F$[#0HO#0H-"@T*+2T@/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]#0HM+2!3:6UI;&%R(&5X86UP;&4L(&)U="!N;W<_at_
M=7-I;F<_at_;VYE(')E=')I979A;"!A<F=U;65N="!A;F0@<F5C;W)D('1Y<&4-
M"_at_T*+2T_at_0W)E871E(%!A8VMA9V4N("!.86UE.B!A7V1E;6\S#0HM+2 ]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T-"D-214%412!/4B!215!,
M04-%(%!!0TM!1T4_at_85]D96UO,R!)4PT*#0H_at_5%E012!T:&5?<F5C;W)D7W-E
M="!)4R!214-/4D0_at_* T*"6QS7V-O;7!A;GD)"79A<F-H87(R*#,I+ T*"6QL
M7V]R9&5R7V-O=6YT"6YU;6)E<B_at_S*2D[#0H-"B!465!%(&UY7W)E<W5L=%]S
M970_at_25,_at_4D5&($-54E-/4CL-"@T*(%)%5%523B!T:&5?<F5C;W)D7W-E=#L-
M"_at_T*14Y$(&%?9&5M;S,[#0HO#0H-"@T*+2T_at_0W)E871E(%!R;V-E9'5R92X@
M($YA;64Z('!R;V-?9&5M;S,-"BTM("!2969E<F5N8V5S('!A8VMA9V4_at_85]D
M96UO,PT*+2T_at_/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]
M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]#0I#
M4D5!5$4_at_3U(@4D503$%#12!04D]#14154D4@<')O8U]D96UO,R H87-?8V]M
M<"!)3B!605)#2$%2,BP_at_;W5T7W)E<W5L="!)3B!/550_at_85]D96UO,RYM>5]R
M97-U;'1?<V5T*0T*($%3#0H-"B!"14=)3_at_T*#0HM+2!R971U<FX@<F5S=6QT
M('1O(&1A=&%W:6YD;W<-"D]014X_at_;W5T7W)E<W5L= T*"49/4B!314Q%0U0@
M8V]M<&%N>2P_at_8V]U;G0H*BD@#0H)1E)/32!W;W)K7V]R9&5R<PT*"5=(15)%
M(&-O;7!A;GD_at_/2!A<U]C;VUP#0H)1U)/55 @0ED_at_8V]M<&%N>3L-"@T*14Y$
5('!R;V-?9&5M;S,[#0HO#0H-"_at_T*
`
end