Re: How to achieve LOV using OAS 4.0.8.1 using PL/SQL cartridge

Check out the attached sql code. This one may or may not work, but the concept is to loop through a cursor to build the selections.

"sachinc" <sachin_vcNOsaSPAM_at_yahoo.com.invalid> wrote in message news:02000cac.5d3d898e_at_usw-ex0109-066.remarq.com...
> Hi folks,
> I am developng a application in OAS 4.0.8.1. I want to
> write a procedure which will generate the LOV similar to the
> LOV control given in forms. If anyone of you have already
> put in efforts in this then I would be highly greatful to
> him if he can give me some guidelines for this.
>
> Regards,
> Sachinc.
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

begin 666 LOV.sql
M0U)%051%($]2(%)%4$Q!0T4_at_4%)/0T5$55)%(%1E<W1?3$]6($%3( T*"4-5 M4E-/4B!E;7!?8W5R($E3#0H)"5-%3$5#5"!E;F%M90T*"0E&4D]-(&5M<#LM" _at_T*;%].86UE("!V87)C:&%R,B_at_S,C P*3L-"@T*0D5'24X-"@EH=' N:'1M M;$]P96X[#0H):'1P+FAE861/<&5N.PT*"6AT<"YT:71L92_at_@)T5M8F5D9&5D M(%!,+U-13"!%87AA;7!L92<I.PT*"6AT<"YH96%D0VQO<V4[#0H):'1P+F)O M9'E/<&5N.PT*"6AT<"YH96%D97(H(#$L("=%;7!L;WEE92!.86UE<R<I.PT* M"6AT<"YF;W)M3W!E;B_at__at_8W5R;" ]/B G+2U714)"3U0M4T5,1BTM)RP_at_8VUE M=&AO9" ]/B G4$]35"<I.PT*"6AT<"YP<FEN="_at_@)SPA+2UW96)B;W0_at_8F]T M/2)3879E4F5S=6QT<R(_at_52U&:6QE/2)?<')I=F%T92]F;W)M7W)E<W5L=',N M='AT(B!3+49O<FUA=#TB5$585"]#4U8B)R!\?" -"_at_D))R @4RU,86)E;"U& M:65L9',](E12544B("TM/B<_at_*3L-"@EH=' N<&%R83L-"@EH=' N9F]R;5-E M;&5C=$]P96XH(&-N86UE(#T^("=,3U8G+"!N<VEZ92 ]/B G,2<_at_*3L-"@T* M"49/4B!E;7!?<F5C($E.(&5M<%]C=7(_at_3$]/4" -"B @(" @(" @(" @(" @ M(" _at_(" @(" @(" @(" @(" @:'1P+F9O<FU396QE8W1/<'1I;VXH("=E;7!? M<F5C+F5N86UE)RP_at_8V%T=')I8G5T97,@/3X@)R!V86QU93TB96UP7W)E8RYE M;F%M92(G*3L-"_at_T*"45.1"!,3T]0.R -"@EH=' N9F]R;5-E;&5C=$-L;W-E M.PT*"6AT<"YF;W)M0VQO<V4[#0H):'1P+F)O9'E#;&]S93L-"_at_EH=' N:'1M 2;$-L;W-E.PT*14Y$.PT*+PT*
`
end Received on Mon Mar 13 2000 - 04:11:38 CET