di procedure bisa pakai execute immediate untuk dynamic query, atau bahkan ekseskusi DDL. Cara lama biasa pakai dbms_sql.
On 9/26/05, Herman <[EMAIL PROTECTED]> wrote: > > DH, > > Di report developer, kita bisa pasang after report trigger untuk binding > variable > > contoh : > > if :p_1 = 'all' then > :p_where1 = '' ; > else > :p_where1 = 'a.foobar = :p_1; > end if ; > > di querynya kita tinggal pasang &p_where1 dalam wherenya... > > kalau di store procedure atau function gitu.. kita bisa lakuin hal yang > sama gak ? atau ada cara untuk mengakalinya ? > karena procedure tidak bisa call trigger. > > > thanks, > > Herman > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS > Membership database > software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> > Database > mortgage > software<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> > Pda > database > software<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> > Database > management > software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> > Oracle > database > administration<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+administration&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q> > Oracle > database > management<http://groups.yahoo.com/gads?t=ms&k=Oracle+database+management&w1=Membership+database+software&w2=Database+mortgage+software&w3=Pda+database+software&w4=Database+management+software&w5=Oracle+database+administration&w6=Oracle+database+management&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "indo-oracle<http://groups.yahoo.com/group/indo-oracle>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > -- ------------------------------------------------------------------------------------------------------------------------------------------ >> Semulia-mulia kekayaan milik pribadi adalah meninggalkan banyak keinginan [Imam Ali r.a] >> Everyone dies, but not everyone really lives [William Wallace, Braveheart] >> Death come to us all ... [Princess Wales, Braveehart] ------------------------------------------------------------------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
